title: How to Avoid Lock wait timeout exceeded exception.?
body: <pre><code>    java.sql.SQLException: Lock wait timeout exceeded; try restarting tra
  nsaction at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
          at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
  va:2077)
          at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
  2228)
          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
  208)
          at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
          at org.hibernate.loader.Loader.doQuery(Loader.java:697)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
  ader.java:259)
          at org.hibernate.loader.Loader.loadEntity(Loader.java:1885)
          ... 131 more
  </code></pre>
  
  <p>I am getting repeated lock timeout exceeded exception while I update the records.</p>
  
  <p>I am using Java Struts 2.1 Hibernate configuration.
  DB Used is MYSQL.</p>
  
  <p>Anyone know how to solve it..??</p>