JDBC Sender Exception

[Former Member]

Hi,

We are getting following error when JDBC sender communication channel trying to connect one of our legacy database to read the DB table.

Error during database connection to the database URL
'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXXXXXXXXX)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=XXXXXXXXX))'
using the JDBC driver 'oracle.jdbc.driver.OracleDriver':
'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish
connection with the registered driver. oracle.jdbc.driver.OracleDriver returns:
IO Error: NL Exception was generated. : SQLRecoverableException: IO Error: NL
Exception was generated'

* Port was opened so no firewal issues.

*The same is working fine for Test environment.

Please share your expertize to find the root cause.

Regards,

Siva.

[Former Member · Accepted solution]

Hi,

It's the problem with url. Corrected the url and working fine.

Regards,

Siva.