Actually it depends on the query
"select * from y" where y has no rows returns a result set with no rows
";" which is an empty query throws an exception
Dave
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Dave Cramer
> Sent: Tuesday, March 19, 2002 9:24 PM
> To: 'Tim Lewis'; pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] "No results were returned by the query" exceptions
>
>
> Yes,
>
> I can confirm that it does indeed throw an exception. I will
> have a look at this shortly.
>
> Thanks,
>
> Dave
>
> > -----Original Message-----
> > From: pgsql-jdbc-owner@postgresql.org
> > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tim Lewis
> > Sent: Tuesday, March 19, 2002 7:01 PM
> > To: pgsql-jdbc@postgresql.org
> > Subject: [JDBC] "No results were returned by the query" exceptions
> >
> >
> > Hi people,
> >
> > Am I correct in assuming that the new driver now throws an
> > exception when a "No results were returned by the query"
> > occurs for a prepared sql statement. I have recently
> > upgraded the driver from 7.1 to 7.2 and my application now
> > throws this exception when a query returns no rows in the
> result set.
> >
> > Could someone clarify this with me.
> >
> > Thanks,
> >
> > Tim Lewis
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> http://archives.postgresql.org
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org