Обсуждение: Problem with JDBC driver: rs.next() is always null

Hello there!

I'm trying to connect to a postgresql via the JDBC interface as follow:

...
Statement st=db.createStatement();    ResultSet rs=st.executeQuery("select datname from pg_database");
while(rs.next()){     out.addItem(rs.getString(1));      }      rs.close();      st.close();
 
....

The JVM throws a nullPointerException.
It seems that rs.next() is null even if the result set is not empty.

I'm working with Inprise Jbuilder 4 Foundation and Redhat Linux 7.0 
(kernel 2.2.16) running on my Athlon 750.

If anyone could help me I would appreciate.

P.S.:Sorry for my english!

Quoting Sasha <ber0806@iperbole.bologna.it>:

> Hello there!
> 
> I'm trying to connect to a postgresql via the JDBC interface as follow:
> 
> ...
> Statement st=db.createStatement();
>      ResultSet rs=st.executeQuery("select datname from pg_database");
>      while(rs.next()){
>        out.addItem(rs.getString(1));
>        }
>        rs.close();
>        st.close();
> ....
> 
> The JVM throws a nullPointerException.
> It seems that rs.next() is null even if the result set is not empty.

rs should never be null from executeQuery(), and never from this one.

> 
> I'm working with Inprise Jbuilder 4 Foundation and Redhat Linux 7.0 
> (kernel 2.2.16) running on my Athlon 750.

What version of the driver? I've just tested with the latest and this doesn't 
fail.

Peter

> 
> If anyone could help me I would appreciate.
> 
> P.S.:Sorry for my english!
> 
> 



-- 
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/