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:

  1. First I go to Oracle Site:

  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.


  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.

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