error : Lock wait timeout exceeded; try restarting transaction
hello friends,
i am trying to create a java application using mysql but if i try to
create multiple connections, i keep on getting this exception given
below. I have read about the TransactionDeadLockDetectionTimeOut
option but i am neither able to find config.ini nor i am running the
cluster for which this option applies.
what could be the problem here ?
thanks
ravinder thakur
java.sql.SQLException: Lock wait timeout exceeded; try restarting
transaction
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:18 37)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1961)
|