Re: get SQL statement from PreparedStatement

On Fri, 24 Feb 2006 04:08:27 +0800, JY wrote
(in article <0DoLf.21162$%14.528438@xxxxxxxxxxxxxxxxxxxxx>):


"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.



basically you build an sql string and submit it to the database.
then you add in your paramaters etc and submit it to the database..


the database parses and compiles the statement internally. ( or it may even
have a pre-parsed, pre-compiled previous version squirreled away(oracle))


if you want to see the sql "at the database end" after the statement has been
assembled, then you CAN use java, but you must query the database tools to do
it.


the only other way i can think would be to re-write your sql routines, so
that you log the statement & params BEFORE they are sent to the database.



it depends on the database you are using.

.

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: 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)
  • 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)