Re: [Fwd: Lock Problem with Database]

2004-07-08 Thread Shailender Jain
;F=&S=&P=18647 > > Chris McCormack > > -Original Message- > From: Shailender Jain [mailto:[EMAIL PROTECTED] > Sent: 08 July 2004 12:11 > To: [EMAIL PROTECTED] > Subject: [Fwd: Lock Problem with Database] > > The database i am using is Informix 9.2 > >

RE: [Fwd: Lock Problem with Database]

2004-07-08 Thread McCormack, Chris
In that case : http://archives.java.sun.com/cgi-bin/wa?A2=ind9811&L=jserv-interest&F=&S=&P=18647 Chris McCormack -Original Message- From: Shailender Jain [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 12:11 To: [EMAIL PROTECTED] Subject: [Fwd: Lock Problem with Database]

RE: Lock Problem with Database

2004-07-08 Thread McCormack, Chris
Look at using 'select for update' which will allow the row to be selectable by other users. Chris McCormack -Original Message- From: Shailender Jain [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 12:10 To: [EMAIL PROTECTED] Subject: Lock Problem with Database Hi, If i try t

[Fwd: Lock Problem with Database]

2004-07-08 Thread Shailender Jain
The database i am using is Informix 9.2 Shailender Jain wrote: > Hi, > > If i try to update a table(emp) in my database from a temp > table(temp_emp) and at the > same time some other transaction try to read or update the same > table(emp) then i > get the SQLException. > > I am assuming that thi

Lock Problem with Database

2004-07-08 Thread Shailender Jain
Hi, If i try to update a table(emp) in my database from a temp table(temp_emp) and at the same time some other transaction try to read or update the same table(emp) then i get the SQLException. I am assuming that this problem may be related to some locks created on the table. Is there any way by