Error connecting to Oracle Database from Pentaho Report Designer

Asked By 0 points N/A Posted on -
qa-featured

Hello everyone,

I am a new user of Pentaho, and am trying to setup a new database connection. When I am going to connect to an Oracle 10g database to test the connection, I face this error message below. It doesn’t look like an error message, that’s why I am unable to understand to what to do next.

In my tomcat.lib folder, I put ojdbc.jars and I think I made a wrong attempt. Any suggestion would be greatly appreciated.

Errors are:

 

  • Error connecting to database [OFF SSP Cert] : org.pentaho.di.core.exception.KettleDatabaseException:
  • Error occurred while trying to connect to the database.
 
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
 
  • oracle/dms/instrument/ExecutionContextForJDBC
  • org.pentaho.di.core.exception.KettleDatabaseException:
 
Error occurred while trying to connect to the database.
 
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
 
  • oracle/dms/instrument/ExecutionContextForJDBC
 
Can you help me?
 
Thanks in advance.
SHARE
Answered By 0 points N/A #94964

Error connecting to Oracle Database from Pentaho Report Designer

qa-featured

Dear Felixthecat,

According to the error message u have got, it seems that u r using a native JDBC driver. U should make sure that the native libraries are there and can be read at runtime. Oracle provides different types of JDBC drivers. To install the Oracle JDBC driver, java must be able to find it when called.
 
So we can add the driver file location to the java classpath or simply place the driver into the java standard directory for extensions (jre/lib/ext). Try now to connect again to the database and you'll find the problem solved.
 
Hope this may help you.
 
Best of luck.

Login/Register to Answer

Related Questions