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