java.sql.sqlexception: lock wait

[Silpa Sunkavalli]

Hi,

I have a question regarding the java.sql.sqlexception: lock wait
timeout exceeded; try restarting transaction
with respect to following code

  stmtBuff(mailPieceInsert);

try{
                        for (int i = 0; i < mailCount; i++) {
                               if (count > 0) {
                                       stmtBuff.append(",");
                               }
                               stmtBuff.append("(" + sortDecionId + ",");
                               stmtBuff.append(mailRunId + ",");
                               stmtBuff.append("" + 1 + ",");
                               stmtBuff.append("" + binNumber + ",");
                               stmtBuff.append("'" + zip + "',");
                               stmtBuff.append("" + postageWeight + ",");
                               stmtBuff.append("" + autoMachId + ")");
                               count++;
                            if (count == 5000) {
                              stmt.execute(stmtBuff.toString());
                                count = 0;
                                stmtBuff = new StringBuffer(mailPeiceInsert);
                             }
                          }
                       if (count > 0) {
                             stmt.execute(stmtBuff.toString());
                           }
 } catch (SQLException e) {//Repeat inserting in to mailpiece
     if(e.getMessage().equalsIgnoreCase("Lock wait timeout exceeded"))
{
       stmt.execute(stmtBuff.toString());
       }else
               throw new SQLException(e.toString());
 }

  

I would like to catch the Lock wait timeout exceeded SQLException and
try executing the insert statement one more time,before throwing the
SQLException (if it failed for the 2nd time).I was wondering if it is
good practice to catch
the Lock wait timeout exceeded SQLException.Any suggestions or other approaches to achieve the result is highly
appreciated.
Thanks for the help,
Silpa.