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

[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 this

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 to update

RE: [Fwd: Lock Problem with Database]

2004-07-08 Thread McCormack, Chris
In that case : http://archives.java.sun.com/cgi-bin/wa?A2=ind9811L=jserv-interestF=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

Re: [Fwd: Lock Problem with Database]

2004-07-08 Thread Shailender Jain
-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 Shailender Jain wrote: Hi, If i try to update a table(emp) in my database from