Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Gupta SQLBase Connection Spoon

  1. #1
    Join Date
    Nov 2007
    Posts
    5

    Question Gupta SQLBase Connection Spoon

    I Would like to connect to SQL Base GUPTA 9.0 DB and have tried
    adding the SQLBaseJDBC.jar driver file to the Kettle\libext\JDBC directory but no luck. Is there another setting to point the to the driver file from within spoon?
    Any help would be appreciated.
    TIA Peter

    Error message

    Error connecting to database [PROD1] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class jdbc.gupta.sqlbase.SqlbaseDriver)
    SqlbaseSession(): failure to connect to host:

    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class jdbc.gupta.sqlbase.SqlbaseDriver)
    SqlbaseSession(): failure to connect to host:

    at org.pentaho.di.core.database.Database.normalConnect(Database.java:317)
    at org.pentaho.di.core.database.Database.connect(Database.java:266)
    at org.pentaho.di.core.database.Database.connect(Database.java:228)
    at org.pentaho.di.core.database.Database.connect(Database.java:218)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2508)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1919)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1901)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:311)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:386)
    at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:77)
    at org.pentaho.di.ui.spoon.Spoon.editConnection(Spoon.java:1894)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
    at org.pentaho.xul.swt.menu.PopupMenu.handleMenuEvent(PopupMenu.java:40)
    at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
    at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:827)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5513)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5592)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:357)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class jdbc.gupta.sqlbase.SqlbaseDriver)
    SqlbaseSession(): failure to connect to host:
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:434)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:301)
    ... 30 more
    Caused by: java.sql.SQLException: SqlbaseSession(): failure to connect to host:
    at jdbc.gupta.sqlbase.SqlbaseConnection.<init>(SqlbaseConnection.java:150)
    at jdbc.gupta.sqlbase.SqlbaseDriver.connect(SqlbaseDriver.java:212)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:415)
    ... 31 more
    Hostname : server1
    Port : 2155
    Database name : PROD

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    It does find the driver... but it can't connect. Can you connect from the same machine to your database?

    Regards,
    Sven

  3. #3
    Join Date
    Nov 2007
    Posts
    5

    Default

    Yes SQLBase server is running on the local machine and I can connect through ODBC via msaccess etc.
    But I am trying to create a JDBC connection though the spoon connection.
    The spoon connection test produces the error message below.
    Best regards Peter

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Wrong parameters or so in your connection.

    Regards,
    Sven

  5. #5
    Join Date
    Nov 2007
    Posts
    5

    Default

    Thanks It was the server name field using the IP loop back.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.