Anyone has an idea what can be the cause of this exception ? THe sessionn is still open. THe generated SQL is valid and runs. I use Postgresql 8.0 and the latest driver. The error started to occur when start adding a type to a column for safe type enumeration.

<property name="prefix" column="prefix_id" not-null="true">
<type name="framework.core.utils.hibernate.GenericEnumUserType">
<param name="lookupClass">core.domain.enums.PrefixType</param>
<param name="identifierMethod">getId</param>
<param name="lookupMethod">lookup</param>
</type>
</property>


The errors seems to be triggered when the above column is initialized via lookupMethod. THat calls a service that connects to the db and gets the needed info.



Hibernate version:3.1.3 and 3.2


2006-06-06 23:45:46,593 [http-8080-Processor25]: WARN org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:276) - exception clearing maxRows/queryTimeout
java.sql.SQLException: org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement is closed.
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.getMaxRows(DelegatingStatement.java:234)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:272)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:209)
at org.hibernate.loader.Loader.doQuery(Loader.java:714)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1785)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2821)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:370)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:351)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:122)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:81)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:871)
at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:829)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:66)
at org.hibernate.Hibernate.initialize(Hibernate.java:291)


....

If I do the lookupMethod on a different session I won't have this issue!