Re: Mysql connector/j v 5.1.7

[Todd Farmer]

Hello Leonid,

Yes, there are more recent versions of MySQL Connector/J - the most current is 5.1.21 and available here:

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

I doubt that will resolve your problem, though - I presume the CREATE TABLE commands being issued (and including the now-unsupported TYPE = InnoDB syntax) are defined in your application. Upgrading the driver won't cause the commands to be transformed into the equivalent ENGINE = InnoDB syntax. You will need to do that yourself - either with changes to the application code, or you can write a StatementInterceptor to do the transformation for you:

http://mysqlblog.fivefarmers.com/2011/10/17/connectorj-extension-points-statement-interceptors/

Of course, the default storage engine in 5.5 is InnoDB, so you don't have to explicitly define that in your CREATE TABLE commands, so you can just remove the TYPE=InnoDB clause entirely.

Hope that helps,