[9/15/09 12:59:34:640 GMT+05:30] 00000065 AbstractBatch W org.hibernate.jdbc.AbstractBatcher closeQueryStatement exception clearing maxRows/queryTimeout
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:109)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1676)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:1110)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:276)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:212)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1801)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:66)

Do you know what part of your code is triggering that? Can you show it to us?

I had Code which Loads the details of customer which loads of the same.


public final Customrs getSingle(final String sUidCustomrs, String office)
{
return super.getSingle(sUidCustomrs, office);
}// EOM


protected T getSingle(Object...arrKeyParts) { return (T) m_sCache.getSingle(this, arrKeyParts) ; }

T getSingle(final CacheRegionKeyInterface<T> cacheRegionKey, final Object...arrKeyParts) ;

Regards
Manish

Do you solve the issue? If yes, would you please share what was the solution? Thanks.