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
- First I go to Oracle Site: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
- 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. - Copy it into my Pentaho folder: C:Program FilesPentahodata-integrationlib
That fix everything!
I thought it would be better to share it.
