Re: Display SQL from Java Prepared Statement - Mailing list pgsql-jdbc

From vanayya
Subject Re: Display SQL from Java Prepared Statement
Date
Msg-id 1313982005992-4721914.post@n5.nabble.com
Whole thread Raw
In response to Re: Display SQL from Java Prepared Statement  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Display SQL from Java Prepared Statement
List pgsql-jdbc
But its not working for me ..

I have written like this :

/
 PreparedStatement pStatement = null;
 ....

 pStatement = connection.prepareStatement(" update tblMember set address =
?");
 pStatement.setObject(i++, "Jl. Setya Budi");
 System.out.println("query : " + pStatement.toString());

/

And the result :

/query : org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement@1c1de1c/

I need log query from pStatement, Does anyone can help me ?

regard,

mimi

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Display-SQL-from-Java-Prepared-Statement-tp2175579p4721914.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

pgsql-jdbc by date:

Previous
From: JavaNoobie
Date:
Subject: Re: how to Escape single quotes with PreparedStatment
Next
From: Oliver Jowett
Date:
Subject: Re: Display SQL from Java Prepared Statement