Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Re:JDBC Communication Channel

Hi,

I am getting the following error in Communication channel of JDBC:

Error during database connection to the database URL 'jdbc:oracle:thin:@host:port:SID' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SQLException: Io exception: The Network Adapter could not establish the connection'

Connection Parameters in CC are as :

Connection: 'jdbc:oracle:thin:@host:port:SID'

Drivers: 'oracle.jdbc.driver.OracleDriver'

If I change Connection Parameters in CC as:

Connection: 'jdbc.oracle.thin.@host:port:SID'

Drivers: 'oracle.jdbc.driver.OracleDriver'

Then I recieve the following error:

Error during database connection to the database URL 'jdbc.oracle.thin.@KFTDERSHAPP14:1521:CTAQ' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection:'

Oracle system is on 10G

PI 7.1 Basis team mentioned ojdbc14.jar are already installed on PI Server. Can any one light on this issue?

Thanks

Santosh.

Thanks

Santosh

Former Member
Not what you were looking for? View more on this topic or Ask a question