This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Websphere and the fly likes com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed." Watch "com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed." New topic
Author

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.

J Suk
Greenhorn

Joined: Apr 01, 2010
Posts: 19

Hi,
I am getting the com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed error in Websphere application server 7.0.0.11.
I tried making the minimum connection to 0 and giving the preTestconnectionpool but did not help. can any one help to get a resolution?

[6/19/12 20:12:36:685 CDT] 00000022 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 0, SQLState: null
[6/19/12 20:12:36:685 CDT] 00000022 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions DSRA9110E: Statement is closed.
[6/19/12 20:12:36:873 CDT] 00000022 SystemOut O Hibernate: select this_.SYSTEM_ID as SYSTEM1_4_0_, this_.SYSTEM_NAME_L as SYSTEM2_4_0_, this_.SYSTEM_DESC as SYSTEM3_4_0_ from GRPTLN.TR_SYSTEM this_ where lcase(this_.SYSTEM_NAME_L)=?
[6/19/12 20:12:36:889 CDT] 00000022 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:110)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1747)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:1181)
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:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

Thanks.

SCJP, SCDJWS, SCEA
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30136
    
150

Does this happen on startup of the application or during execution? Every time or after a while. If you try a second time after the error occurs, does it go away?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
J Suk
Greenhorn

Joined: Apr 01, 2010
Posts: 19

Thanks for your reply,
It happens every time I call the webservice operation in my application. Its mainly when a hibernate query is fired in that operation. This application still working fine in WAS6.1 and when we try migrating it in WAS7.0 I am getting this error.
If you can give some hint it will be great.

Thanks a lot.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30136
    
150

Hmm. Maybe something else is using all the connections? If it worked in WAS 6.1, it might be worth asking IBM.
 
 
subject: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
 
Similar Threads
Error while indexing a post: java.sql.SQLException: The statement is closed.
Querys are nor exceuting after 14 hours in localhost
Websphere, Hibernate, SQL Server throws Stale Connection exception
StaleConnectionException when using WAS data source
getting "Problem with checked-in Statement, discarding " in servlet scheduler