Roman,

It seems if I set "defaultHoldable", the error "The resultSet is
closed" gone. However, another problem happens with the exception

"
GDS Exception. 335544329. invalid BLOB ID
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544329. invalid
BLOB ID
at
org.firebirdsql.jdbc.field.FBBlobField.getBytesInternal(FBBlobField.java:165)
"

What is the short term solution? I will need to have my production
application running. Thank you for your help.

Jeff

--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <rrokytskyy@...>
wrote:

>
> Hi,
>
> > I have a production database running Delphi and Java Server
> > Application for a few years. Now, I moved to database to Firebird 2.
> > One of the problems is:
> >
> > 1. -------------------------------
> > java.sql.SQLException: The resultSet is closed
> > at org.firebirdsql.jdbc.FBResultSet.close(FBResultSet.java:212)
> >
> > This tried to use the lastest JDBC driver. It does not seem solving
> > the problems.
>
> It has nothing to do with Firebird versions, only with JDBC driver
> versions. Reason is that your code does not follow the JDBC 3.0
> specification in auto-commit mode. This question was asked here many
> times, use search to find the relevant messages. Also check the section
> "Default holdable result sets" on page 4 of release notes.
>
> Roman
>