I'm getting a lot of these in my code:
org.jooq.exception.DataAccessException: SQL [null]; Deadlock found when
trying to get lock; try restarting transaction
at org.jooq.impl.Util.translate(Util.java:496)
at org.jooq.impl.DefaultExecuteContext.sqlException(
DefaultExecuteContext.java:360)
at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:96)
I'm using Jooq to talk to a MySql database, and the relevant statement is
an .execute() call on a batch insert of up-to 500 rows.
What am I doing wrong here?
Ian.
--
Ian Clarke
Blog: http://blog.locut.us/