cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Sender Channel problem. Pls help

Former Member
0 Kudos

Hi,

In JDBC Sender Channel in Connectiion String I am giving value

jdbc:oracle:thin:@cscappnoi022.asiapac.globalcsc.net:1527:IS1

where cscappnoi022.asiapac.globalcsc.net---is where Oracle server is installed

1527 --- is my Port

IS1 is my system SID --- Pls let me what value should come here and how to find.

I am getting error

"Error during database connection to the database URL 'jdbc:oracle:thin:@cscappnoi022.asiapac.globalcsc.net:1527:IS1' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@cscappnoi022.asiapac.globalcsc.net:1527:IS1': SQLException: Io exception: The Network Adapter could not establish the connection'"

Regards

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi...

Speicfy the connection Parameters as specified below

Jdbc Driver: oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin:@ipaddress:1521:Database Server name

Thanks & Regards,

Leela

JoelTrinidade
Active Contributor
0 Kudos

hi,

Your connection should be :

jdbc:oracle:thin:hutting/hutting@105.28.09.677:1521:pnt

jdbc driver should be:

oracle.jdbc.driver.OracleDriver

Regards

joel.

I only hope that your other jdbc scenarios are working fine , this is just to rule out the possibility of driver related errors.

JoelTrinidade
Active Contributor
0 Kudos

Hi Rick,

This error

The Network Adapter could not establish the connection

. Usually comes up for me when the LAN Network is busy or the network is down for backup activity. I re run my scenario and all is fine.

So you to just re run your scenario and i guess everything would be fine.

Regards

joel