executeBatch() not executing

[rastas biggs]

I need a second pair of eye because this normally works fine, I just geting PK from an ArrayList as an argument for an update in the database but its getting stuck on ps.executeBatch();

it's not even getting to the finally clause, if some one can see cause
i'm certianly missing it.

  
String sql = "UPDATE ACTIVATE SET STATUS = 'ERROR' WHERE mobile_phone_number = ?"; 
ps = conn.prepareStatement(sql); 
      try {      
      for(int i = 0; i < errorMSN.size(); i++) {
      String MSN = ((String) errorMSN.get(i)).trim();;
      ps.setString (1, MSN);
      System.out.println(MSN);
      ps.addBatch();
      System.out.println("add batch");
      }
      ps.executeBatch();
      System.out.println("Execute batch");
  } catch(SQLException e) {
  e.printStackTrace();
  } finally {
  ps.close();
  System.out.println("ps -  close");
  conn.close();
  System.out.println("conn - close");
}

[Adeel Ansari]

any exceptions??

[Bill Fences]

None at all

[Shailesh Chandra]

then what are criteria on basis which you say this is not working !!!

and you are not throwing your exception only catching them ???

is mobile_phone_number is a number field ?

[Bill Fences]

mobile_phone_number is a VARCHAR2, I use exactly the same code to perform exactly the same function with an ArrayList, same field, in another object that works perfectly fine.

[Adeel Ansari]

are you commiting the transaction bill?
how do you know it is sticking somewhere near executeBatch()?

[Bill Fences]

By the print statements I watching it in the console and it stops on the last iteration and the line

System.out.println("Execute batch");

is never reached it just hangs in the loop, if a can determine the last record I can force it to break.

[Adeel Ansari]

write this statement,
System.out.println("Execute batch");
before executeBatch(), then see.

[Bill Fences]

I did it does not reach it.

[rastas biggs]

Bill,

I have fixed it, I rebooted WL and redeployed the app and it works fine.

Thanks guys for your help with this.

RB