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 URGENT !!! how do i  find query string in prepared stmt ??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "URGENT !!! how do i  find query string in prepared stmt ???" Watch "URGENT !!! how do i  find query string in prepared stmt ???" New topic
Author

URGENT !!! how do i find query string in prepared stmt ???

Tejas Tambe
Ranch Hand

Joined: Oct 08, 2001
Posts: 47
Hi guyz...
Can any 1 tell me how to find out the query string generated by prepared statement, before execution.
with thanx in adavance...
Tejas
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by Tejas Tambe:
Hi guyz...
Can any 1 tell me how to find out the query string generated by prepared statement, before execution.
with thanx in adavance...
Tejas

No fast way to do this. You've got to just use System.out.println on the query String used to prepare the PreparedStatement, and then printout all the values you set. Manually you can replace the question marks with the actual values ( adding single quotes where necessary ).
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: URGENT !!! how do i find query string in prepared stmt ???