error: when connecting to SAP XI to Mysql database server.

[Former Member]

Hi,

I am getting this error when am trying to connect SAP XI to Mysql server.

Can any body tell me how to resolve this error.

Error during database connection to the database URL 'jdbc:mysql://172.17.120.98:3306/portal' using the JDBC driver 'com.mysql.jdbc.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:mysql://172.17.120.98:3306/portal': SAPClassNotFoundException: com.mysql.jdbc.Driver'

My Databse connection variables as listed below.

JDBC Driver:com.mysql.jdbc.Driver

Connection: jdbc:mysql://localhost:3306:portal

[Former Member · Accepted solution]

I have never use Mysql

but how to deploy jar file is same as orable, mssql

please check this artible

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f

the way to deploy is same!

Thanks naoki!

[Former Member · Accepted solution]

Thanks guys...

[Former Member]

Hi,

Thanks for ur reply..

Please any body tell me how to install mysql jar file on sap xi server.

Please share any deployeement user guide if u have..

thanks in advance..

[venky_b]

Hi,

Check wheather JDBC driver for mysql is intalled in your J2ee engine or not. Plz find the threads below.

http://blog.chinaunix.net/u1/54114/showart_972697.html

also go over the note:

Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Note 941317 - known incompatibilities,

Thanks,

Venky

[Former Member]

Hi,

Your error is related to the driver not found..

Ask your basis to deploy the driver for your database...check or search SDN for more details of the driver class details and the procedure for installing the same in the PI server....

HTH

Rajesh