search

jerustes / AW-threepointer

Galaxy NBA Web Application
0 stars 0 forks source link

Delete query, could not execute update #12

Closed josemprb closed 6 years ago

josemprb commented 6 years ago

String q1 = "delete plantilladeportista where lineup = :lineup and player = :player"; Query query1 = ses.createQuery(q1); query1.setParameter("player",id); query1.setParameter("lineup",lineup.getId()); // Could not execute update. int result = query1.executeUpdate();

It is at SellPlayer.java line 60 aprox.

josemprb commented 6 years ago

causa raíz

com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

Now the bug is at line 80, in which we have the commit statement, and the reason is the lock wait timeout.

josemprb commented 6 years ago

solved