Re: get SQL statement from PreparedStatement

JY wrote:
"Raymond DeCampo" <nospam@xxxxxxxxxxxx> wrote in message news:S0nLf.24789$Zl1.665@xxxxxxxxxxxxxxxxxxxxxxx

JY wrote:

How can I get the SQL statement which will be submitted by the PreparedStatement to the database to execute?


That isn't how prepared statements (necessarily) work. The idea behind the prepared statement is that the driver or database will precompile the SQL into some driver or database specific format that allows for value bindings. Typically the execution plan for the SQL is determined by this (the execution plan is the steps the database will take to retrieve the results; e.g., use index XYZ, full table scan of ABC, etc.).

It is possible for a JDBC driver to trivially implement PreparedStatements by generating SQL and transmitting that to the database. However, in such a driver PreparedStatements would not be any more efficient than regular Statements.

If what you really wanted to achieve was to known what parameters are being passed to the PreparedStatement there are JDBC spy tools that can help.

HTH,
Ray

--
This signature intentionally left blank.


I need to print out all the SQL messages as being submitted to database, in my log file. I want to write a method which will take PreparedStatement as an argument and print out its SQL to server.log file. Anywhere in my application after I have set arguments to a PreparedStatement, I will call this method before executing the SQL in PreparedStatement. Thats why I ask this question. Any way I can achieve this task?


Perhaps the best approach will be to examine the logging options provided by your JDBC driver. But I re-iterate, the term "SQL message" does not necessarily apply to a PreparedStatement. Also, you do not "execute the SQL in [a] PreparedStatement." You execute the PreparedStatement.

HTH,
Ray
--
This signature intentionally left blank.
.

Relevant Pages

  • Re: get SQL statement from PreparedStatement
    ... PreparedStatement to the database to execute? ... SQL into some driver or database specific format that allows for value ...
    (comp.lang.java.programmer)
  • Re: get SQL statement from PreparedStatement
    ... PreparedStatement to the database to execute? ... SQL into some driver or database specific format that allows for value ...
    (comp.lang.java.programmer)
  • Re: Unexpected Exception when inserting data in SQL 2000
    ... If a duplicate key insert is done the very first time I ... call .executeon the preparedstatement, ... I traced the call it is making to the database: ... which is supposed to prepare and execute the statement. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: year to date conversion
    ... the date in ISO-format, i.e. exactly in the format the OP requested. ... It is rare to need to be database independent. ... Sure, but again, there are moments, where a PreparedStatement ... The string is created by java.sql.Date, ...
    (comp.lang.java.programmer)
  • Re: get SQL statement from PreparedStatement
    ... That isn't how prepared statements work. ... The idea behind the prepared statement is that the driver or database will precompile the SQL into some driver or database specific format that allows for value bindings. ... If what you really wanted to achieve was to known what parameters are being passed to the PreparedStatement there are JDBC spy tools that can help. ...
    (comp.lang.java.programmer)