Re: get the query created by PreparedStatement

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