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

NullPointerException on call to next()

From: "Martin Dillard" <martin(at)edusoftinc(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: NullPointerException on call to next()
Date: 2001-11-15 20:44:25
Message-ID: 003c01c16e16$506affd0$0301a8c0@market (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hash: SHA1

A NullPointerException is being thrown from a call to next() in this
(simplified) code snippet:

            String sql = "SELECT * FROM my_table";
            stmt = pConn.createStatement();
            result = stmt.executeQuery(sql);
            while (
                myObject = populateFromResult(result, true, pConn);

The exception is thrown in the second iteration of the while loop
from The method populateFromResult only calls getXXX()
methods on the ResultSet and creates another Statement on the
Connection and uses it to populate other fields in the object. The
Connection and the ResultSet are not closed. The new Statement on the
Connection IS CLOSED (could this be the problem???).

After decompiling the jdbc drivers, the offending line of code inside
ResultSet is:

if (++current_row >= rows.size())

I am using the JDBC drivers compiled from the 7.1.3 release of
Postgres running on Tomcat in Linux. The same code works fine on the
drivers from the 7.1RC2 release running on Resin in Windows.

The only previous posts I have found describing this problem
concluded that the problem was caused by closing the Statement or
executing a new query on it before the subsequent call to next(). I
have examined my code closely and am not using the ResultSet or
Statement for anything other than what you see in the code above.

Has anyone run across this problem? Does anyone have any suggestions?
Martin Dillard

Version: PGPfreeware 6.5.8 for non-commercial use <>



pgsql-jdbc by date

Next:From: Martin DillardDate: 2001-11-16 00:50:46
Subject: Re: NullPointerException on call to next()
Previous:From: Tomisław KityńskiDate: 2001-11-15 15:01:54
Subject: executeUpdate() --- what does it actually return?

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