Re: first() causes NullPointerException

On Thu, 23 Dec 2004, Nico wrote:

> I have a servlet that extracts data from a postgresql database and makes a
> nice menu of it. The connection works fine, I can execute my sql-statement
> without any problems, but when I try the first() method of ResultSet it
> fails: it throws a NullPointerException at line 216.
>
> resultsetL1=getQuery("SELECT * FROM \"qryMenuL1\" ORDER BY "+
> "\"MenuL1Order\"");
> resultsetL1C=getQuery("SELECT COUNT(\"MenuL1ID\") FROM
> \"qryMenuL1\"");

According to the JDBC spec you are only allowed to have one ResultSet open
per Statement. When you create the second ResultSet the first is
automatically closed. This causes the NPE or in the CVS version of the
driver an error message indicating that the result is already closed.

Kris Jurka