Problem Creating a new repository

[rajukvg]

Hi ,

Just downloaded Kettle and trying to create a new repository. Getting the following problem. (Installation is on Windows XP) . Tried two options, both are giving me problems

With OCI -- I found the ocijdbc10 file from my oracle installation and placed in the following path D:\dev\Apps\lib.Apps is where i extracted the kettle software. Can some one help me with this.

Error connecting to database [krep] : org.pentaho.di.core.exception.KettleDatabaseExcept ion:
Error occured while trying to connect to the database
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
no ocijdbc10 in java.library.path

org.pentaho.di.core.exception.KettleDatabaseExcept ion:
Error occured while trying to connect to the database
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
no ocijdbc10 in java.library.path

at org.pentaho.di.core.database.Database.normalConnec t(Database.java:302)
at org.pentaho.di.core.database.Database.connect(Data base.java:251)
at org.pentaho.di.core.database.Database.connect(Data base.java:213)
at org.pentaho.di.core.database.Database.connect(Data base.java:203)
at org.pentaho.di.core.database.DatabaseMeta.testConn ection(DatabaseMeta.java:2513)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.test(DatabaseDialog.java:1921)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.test(DatabaseDialog.java:1903)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log$4.handleEvent(DatabaseDialog.java:313)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unkno wn 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(Un known Source)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.open(DatabaseDialog.java:388)
at org.pentaho.di.ui.repository.dialog.RepositoryDial og$1.widgetSelected(RepositoryDialog.java:179)
at org.eclipse.swt.widgets.TypedListener.handleEvent( Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unkno wn 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(Un known Source)
at org.pentaho.di.ui.repository.dialog.RepositoryDial og.open(RepositoryDialog.java:296)
at org.pentaho.di.ui.repository.dialog.RepositoriesDi alog$3.widgetSelected(RepositoriesDialog.java:315)
at org.eclipse.swt.widgets.TypedListener.handleEvent( Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unkno wn 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(Un known Source)
at org.pentaho.di.ui.repository.dialog.RepositoriesDi alog.open(RepositoriesDialog.java:422)
at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java :5173)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:536 4)
at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5457)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:359)
Caused by: org.pentaho.di.core.exception.KettleDatabaseExcept ion:
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
no ocijdbc10 in java.library.path
at org.pentaho.di.core.database.Database.connectUsing Class(Database.java:423)
at org.pentaho.di.core.database.Database.normalConnec t(Database.java:286)
... 30 more
Caused by: java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java :1682)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:993)
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnecti on.java:3139)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary (T2CConnection.java:3135)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnecti on.java:221)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:420)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnect ion.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnectio n(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:801)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:140)
at org.pentaho.di.core.database.Database.connectUsing Class(Database.java:414)
... 31 more
Hostname : dev1
Port : 1521
Database name : dvware1

Similar problem happens if i connect thru Native JDBC


Regards,
Raju

[MattCasters]

Perhaps you should post in the correct forum.
Or read the documentation on how to set up Oracle with OCI. In the Spoon documentation in the Connections chapter.

[rajukvg]

Thanks MattCasters, I could follow the suggestions provided in the document and was able to resolve it.

Regards,
Raju