Subject Firebird-Hibernate problem - result set is already closed
Author dhay@lexmark.com
Hi Roman,

Really under the gun here....got everything checked in for my part of the
project, only to find that it breaks a different part of our Hibernate use.
If we change back to using firebirdsql-full.jar rather than the new
jaybird-full.jar everything works fine, however.

This is the exception we are getting. Any ideas?

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
could n
ot initialize a collection:
[com.lexmark.workflow.framework.domain.printergroup.
PrinterGroup.deployments#688128]; uncategorized SQLException for SQL
[select dep
loyment0_.PGROUP_ID as PGROUP2_1_, deployment0_.ID as ID1_,
deployment0_.SOLN as
SOLN1_, deployment0_.ID as ID0_ from PGSOLUTIONDEPLOYMENT deployment0_
where de
ployment0_.PGROUP_ID=?]; SQL state [HY000]; error code [0]; The result set
is cl
osed; nested exception is org.firebirdsql.jdbc.FBSQLException: The result
set is
closed
org.firebirdsql.jdbc.FBSQLException: The result set is closed
at
org.firebirdsql.jdbc.FBResultSet.checkCursorMove(FBResultSet.java:217
)
at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:249)
at
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.
java:152)
at org.hibernate.loader.Loader.doQuery(Loader.java:408)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:218)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1434)
at
org.hibernate.loader.collection.OneToManyLoader.initialize(OneToManyL
oader.java:111)
at
org.hibernate.persister.collection.AbstractCollectionPersister.initia
lize(AbstractCollectionPersister.java:488)
at
org.hibernate.event.def.DefaultInitializeCollectionEventListener.onIn
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at
org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:
1430)
at
org.hibernate.collection.AbstractPersistentCollection.forceInitializa
tion(AbstractPersistentCollection.java:280)
at
org.hibernate.engine.PersistenceContext.initializeNonLazyCollections(
PersistenceContext.java:796)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:223)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at
org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate
(HibernateTemplate.java:766)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat
eTemplate.java:315)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:757)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTe
mplate.java:753)

cheers,

David
x54680