aspose file tools*
The moose likes JDBC and the fly likes executeBatch() not executing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "executeBatch() not executing" Watch "executeBatch() not executing" New topic
Author

executeBatch() not executing

rastas biggs
Ranch Hand

Joined: Sep 24, 2004
Posts: 41
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.


Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
any exceptions??
Bill Fences
Greenhorn

Joined: Oct 23, 2004
Posts: 9
None at all
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

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 ?


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Bill Fences
Greenhorn

Joined: Oct 23, 2004
Posts: 9
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
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
are you commiting the transaction bill?
how do you know it is sticking somewhere near executeBatch()?
Bill Fences
Greenhorn

Joined: Oct 23, 2004
Posts: 9
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
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
write this statement,
System.out.println("Execute batch");
before executeBatch(), then see.
Bill Fences
Greenhorn

Joined: Oct 23, 2004
Posts: 9
I did it does not reach it.
rastas biggs
Ranch Hand

Joined: Sep 24, 2004
Posts: 41
Bill,

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

Thanks guys for your help with this.

RB
 
 
subject: executeBatch() not executing