JDBC Connection error

[Former Member]

My scenario is File 2 JDBC.

I am able to connect to DB with lower version than 10g using url

jdbc:oracle:thin:@ONE:port:DB

My DB is Updated to Oracle 10g and not able to connect using url but able to connect from sql-Developer

jdbc:oracle:thin:@TWO:port:DB (got url from by DBA)

My question is Do i need to update the Driver of Oracle 10g in PI server?

Let me know guys....

Thanks

Prabhakar

[Former Member · Accepted solution]

Hi,

You will find the appropriate .jar file here:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

For deploying, this will help:

Regards

[Former Member]

thanks

[Former Member]

Hi,

The driver for the JDBC Channel will be oracle.jdbc.driver.OracleDriver.

The driver jar can be downloaded from the Oracle site. For Oracle versions 9i and above ojdbc14.jar is used, while for lesser versions classes12.jar is used.

For deployment of the JDBC driver on PI Server refer [SAP NOTE: 1138877|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1138877]

Regards,

Alka.

[dharamveer_gaur2]

Hi

ojdbc14.jar driver download from oracle site.

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc101040.html

[Former Member]

HI Venkat,

Yes you need to deploy the new jdbc driver of Oracle 10g.

And also you need to change the configuraiton parameters in the JDBC adapter.

Regards

Goli Sridhar

[Former Member]

Can any one provide ne the following

Driver Name:

Path to deploy in PI server:

What configuration changes has to be done:

Thanks

Prabhakar

[Former Member]

yes you need to update ur Driver to Oracle 10g in PI server

[dharamveer_gaur2]

You Loaded appropriate ojdbc14.jar driver Jar file ?

Check your Parameter

url:jdbc:oracle:thin:@<ServerHostName>:<PortNo(1521 default)>:<SID>

Here SID is System Global Database Name