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

Tony,

What does JSP have to do with it? Please explain?

Thanks,
Dave

> -----Original Message-----
> From: tony [mailto:tony@animaproductions.com]
> Sent: Friday, March 22, 2002 2:05 AM
> To: Dave@micro-automation.net
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] "No results were returned by the query" exception
>
>
> On Fri, 2002-03-22 at 04:19, Dave Cramer wrote:
> > Actually, this only occurs when there is an error in the query. If
> > there are no results from the query
> >
> > Ie select * from foo; returns nothing then you will get an empty
> > result set
> >
> > If on the other hand there is an error in the query like a
> transaction
> > is in error, then the exception will be thrown
>
> For JSP you must have a "show if result set is not empty"
> clause or you will get a nullpointer exception error.
>
> Cheers
>
> Tony Grant
>
> --
> RedHat Linux on Sony Vaio C1XD/S
> http://www.animaproductions.com/linux2.html
> Macromedia
> UltraDev with PostgreSQL http://www.animaproductions.com/ultra.html
>
>