Exception getting while connecting to MySQL DB

[Former Member]

Hi,

I am working in a migration J2ee project. The project uses MySQL as backend. I have registered the JDBC driver for MySQL DB to SAP WAS using Visual Administration Console. I have created the Datasource also with the registered driver and deployed. But when i connect to the DB, I am getting SQL Exception as given below,

<b>"com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: com.sap.sql.log.OpenSQLException: Porting factory for MYSQL database not defined."</b>

The driver details in Datasource configuration file is defined as follows,

<b><jdbc-1.x>

<driver-class-name>com.mysql.jdbc.Driver</driver-class-name>

<url>jdbc:mysql://localhost:3306/TestDB</url>

<user-name>test</user-name>

<password>**********</password>

</jdbc-1.x></b>

I am using the JDBC Driver found in <b>"mysql-connector-java-3.1.8-bin.jar"(Which is downloaded from MySQL site)</b>

Could you please share your knowledge in this regard? If I am using the wrong JAR, Then which is the suitable jar and where can i found it?

Kindly help,

Sudheesh...

[Opgenorth]

Hello Sudheesh,

open the tab 'Additional' for this pool in the Visual Administrator and choose 'Vendor SQL' at the bottom.

Best regards,

Juergen