Re: concurrency problem on mysql5?

At 05:43 AM 7/29/2006, you wrote: Dear list, we are running a Mysql 5.0.22 server that is accessed by a number of java web applications (jdbc driver 3.1) over the network. The database layer was realized using the Cayenne framework and InnoDB was chosen as the table type. All applications share

Re: concurrency problem on mysql5?

Hello! Am 30.07.2006 um 18:40 schrieb mos: The Cayenne framework is using a a single table to keep the primary keys (PK) for its objects. The method accessing this table is surrounded by lock / unlock commands, so no other thread can read the same PK from the table while another thread is

Re: concurrency problem on mysql5?

At 12:40 PM 7/30/2006, you wrote: Hello! Am 30.07.2006 um 18:40 schrieb mos: The Cayenne framework is using a a single table to keep the primary keys (PK) for its objects. The method accessing this table is surrounded by lock / unlock commands, so no other thread can read the same PK from the

concurrency problem on mysql5?

Dear list, we are running a Mysql 5.0.22 server that is accessed by a number of java web applications (jdbc driver 3.1) over the network. The database layer was realized using the Cayenne framework and InnoDB was chosen as the table type. All applications share the same database because