passing resultset between functions
Not quite sure what's happening here. For the past few months I've been using the JDBC1 driver unaware. This caused some problems when I tried to use a JDBC2 feature, like scrolling ResultSets. After deleting some wayward files I finally got myself using the updated driver with lots of fanfare and applause. However it's brought a few new problems.
The biggest one I see now is passing ResultSets between functions. If I call next() and start reading within the function it works fine. If I pass it to another function (in another class), call next(), and try to read, I get a NullPointerException. The telling two lines of printStackTrace() are
update : fixed! thanks to
seanb for pointing me in the right direction, and jaq for the relevant technical explanation. I learned a valuable lesson about ResultSets and Statements today. /afterschoolspecial.
The biggest one I see now is passing ResultSets between functions. If I call next() and start reading within the function it works fine. If I pass it to another function (in another class), call next(), and try to read, I get a NullPointerException. The telling two lines of printStackTrace() are
java.lang.NullPointerException
at org.postgresql.jdbc2.ResultSet.next(Resuupdate : fixed! thanks to
seanb for pointing me in the right direction, and jaq for the relevant technical explanation. I learned a valuable lesson about ResultSets and Statements today. /afterschoolspecial. 