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 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 which i can define something in web.xml or struts-config.xml so that there is no error coming. If it reduces the performance then it is ok, since i can't change the code of my application as i have already finished the development of the application. Thanks, Shailender Jain --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] *********************************************** This e-mail and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this e-mail from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods. Please note that e-mail communications may be monitored. The registered office of Littlewoods Limited and its subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. Registered number of Littlewoods Limited is 262152. ************************************************ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
