Re: "No results were returned by the query" exceptions - redux - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: "No results were returned by the query" exceptions - redux
Date
Msg-id 016601c1cfb8$71a86d00$807ba8c0@inspiron
Whole thread Raw
In response to Re: "No results were returned by the query" exceptions  ("Dave Cramer" <Dave@micro-automation.net>)
List pgsql-jdbc
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



pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: "No results were returned by the query" exceptions
Next
From: Tim Lewis
Date:
Subject: Re: "No results were returned by the query" exceptions