Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of gcaddu-derby-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: derby-user@db.apache.org
From: Mark Hiles <markahiles@fastmail.fm>
Subject: Re: Re-using an existing db and archiving data
Date: Tue, 18 Mar 2008 23:03:40 +0000 (UTC)
Lines: 19
Message-ID: <loom.20080318T225223-32@post.gmane.org>
References: <47DED655.8090305@fastmail.fm> <47DEF5F3.9080501@sun.com>
 <loom.20080317T232119-732@post.gmane.org> <16112414.post@talk.nabble.com>
 <loom.20080318T105858-384@post.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
User-Agent: Loom/3.14 (http://gmane.org/)
Sender: news <news@ger.gmane.org>

Ok, need a little guidance again..

I perform a query which returns some results that I'd like to store in a
2-dimensional array. But when I try running a loop to go through the results, I
get a null pointer exception happening. I know that the query is returning 2
rows of results, so why can't I go through them?

Here's an example of the kind of thing I'm trying to do...

rs = stmt.executeQuery("...");
rs.last();
arr = new String[rs.getRow()][2];
rs.first();
int i;
for(i = 0; rs.next(); ++i) {            // null pointer exception
    arr[i][0] = rs.getString("...");
    arr[i][1] = rs.getInt("...");
}