File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

PreparedStatement Batch Queries

Jigar M Gohil
Greenhorn

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?

Regards,
Jigar Gohil.
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

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