Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:2.1

Mapping documents:

<session-factory>

<property name="hibernate.connection.datasource">jdbc/ds_test</property>
<property name="hibernate.dialect">net.sf.hibernate.dialect.OracleDialect</property>

<property name="hibernate.transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereExtendedJTATransactionLookup</property>
<property name="jta.UserTransaction">java:comp/UserTransaction</property>
<!--
<property name="show_sql">false</property>
<property name="hibernate.jdbc.batch_size">20</property>
<property name="hibernate.jdbc.use_scrollable_resultset">false</property>
-->

<mapping resource="*.hbm.xml"/>
.
.
.
</session-factory>
Code between sessionFactory.openSession() and session.close():

Session session = openSession();// Reget a new if session or connection is null.

Query query = session.createQuery(fromClause);
List list = query.list();

Full stack trace of any exception that occurs:

[18.10.05 09:53:02:872 CEST] 3f8b56a0 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 0, SQLState: null
[18.10.05 09:53:02:919 CEST] 3f8b56a0 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter DSRA9110E: Statement is Closed.
[18.10.05 09:53:02:935 CEST] 3f8b56a0 BatcherImpl W net.sf.hibernate.impl.BatcherImpl exception clearing maxRows/queryTimeout
[18.10.05 09:53:02:935 CEST] 3f8b56a0 BatcherImpl W net.sf.hibernate.impl.BatcherImpl TRAS0014I: Die folgende Ausnahmebedingung wurde protokolliert: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is Closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:608)
at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:149)
at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:105)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:889)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java(Inlined Compiled Code))
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java(Compiled Code))
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531)
.
.
.
[18.10.05 09:53:02:966 CEST] 3f8b56a0 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 0, SQLState: null
[18.10.05 09:53:02:966 CEST] 3f8b56a0 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter DSRA9110E: Statement is closed.

Name and version of the database you are using:Oracle 8.1.7

Server you are using:WSAD 5.1 test environment