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