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