How can I get the SQL of a PreparedStatement?

by

Using prepared statements, there is no “SQL query” :

  • You have a statement, containing placeholders
    • it is sent to the DB server
    • and prepared there
    • which means the SQL statement is “analysed”, parsed, some data-structure representing it is prepared in memory
  • And, then, you have bound variables
    • which are sent to the server
    • and the prepared statement is executed — working on those data

But there is no re-construction of an actual real SQL query — neither on the Java side, nor on the database side.

So, there is no way to get the prepared statement’s SQL — as there is no such SQL.

For debugging purpose, the solutions are either to :

  • Ouput the code of the statement, with the placeholders and the list of data
  • Or to “build” some SQL query “by hand”.

More Related Contents:

  1. Using setDate in PreparedStatement
  2. How does a PreparedStatement avoid or prevent SQL injection?
  3. Variable column names using prepared statements
  4. right syntax to use near ‘?’
  5. How to use prepared statement for select query in Java?
  6. Hours and seconds are lost when storing a date in the database [closed]
  7. How to get the insert ID in JDBC?
  8. java.util.Date vs java.sql.Date
  9. PreparedStatement with list of parameters in a IN clause [duplicate]
  10. Running a .sql script using MySQL with JDBC
  11. java.sql.SQLException: Exhausted Resultset
  12. How to enable logging for SQL statements when using JDBC
  13. Getting output from dbms_output.get_lines using JDBC
  14. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  15. JDBC ResultSet get columns with table alias
  16. Java – Can’t use ResultSet after connection close
  17. Timezones in SQL DATE vs java.sql.Date
  18. SQL prepared statement how to select via multiple possible menu selections?
  19. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  20. Class.forName(JDBC_DRIVER) no longer needed?
  21. mysql prepared statement error: MySQLSyntaxErrorException
  22. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  23. PreparedStatement setNull(..)
  24. Having a Column name as Input Parameter of a PreparedStatement
  25. Java – Storing SQL statements in an external file [closed]
  26. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  27. MS SQL Exception: Incorrect syntax near ‘@P0’
  28. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  29. PreparedStatement and setTimestamp in oracle jdbc
  30. Database independence through JDBC in java

Leave a Comment