This question belongs in the firebird-java list. Subscribe here:

http://www.yahoogroups.com/groups/firebird-java

^heLen
-------------------------------------------------

At 01:30 PM 26/08/2004 -0700, you wrote:

>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@...
>
>
>
>
>Yahoo! Groups Links
>
>
>
>