aspose file tools*
The moose likes JDBC and the fly likes java.sql.sqlexception: lock wait Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.sqlexception: lock wait" Watch "java.sql.sqlexception: lock wait" New topic
Author

java.sql.sqlexception: lock wait

Silpa Sunkavalli
Greenhorn

Joined: Jun 04, 2008
Posts: 3
Hi,

I have a question regarding the java.sql.sqlexception: lock wait
timeout exceeded; try restarting transaction
with respect to following code


I would like to catch the Lock wait timeout exceeded SQLException and
try executing the insert statement one more time,before throwing the
SQLException (if it failed for the 2nd time).I was wondering if it is
good practice to catch
the Lock wait timeout exceeded SQLException.Any suggestions or other approaches to achieve the result is highly
appreciated.
Thanks for the help,
Silpa.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.sqlexception: lock wait