Hello,
I tried to configure a non-transactional connection pool
for id table on mysql.
While I checked the docs, I think they are sometimes
confusing: I'm not always sure on which properties to specify.
I've seen examples in camel case, others with hyphens; some
with sequence-specific connection pools and some with a simple
boolean which in my understanding would
enable my table-generated ids to use the non-jta connection.
So, here are my current settings:
But I still get the
dreaded "Lock wait timeout
exceeded".
So, here are my questions:
1) Is this setup right to get a
non-transactional connection for my id's (JPA,
@TableGenerator, mysql)?
2) Did I make any mistake in the
property names? Should I use other properties?
Here is the error
(probably when there is another long-running transactions):
Exception
[EclipseLink-4002] (Eclipse Persistence Services -
2.6.2.qualifier): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
Error Code: 1205
Call: UPDATE seq SET VALUE = VALUE + ? WHERE NAME = ?
bind => [50, ID]
Query: DataModifyQuery(name="ID" sql="UPDATE seq SET VALUE = VALUE + ? WHERE NAME = ?")
Thanks,
Yannick Majoros