File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes PreparedStatement Batch Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement Batch Queries" Watch "PreparedStatement Batch Queries" New topic

PreparedStatement Batch Queries

Jigar M Gohil

Joined: Dec 14, 2011
Posts: 25
I am preparing a batch using PreparedStatement. I wanted to get the queries for preparing a Rollback Script.

is there any way to get the batch Queries with filled parameters?

Jigar Gohil.
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3606

Look up "DebuggableStatement" on this FAQ page of ours. Is this what you wanted?
It is sorta covered in the JavaRanch Style Guide.
subject: PreparedStatement Batch Queries
Similar Threads
PreparedStatement or Statement
Retrieve record from DB?
statement Vs prepared statement for ordinary select queries
maximum open cursors exceeded
java.lang.OutOfMemoryError: Java heap space while Executing the Query