Subject Re: [Firebird-Java] Problems: Move Database from firebird 1 to Firebird 2
Author Roman Rokytskyy
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