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

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 curre

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

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 t

Re: concurrency problem

Hi All, Thank you for u r valuable suggestions. I am trying to implement Sequence. As i should not use AUTOINCREMENT, and Locking a table will slower my application. Thank you once again.

Re: concurrency problem

anted mysql to handle the "unique" id. MySQL would return only the minorid (autoincrement field) on an insert. Just some ideas to keep uniqueness when you have things running concurrently. - Original Message - From: "Burke, Dan" <[EMAIL PROTECTED]> To: "Dan

RE: concurrency problem

/MySQL_Sequences I'd also welcome any criticisms on it if anyone else is bored enough to check it out. Dan. -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 8:55 AM To: balaraju mandala Cc: mysql@lists.mysql.com Subject: Re: concurrency problem

Re: concurrency problem

y, I am facing concurrency problem. The scenario is, I have a table, the primary key of that table say 'uid' is a unique number, which is used by my application. So every time i fire a query, i get max(uid) i read this ResultSet from my Java application. I increament this uid to +1. Th

concurrency problem

Hi Comunity, I am facing concurrency problem. The scenario is, I have a table, the primary key of that table say 'uid' is a unique number, which is used by my application. So every time i fire a query, i get max(uid) i read this ResultSet from my Java application. I increament this

Re: simple concurrency problem - any advice ??

Tim Wood wrote: > a-- select test_id from tests where status=1 and priority < 11 order by priority b-- update tests set status=2 where test_id = What's the best way to ensure that a single client executes both a and b atomically so that no other client can show up and execute an 'a' between ano

Re: simple concurrency problem - any advice ??

Heyho! Tim Wood wrote: Hi I have a number of clients connecting to a DB in order to take jobs off a queue, mark them active, then run them. In pseudo code, each client executes the following sequence of queries: a-- select test_id from tests where status=1 and priority < 11 order by priority b

simple concurrency problem - any advice ??

Hi I have a number of clients connecting to a DB in order to take jobs off a queue, mark them active, then run them. In pseudo code, each client executes the following sequence of queries: a-- select test_id from tests where status=1 and priority < 11 order by priority b-- update tests set st