How to print used SQL query when using PreparedStatement (JDBC)

Question

I used PreparedStatement in my Java program. I need to debug the SQL query because it's not working fine.

Is there is away to print the used SQL statement with the values inserted

for example in PreparedStatement:

select * from table where a=?

and than I set the ?

could I print the used SQL, for example:

select * from table where a=1

stackoverflow.com/q/2683214/839527 previous question will help you. — JProgrammer
– JProgrammer, Commented Feb 25, 2012 at 16:11

duffymo · Accepted Answer · 2012-02-25 16:10:22Z

5

It can't be done with java.sql.PreparedStatement interface itself; it depends on the implementation by your database vendor.

But you're in luck; the MySQL driver allows you to do it using its toString implementation:

You need to be aware that using this vendor-specific feature binds your code to MySQL. You can't change databases without changing your code.

answered Feb 25, 2012 at 16:10

duffymo

310k46 gold badges376 silver badges571 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks ... it's OK i'm just going to use it for debug purpose only.