Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problem Creating a new repository

  1. #1

    Default Problem Creating a new repository

    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.KettleDatabaseException:
    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.KettleDatabaseException:
    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.normalConnect(Database.java:302)
    at org.pentaho.di.core.database.Database.connect(Database.java:251)
    at org.pentaho.di.core.database.Database.connect(Database.java:213)
    at org.pentaho.di.core.database.Database.connect(Database.java:203)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2513)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1921)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:1903)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:313)
    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:388)
    at org.pentaho.di.ui.repository.dialog.RepositoryDialog$1.widgetSelected(RepositoryDialog.java:179)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:296)
    at org.pentaho.di.ui.repository.dialog.RepositoriesDialog$3.widgetSelected(RepositoriesDialog.java:315)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    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.repository.dialog.RepositoriesDialog.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:5364)
    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.KettleDatabaseException:
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    no ocijdbc10 in java.library.path
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:423)
    at org.pentaho.di.core.database.Database.normalConnect(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(T2CConnection.java:3139)
    at java.security.AccessController.doPrivileged(Native Method)
    at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3135)
    at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
    at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
    at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.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.connectUsingClass(Database.java:414)
    ... 31 more
    Hostname : dev1
    Port : 1521
    Database name : dvware1

    Similar problem happens if i connect thru Native JDBC


    Regards,
    Raju

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    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.

  3. #3

    Default Problem Creating a new repository

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

    Regards,
    Raju

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.