Subject | JDBC driver and JSP |
---|---|
Author | Chris Meelhuysen |
Post date | 2004-08-26T20:30:17Z |
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@...
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@...