Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1DA0Lx56374 for ; Tue, 13 Feb 2001 05:00:21 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f1DA03F56288; Tue, 13 Feb 2001 05:00:03 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: Sasha Subject: Re: Problem with JDBC driver: rs.next() is always null Message-ID: <982058403.3a8905a38f4bb@webmail.retep.org.uk> Date: Tue, 13 Feb 2001 05:00:03 -0500 (EST) From: Peter T Mount Cc: pgsql-interfaces@postgresql.org References: <3A853D98.2070308@iperbole.bologna.it> In-Reply-To: <3A853D98.2070308@iperbole.bologna.it> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200102/107 X-Sequence-Number: 1064 Quoting Sasha : > 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/