Subject JDBC driver and JSP
Author Chris Meelhuysen
Does anyone know why my result set gets closed?

I am getting a

org.firebirdsql.jdbc.FBSQLException: The resultSet is closed
at org.firebirdsql.jdbc.FBResultSet.checkCursorMove(FBResultSet.java:182)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
...

message on the last line below

int LastEvent = 0;
File imageFile;
if (!(dbrecordset.isLast())){
//Prints out the Events on the given day
while (!(dbrecordset.isLast())
&& (dbrecordset.getDate("ondate").getDate() == iCurrentDay)) {
if (LastEvent != dbrecordset.getInt("eventnumber")) { ...

i can get the Date value ondate but then it errs at the getInt telling
me resultset is closed

Why?


--
Thanks,

Chris Meelhuysen
VP Information Technology
Event Software
480-517-9990
chris@...