Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: com.mysql.jdbc.Driver

[nageswararao_v2]

Hi Everyone,

i am doing a scenario PROXY to JDBC ( MYSQL 6.0 ).

the receiver channel JDBC was giving the error like bekow.

ERROR:-

JDBC message processing failed; reason Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: com.mysql.jdbc.Driver.
: SAPClassNotFoundException: com.mysql.jdbc.Driver

i understood that i have to install the MYSQL drivers where can i get these drivers.

Thanks

Nagesh.

[iaki_vila · Accepted solution]

Hi NageswaraRao,

This thread could be helpful and this note   1138877 - How to Deploy External Drivers JDBC/JMS Adapters

Regards.

[nageswararao_v2 · Accepted solution]

Dear All,

Problem got resolved by cchanging the connection URL

jdbc:microsoft:sqlserver://host:port;databaseName=***

Thank you for all.

[former_member182412]

Hi

You need to get the driver from your MySQl database team (if not try this MySQL :: Download Connector/J).

once you get the driver you need deploy it using below blogs.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...