Re: get SQL statement from PreparedStatement

JY wrote:
"Raymond DeCampo" <nospam@xxxxxxxxxxxx> wrote in message news:JKnLf.28689$j53.21557@xxxxxxxxxxxxxxxxxxxxxxx
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.

So java does not have a function which can tell me the SQL statement which will be executed? In other languages like PowerBuilder, you can get the SQL statement you are going to submit.


That is because the SQL statement is embedded in the DataWindow object.

--

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
.

Relevant Pages

  • Re: Business objects, subset of collection
    ... SQL only works when the statements are ... all items (invoices) are subscribing for events. ... all items and all items has to execute the criteria evaluation, ... The features of a OO database is basically the same as of a network ...
    (comp.object)
  • Re: Multiple Database Security - How to handle
    ... There is no 'execute as' in SQL Server but you can simplify security ... Assuming the DM database contains tables that are accessed only by ...
    (microsoft.public.sqlserver.security)
  • Re: PHP/Oracle - Pulling data into array
    ... MySQL has the flaw that you have to stuff values into SQL statements, ... DATA with SQL. ... Depending on what interface and database you're using. ... time it comes across a new statement, it works out the best way to execute it. ...
    (comp.lang.php)
  • Re: PHP/Oracle - Pulling data into array
    ... MySQL has the flaw that you have to stuff values into SQL statements, ... DATA with SQL. ... Depending on what interface and database you're using. ... time it comes across a new statement, it works out the best way to execute it. ...
    (comp.lang.php)
  • Re: New to C# - DB question
    ... Firstly, you are interested in the System.Data namespace, also known as ... In there you will find a few sub namespaces for specific database ... is your sql statement. ... The former allows you to just execute some SQL, ...
    (microsoft.public.dotnet.languages.csharp)