Problem connection with MYSQL database from PI 7.0

[Former Member]

Hi experts.

We are facing problems trying to connect to a MYSQL database from PI 7.0. We are getting the next 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://xxxxxxxx.com:3306/xxxxxxx': UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major version at offset=6.

We've already tested the deployed driver from a JDBC client and it works correctly.

Could it be a problem with the Java Virtual Machine used by PI 7.0 (1.4)?

Tank u so much.

Best regards.

[baskar_gopalakrishnan2]

>Cannot establish connection to URL 'jdbc:mysql://xxxxxxxx.com:3306/xxxxxxx': UnsupportedClassVersionError: (com/mysql/jdbc/Driver) bad major version at offset=6.

JDBC Drivers are based on the java version. If you install jdbc drivers that is not compatible for jdk 1.4 then you get this class version error. Please download jdbc drivers for MYSQLDB which supports jdk 1.4 and install the same in PI.   

[rajasekhar_reddy14]

Hi Chico,

You have not deployed correct MySQL  driver in PI system,check which version MYSQL server are you connecting from PI and used right driver.

google it or check mysql web site for correct driver.

Thank you