Thanks. I will try it right away.
Nico.
"Kris Jurka" <books@ejurka.com> schreef in bericht
news:Pine.BSO.4.56.0412230526470.22886@leary.csoft.net...
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>