OpenSQL and Mysql

[Former Member]

I would like to test connecting to MySQL DB using the opensql driver instead of the native MySql Driver.

Can some tell me where I can find the OPenSQL Driver and maybe some test code with an example of how to use or do we just replace the native MYsql Driver with the OpenSQL driver name in standard code.

[Former Member]

OpenSQL doesn't support MySql in principal.

The way you use OpenSQL in standalone is by putting the opensqlsta.jar and the native driver in the classpath and then use the OpenSQL driver in your application.

Then the OpenSQL on the basis of the connection string determines which native driver it needs and basically wraps it.

This happens via driver specific porting layers in the OpenSQL implementation. Supported databasese are MSSQL, MAXDB, Oracle, DB2 on all platforms. So unless the MAXDB porting layer is capable of using the MySQL driver for some reason you will get some exception.