Unable to connect to data base

[former_member192238]

Hello Experts,

My sender Jdbc channel is not able to connect to MYSQL database it is throwing an error Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: com.mysql.jdbc.Driver. : SAPClassNotFoundException: com.mysql.jdbc.Driver'

My other interfaces which connects to Oracle database is working fine i didnt deploy any drivers for Oracle because AIX Operating system will have divers by default but it is not happening with MYSQL

Experts please throw light on this isuue

Regards

Praveen Reddy

Edited by: Maareddy Praveen Reddy on Sep 27, 2011 11:46 AM

[naveen_chichili · Accepted solution]

Hi Praveen,

Check if JDBC drivers are properly installed in your server....

Also check if there is any frewall issues while connecting to Database from your PI server.check if your firewall ports are open connecting to DB.

also try to restart your JDBC channel if all the above are fine.

Regards,

Naveen

[Former Member]

You need to deploy MySQL Jdbc drivers in your PI System.

You can follow this document to achieve this issue:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

Here the JDBC drivers for MySQL (i don't know your MySQL database version....):

http://www.mysql.com/downloads/connector/j/

[former_member192238]

Thanks @ every one for valuable inputs

I am using PI 7.1 version the link provided by the expert

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

it is showing for XI3.0 is it valuable for 7.1 also? if not how to deploy JDBC drivers for PI 7.1

Regards

Praveen

[Former Member]

Sure. DEPLOYING JDBC DRIVERS IN PI 7.1X SYSTEMS :

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/8000cffc-6b92-2d10-3493-f2ac1399242f

[former_member192238]

Thanks a lot spantaleoni

I have shared your inputs with my Basis guys

Regards

Praveen

[Eoin_Kierans]

I would recommend deploying the JDBC drivers as per the note #1138877 'PI 7.1 : How to Deploy External Drivers JDBC/JMS'.

You can also check the following notes:

831162 'FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter'

1085539 'JDBC/FTP connection Test and XML Validation'