Hi. Do you happen to be using MySQL 4.1.x? Slide's MySqlRDBMSAdapter executes some SQL delete statements that are rejected by that version (check out the subject: "JDBCStore with MySQL problem"). These statements throw SQL exceptions that ultimately close the connection. Unico Hommes has committed a new adapter, org.apache.slide.store.impl.rdbms.MySql41RDBMSAdapter, that can be found in CVS.
Another source of trouble I've ran into is that MySQL connections are in autocommit mode by default. The J2EE store included in Slide 2.1M1 doesn't take care of turning off autocommit. However, there is an updated version in CVS that does handle this problem. Actually, you should download the most current versions of StandardRDBMSAdapter (bug fixes) and MySqlRDBMS adapter (sequence support) to get the best available adapter for MySQL. -Alejandro --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
