JDBC channel

[rasjoshi]

Hi All,

We have a requirement to push and pull messages from Oracle 11g. we are using JDBC channel.

We got ojdbc7.jar file.

But getting below error -

Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: IO Error: Invalid number format for port number.
: SQLRecoverableException: IO Error: Invalid number format for port number'.

Syntax for URL -

jdbc:oracle:thin:@[HOST][:1521]:SID

Is my port number wrong here?

Also, how to check whether I have thin drivers or any other?

BR,

Rashmi

[pvishnuvardan_reddy]

Hi Rashmi,

Please find below the note on how to check the jdbc drivers installed on PO system or not.

1829286 - PI: How to check which drivers are installed for the JMS and JDBC Adapters

Regarding the error, please check with your db team on the server port & host parameters.

[vishnu_pallamreddy]

Hi Rashmi,

Please check with DB team whether you are using correct Port or not.

make sure to check drivers installed or not in PI.

Please check whether you are providing valid connection parameters or not.

[Former Member]

Hi Rashmi,

I hope port is fine.

Please check connectivity with proper host name and Service host like :

e.g.

jdbc:oracle:thin:@localhost:1521:XE

And before check make sure that your jar is installed in Po box.

Thanks,

Gourav