Discussion

No suitable driver found

Hi,

 

I have installed oracle 10g and trying to connect to it. I have created a DB instance nd using the following URL jdbc:oracle:thin:@localhost:8080:XE in the DB data instance. But it is throwing me the following error when i click on test connectivity.

 

Status Value: Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:oracle:thin:@localhost:8080:XE 

 

What drivers do i need to put in the directory ? can any one help me.

 

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

May 20, 2013 - 5:24am

Hi 

You can download the OJDBC driver from the oracle site for this and include it in your tomcat lib folder.

The file depends on the version of your jdk. If your using jdk 1.4 for example the file is ojdbc14.jar. 
 

Then you need to uncomment the below line in the prconfig file:

<env name="database/drivers" value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" />

 

Restart tomcat server and test the connection. 

 

If you are using Oracle 11g then you need to use the ojdbc6.jar driver file.

 

Pega
February 16, 2015 - 7:38am

The setting <env name="database/drivers" value="com.microsoft.sqlserver.jdbc.SQLServerDriver;oracle.jdbc.OracleDriver" /> can't be replace by a Dynamic System Setting.

 

It has to be configured in prconfig.xml. Up to Pega 7.1 ML7 it is not supported as a Dynamic System Setting (no idea what the future will bring).