[SOLVED]java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

에러 메세지
java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

 

Cause

The problem usually happens when a query is taking too long (maybe because the server is too busy).

 

자세한 것은 http://www.percona.com/blog/2012/03/27/innodbs-gap-locks/ 사이트를 참조

 

#유닉스계열의 경우 /etc/my.conf 등록후 재시작
# 윈도우의 경우 my.ini
[mysqld]
innodb_lock_wait_timeout                              = 500
transaction-isolation                                 = READ-COMMITTED