Re: Re-using an existing db and archiving data

[Jørgen Løland]

Mark Hiles wrote:
Sorry I forgot to mention that!
rs = stmt.executeQuery("...");

while(rs.next()) {                            // LINE 308
    arrLstS.add(rs.getString("..."));
    arrLstS.add(getRoomName(rs.getInt("...")));
    arrLstB.add(arrLstS);            
}



I really doubt that rs.next() throws a NPE - my guess is that rs was 
never set. You can test this by adding

System.out.println("Value of rs: "+rs);

on the line above the while loop. It will probably print
Value of rs: null

Is it possible to attach the java program? That would make it easier to 
help.

--
Jørgen Løland