I'm trying to use J2EEStore with MySql (with adapter :-)) ). I also modifed this store in order to support DBCP.
Unfortunatly, I got some deadlock issues when this store makes some delete.
Do you know how to solve this problem ?
Without deletes, everything works fine, I can run 100 threads without any problems but when one thread starts a delete I got a deadlock.
Any help is welcome. So, I'm looking for a J2EE store wich is working with MySql
Which J2EE do you use, the one posted by Ashok or the one in the CVS? I just found the order of deletes endangers refential integrety. Do not know how MySql with tx reacts upon this. How to you specify foreign keys in MySql?
If not aleady done try to reverse deletion order of VERSION_HISTORY and VERSION, i.e. VERSION_HISTORY first.
Oliver
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
