Lock wait timeout exceeded; try restarting transaction
Hi,
I am using MySQL 5.0 , EJB 3.0 and seam framework for my web application.
I am doing the transaction using EJB transactions.
This transaction is only reads one MySQL table.
When I started 2 transaction in parallel, application is throwing an exception as
11:08:55,296 ERROR [JDBCExceptionReporter] Lock wait timeout exceeded; try restarting transaction
11:08:55,327 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
...
Please help me on that.
Thanks in advance.
Subject
Views
Written By
Posted
Lock wait timeout exceeded; try restarting transaction
7884
March 18, 2010 06:20AM
3266
March 31, 2010 11:55PM
2517
May 08, 2010 02:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.