struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "McCormack, Chris" <>
Subject RE: Lock Problem with Database
Date Thu, 08 Jul 2004 11:21:51 GMT
Look at using 'select for update' which will allow the row to be selectable by other users.

Chris McCormack

-----Original Message-----
From: Shailender Jain []
Sent: 08 July 2004 12:10
Subject: Lock Problem with Database


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.

Shailender Jain

To unsubscribe, e-mail:
For additional commands, e-mail:

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:
For additional commands, e-mail:

View raw message