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