Skip site navigation (1) Skip section navigation (2)

Re: get the query created by PreparedStatement

From: Eric Frazier <ef(at)kwinternet(dot)com>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: Garry Thuna <garry(dot)thuna-pgsql-jdbc(at)tacticalExecutive(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: get the query created by PreparedStatement
Date: 2001-03-20 21:11:08
Message-ID: 2.2.32.20010320211108.0076e2b8@kwinternet.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

This does work, both with the postgress and mysql drivers. 
But I do need to make SURE it will work no matter the driver, so it sounds
like Garry's code would be the best bet for that. 

Thoughts?

Thanks,

Eric 

>How about the toString() method ;-)
>
>Ok, may not be standard JDBC, but:
>
>PreparedStatement ps = ....;
>
>// later
>org.postgresql.jdbc2.PreparedStatement ps2 =
>      (org.postgresql.jdbc2.PreparedStatement) ps;
>System.out.println(ps2.toString());
>
>Peter
>
>-- 
>Peter Mount peter(at)retep(dot)org(dot)uk
>PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
>RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>


Frazier Consulting
http://www.kwinternet.com/eric
(250) 655 - 9513




pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-03-20 22:14:07
Subject: Re: Re: Patch application
Previous:From: Barry LindDate: 2001-03-20 17:57:01
Subject: Re: [INTERFACES] Trouble with JDBC2 ResultSet.getDate()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group