Re: EXPLAIN via jdbc - Mailing list pgsql-jdbc

From Michael Paesold
Subject Re: EXPLAIN via jdbc
Date
Msg-id 011b01c24218$fdf7a9b0$0100a8c0@beeblebrox
Whole thread Raw
In response to EXPLAIN via jdbc  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-jdbc
Dave Cramer wrote:

> I just tried a 7.2.1 backend with the same code, and the notices come
> back in the warning???
>
> dave
> On Mon, 2002-08-12 at 10:27, Michael Paesold wrote:
> > Dave Cramer wrote:
> >
> > > The notices should be in the warnings, you may need to use the
> > > development version of the driver for this to be true.
> > >
> > > Dave
> > > On Thu, 2002-08-08 at 09:15, Jochem van Dieten wrote:
> > > > Michael Paesold wrote:
> > [snip]
> > > > > I there any way to get the result from an EXPLAIN query?
> > > >
> > > > If I read the development documentation correctly, the next version
of
> > > > PostgreSQL will return EXPLAIN output as a recordset instead of a
> > NOTICE.
> > > >
> > > > HTH,
> > > > Jochem
> >
> > I tried to use devpgjdbc2.jar (7.3dev (built 2002-07-16)). I still don't
get
> > the explain notices in getWarnings(). Regrettably I don't have the time
to
> > look into the code right now.
> >
> > Regards,
> > Michael

I am sorry, that was my mistake. Thanks for your help Dave, reading
your code I recognized that I had called Statement.getWarnings() instead
of Connection.getWarnings().
Changing that helped.

Thanks again!

Michael


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: EXPLAIN via jdbc
Next
From: "Dennis R. Gesker"
Date:
Subject: Swing and JDBC