Home > Solution Categories > Software Others > Business Management > Error connecting to Oracle Database from Pentaho Report Designer
Question
No of visitors who read this post: 1952
Type: Question
Author: Felixthecat
No votes yet

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

Submitted by Tibor.tokie on Mon, 2012-02-13 07:44. Comment Id: 46745

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.
Previous Previous Page
389 of 474
Next Page Next