Thanks. I will try it right away.
Nico.
"Kris Jurka" <books(at)ejurka(dot)com> schreef in bericht
news:Pine(dot)BSO(dot)4(dot)56(dot)0412230526470(dot)22886(at)leary(dot)csoft(dot)net(dot)(dot)(dot)
>
>
> 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
>