Subject Re: Problems: Move Database from firebird 1 to Firebird 2
Author jwcanada

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

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


--- In, Roman Rokytskyy <rrokytskyy@...>
> 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(
> >
> > 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