Skip site navigation (1) Skip section navigation (2)

Re: first() causes NullPointerException

From: "Nico" <nicohmail-postgresql(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: first() causes NullPointerException
Date: 2004-12-23 11:06:36
Message-ID: cqe8ru$1v5f$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
> 



In response to

pgsql-jdbc by date

Next:From: Rakesh ShembekarDate: 2004-12-24 03:37:00
Subject: interval related problem
Previous:From: Kris JurkaDate: 2004-12-23 10:30:44
Subject: Re: first() causes NullPointerException

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group