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: local policy)
Date: Wed, 19 Mar 2008 00:24:25 +0100
From: =?ISO-8859-1?Q?=D8ystein_Gr=F8vlen?= <Oystein.Grovlen@Sun.COM>
Subject: Re: Re-using an existing db and archiving data
In-reply-to: <loom.20080318T225223-32@post.gmane.org>
Sender: Oystein.Grovlen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <47E04F29.7080800@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 8BIT
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>
 <loom.20080318T225223-32@post.gmane.org>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)

It would definitely help if you could provided a call stack for the 
NPE.  If I understand correctly, it occurs when rs. next is called.

I do not think your code does what you intend it to do.  I think that 
rs.first() followed by rs.next() will position on the second row of the 
result set. Hence, the values of the first row will not be accessed.  
Also, the code will not be very efficient for large result sets since 
rs.last() will in most cases materialize the entire query in order to 
get to the last row.

--
�ystein

Mark Hiles wrote:
> 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("...");
> }
>
>
>