aspose 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
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: URGENT !!! how do i find query string in prepared stmt ???
 
Similar Threads
database
using prepare statements
SQLException problem?
Passing Table Names in PreparedStatement
does OracleDriver really precompile a PreparedStatement?