[ https://issues.apache.org/jira/browse/IBATIS-535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12628339#action_12628339 ]
Kai Grabfelder commented on IBATIS-535: --------------------------------------- ok, the configuration looks ok to me. Still I think that its rather a JBoss bug, not beeing able to tell if a connection has already been closed. Do you get the error log regularly or only on some occations? > iBatis not closing JDBC statements > ---------------------------------- > > Key: IBATIS-535 > URL: https://issues.apache.org/jira/browse/IBATIS-535 > Project: iBatis for Java > Issue Type: Bug > Components: SQL Maps > Affects Versions: 2.3.2, 2.3.3 > Environment: Windows XP, Windows 2003, JBoss 4.0.5GA, Java 6.x, > Spring 2.5.5 > Reporter: Doug Rothauser > Attachments: applicationContext-jta.xml, applicationContext-sr-dao.xml > > > JDBC statements aren't being closed until the Connection is closed. > 18:11:57,182 WARN [WrappedConnection] Closing a statement you left open, > please do your own housekeeping > java.lang.Throwable: STACKTRACE > at > org.jboss.resource.adapter.jdbc.WrappedConnection.registerStatement(WrappedConnection.java:576) > at > org.jboss.resource.adapter.jdbc.WrappedStatement.<init>(WrappedStatement.java:62) > at > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.<init>(WrappedPreparedStatement.java:56) > at > org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:225) > at $Proxy66.prepareStatement(Unknown Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53) > at $Proxy67.prepareStatement(Unknown Source) > at > com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497) > at > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175) > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106) > at > org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273) > at > org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) > at > org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271) > at > com.fcci.surveyrequest.dao.SurveyRequestSourceDAOImpl.getPhid(SurveyRequestSourceDAOImpl.java:80) > at > com.fcci.surveyrequest.dao.SurveyRequestSourceDAOImpl.getSurveyRequest(SurveyRequestSourceDAOImpl.java:151) > at com.fcci.ra.RaServlet.acountDetails(RaServlet.java:1268) > at com.fcci.ra.RaServlet.doAction(RaServlet.java:322) > at com.fcci.expresswrite.EwServlet.handleRequest(EwServlet.java:640) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.