error while connecting to MYSQL database using JDBC receiver adapter

[Former Member]

Hi

I m trying to connect MYSQL DB with JDBC adapter , i m getting the following error :

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://192.168.51.50:3306/stagingdb': SAPClassNotFoundException: com.mysql.jdbc.Driver

I've deployed the mysql driver, checked for the uderid and password both in Visual admin and adapter , but still the problem

pl help

rgds

mojib

[Former Member]

Hi Mojib,

Its a problem with JDBC driver installation...

Go the this thread....

Regds,

Pinangshuk.

[Former Member]

> DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://192.168.51.50:3306/stagingdb':

You need to varify few things..

1. Check if the database name is correct. (I guess it is case sensitive, so be careful of case)

2. Check your firewall is open at both end. This is very important, so confirm it at receiving side as well.

3. Reconfirm the user id, password, ip address and port which you are using in your receiver CC are correct or not.

Regards,

Sarvesh

[Former Member]

Hi Sarvesh and Suraj,

Driver deployment is perfectly Ok , i redeployed it and checked it with the test page , its able to access the DB, we can see even the tables of teh database .

1) database name is rechecked, and its absolutely correct,

2) firewall is open at both ends .

3) userid and password reconfirmed at both Visual admin and CC , ip addressand port is also correct .

don't know what is the issue , pl ....some more inputs

rgds

mojib

[Former Member]

Then it seems a problem in CC configuration.

What string you have given in 'JDBC Driver' under connection tab in your CC.

[Former Member]

This is exactly what I've given

JDBC driver:com.mysql.jdbc.Driver

connection: jdbc:mysql://192.168.51.50:3306/stagingdb

user name: root

pwd: xxxxx

pl .. more inputs

rgds

mojib

[Former Member]

Let us know MYSQL Server and driver version which is installed.

-Gouri

[Former Member]

Hi Gouri

MYSQL Server version is : 5.1

Driver: mysql-connector-java-5.1.10

this is my versions

pl , ur input reqd

rgds

mojib

[former_member187339]

Hi mojib,

It is a problem with driver deployment

Check this thread and do as mentioned there

Also you can refer

Regards

Suraj