hello all,

I'm using the 3.0.7 release, and mysql-max 4.04 on solaris 5.8

something has recently changed in my codebase where transactions are no longer being committed when the same jvm spawns multiple threads, each with its own database connection. when I run with a single connection, transactions are committed fine. Its all the same code, whether a single connection is made or multiple connections. the user is the same for all connections.

When the commit method is called on the connection, no errors are thrown, and debugging code indicates a new row has been added. all of my tables have an auto_increment id field, and after the alleged successful insert, I issue a "select max(id) from <tablename>" and watch that the id has in fact been incremented. However, if I simultaneously issue the same max(id) query from a mysql command line, there is no record of the new row when running multiple connections within the same jvm, but there is when there is only a single connection. Weird thing is is even though the mysql prompt query shows no record of the new insert, its apparently there because I get a unique constraint violation later in the insert process.