I have a web based application on tomcat that workes fine on Windows XP and used to work fine on Mandrake 10.1 Linux. I upgraded to Mandrivia and now the linux side does not work. I tested JDBC directly to the MySQL 4.1.12 and it works fine. When hibernate in the java web server writes to the MySQL the data gets corrupted. (only on Linux).

Mandrivia Linux, WInXP
Java 1.4.2_08 on both machines
MySQL 4.1.11-nt on windows
MySQL 4.1.12 on Linux
Connector J 3.1.7 on both machines.
hibernate 3.0-final

Any ideas why the data would get corrupted? The uid on the tables is fine. names,timestamps, etc. get corrupted?

I found a fix. The problem is the ConnectJ and hibernate and MySQL 4.1.12 have a problem with server side prepared statements.
What you do is change the JDBC connection string to be like...
jdbc:mysql://myserver.com/thedatabse?useServerPrepStmts=false

See
http://www.spikesource.com/docs/cs_1.6. ... notes.html