Hi,

I need some help on Jaybird.

I have a production database from Firebird 1 to 2 and new Jaybird
driver. I always get
"java.sql.SQLException: The resultSet is closed
at org.firebirdsql.jdbc.FBResultSet.close(FBResultSet.java:212)"

I read the document, saying there is property

defaultResultSetHoldable as connection property for JDBC URL or for
java.sql.DriverManager class and no or empty value should be assigned
to it;it has an alias defaultHoldable to simplify the typing;


url="jdbc:firebirdsql:dev:MyDatabaseAlias?defaultHoldable"

It still has the exception. What am I doing wrong. As I did not write
the original codes, it is very difficult for me to make major changes
in the productions server.

Your help would be greatly appreciated.

Jeff