Re: JDBC question: show PreparedStatement

On 31 Jan., 10:35, Joolz <r..._at_localhost.localdomain.invalid> wrote:
> Hello everyone,
>
> A small question about JDBC. When I do something like this:
>
> PreparedStatement stmt = conn.prepareStatement("select * " +
> "from fu where bar = ?");
> stmt.setString(1, "blah");
> System.out.println(stmt.toString()); // show me what will be asked
>
> I would like to see which query will be sent to the DB (i.e. "select *
> from fu where bar = 'blah'"), which would be very nice for debugging.
> toString() won't do the trick (it gives something like
> "oracle.jdbc.driver.T4CPreparedStatement_at_1e859c0"). Is there a way to
> solve this? TIA!

Hi,

1. "old" but nice article : http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html
2. Info on how to use JDBC driver logging : http://www.rgagnon.com/javadetails/java-0411.html

best regards
Markus Tazl

--
Markus Tazl