Thursday, May 21, 2015

Pentaho Data Integration Report JAVA Error 'oracle.jdbc.driver.OracleDriver' could not be found

My Windows crashed.

Have to re-install Pentaho Data Integration 5.3 stable.

When I try to connect Oracle Database with JDBC.

It report JAVA Error 'oracle.jdbc.driver.OracleDriver' could not be found!

 

Lots of google and try uninstall/install different Version of Java (8,7,6 even 5!) and 32 bit as well.
None of them works.

I also try to add java path to env:

REM by Lambert 2015.05.21
set _PENTAHO_JAVA_HOME=C:Javajre1.8.0_45
set _PENTAHO_JAVA=C:Javajre1.8.0_45binjava.exe
set PENTAHO_JAVA_HOME=C:Javajre1.8.0_45

Not working either!!!

At the end I found this: https://stackoverflow.com/questions/20395453/unable-to-connect-to-oracle-via-pentaho-oracle-jdbc-driver-oracledriver-could/22709146#22709146

  1. First I go to Oracle Site: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

  2. Then download 1 file: ojdbc6.jar (2,739,670 bytes) - (SHA1 Checksum: a483a046eee2f404d864a6ff5b09dc0e1be3fe6c)
    Classes for use with JDK 1.6. It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

  3. Copy it into my Pentaho folder: C:Program FilesPentahodata-integrationlib


That fix everything!

I thought it would be better to share it.

3 comments:

  1. I have read so many articles or reviews about the blogger lovers however this
    article is really a nice piece of writing, keep it up.

    ReplyDelete
  2. WOW just what I was looking for. Came here by searching
    for Cracked Heels and Splitting Skin

    ReplyDelete