[OT] Synchronising database access

2003-11-21 Thread Antony Paul
Hi, I want to synchronise all database access. There are lots of situations where first first a select query is performed to get the results and then insert/update data. I dont want to implement row level locking or optimistic locking. I just want to synchronise the whole process. Only after a

RE: [OT] Synchronising database access

2003-11-21 Thread Peter Guyatt
Paul [mailto:[EMAIL PROTECTED] Sent: 21 November 2003 11:51 To: Tomcat Users List Subject: [OT] Synchronising database access Hi, I want to synchronise all database access. There are lots of situations where first first a select query is performed to get the results and then insert/update data. I

Re: [OT] Synchronising database access

2003-11-21 Thread Antony Paul
thanks for the reply synchrosing servlet code dont work ? Antony Paul - Original Message - From: Peter Guyatt [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Friday, November 21, 2003 5:28 PM Subject: RE: [OT] Synchronising database access Hi There, Use a singleton

Re: [OT] Synchronising database access

2003-11-21 Thread Rodrigo Ruiz
PROTECTED] Sent: Friday, November 21, 2003 5:28 PM Subject: RE: [OT] Synchronising database access Hi There, Use a singleton class to manage the database transactions. Then implement a owner mechanism. E.g. class DbTxMgr { String owner = null; public synchronized boolean lockMgr (String threadId

RE: [OT] Synchronising database access

2003-11-21 Thread Ralph Einfeldt
: [OT] Synchronising database access I want to synchronise all database access. T How to do it. Do I have to synchronise on Connection or on this or implement SingleThreadModel. I also want to know how much extra time a synchronised block requires than an unsynchronised block