Mysql DataBase connectivity with PI 7.1

[monikandan_p]

Dear Experts,

        I need to connect Mysql DB table to access the data using PI 7.1 and pass it to ECC RFC.

I have configured the sender JDBC channel details as below

JDBC Driver : com.mysql.jdbc.Driver

Connection : jdbc:mysql://<Server>:<port>/<database>

But it showing the below error while starting my Sender channel in RWB.

We already install the above driver  com.mysql.jdbc.Driver in PI again it shows the same error.

Kindly help to resolve this issue.

Best Regards,

Monikandan

[former_member188885 · Accepted solution]

Hi Monikandan,

Looks like the driver installation was done properly. You need to check if the installation was proper and re-deploy with proper steps.

Refer https://scn.sap.com/thread/400726.

Regards,

Lavanya R

[monikandan_p · Accepted solution]

Hi Lavanya,

Issue fixed,the problem with the improper driver installation.Now its working fine.

Thanks.

Best Regards,

Monikandan.

[former_member345543]

I received correct driver and deployed the same. Issue resolved.

[former_member345543]

I received correct driver and deployed the same. Issue resolved.

[former_member345543]

Hi Team,

I installed "mysql-connector-java-8.0.30.jar" maybe this is not the correct driver. can anyone help me with correct MYSQL JDBC driver.

Thanks

Syed Tufail Kazmi

[Former Member]

Hello, Monikandan--

Can you ping the DB from PI box? try this first.

Cheers

Fouad