My environment: Netbeans v6.5.1, glassfish v2.1, Toplink, MySQL. I use a session bean to update a lot of entity beans. It encountered "lock wait timeout" when updating the SEQUENCE table, even when I am the only user of the system (i.e. it always run in single thread only):
Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
Error Code: 1205
Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
bind => [50, SEQ_GEN]
I don't know if this table is a EJB feature or a toplink feature? How can I overcome it?
[Message sent by forum member 'senderj' (senderj)]
http://forums.java.net/jive/thread.jspa?messageID=354064