工作中遇到了一个问题,google了一篇,
原文地址:http://blog.csdn.net/xumiao19871129/archive/2009/10/14/4669898.aspx
转载如下:
1
[CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@c75442
java.lang.Throwable: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:423)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at $Proxy407.createStatement(Unknown Source)
at com.eway.businessservice.util.DataUtil.queryListAsHashMap(DataUtil.java:14)
at com.eway.persistence.dao.DepartmentDAO.findAllChildren(DepartmentDAO.java:425)
at com.eway.businessservice.department.ejb.DepartmentManager.findAllChildren(DepartmentManager.java:358)
2
Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk5.WrappedConnectionJDK5@17240d9
jboss自动关闭数据连接,有时会出再如上异常,连接未关闭,解决办法
1,手动关闭每一个连接
2.首先把 D:/jboss/server/default/deploy/jboss-web.deployer/server.xml 里的
<Valve className="org.jboss.web.tomcat.service.jca.CachedConnectionValve"
cachedConnectionManagerObjectName="jboss.jca:service=CachedConnectionManager"
transactionManagerObjectName="jboss:service=TransactionManager" />
注释去掉
然后
http://forums.sun.com/thread.jspa?threadID=737400
If you are using Hibernate, it is recommended to add a "hibernate.connection.release_mode" property on value "auto" (the default) in your hibernate.cfg.xml file.
This did not work for me. So I found the following workaround:
To remove the message you need to set the "Debug" property to "false" in the CachedConnectionManager mbean configuration, in the jbossjca-service.xml file, for example:
<mbean code="org.jboss.resource.connectionmanager.CachedConnectionManager" name="jboss.jca:service=CachedConnectionManager" >
<depends optional-attribute-name="TransactionManagerServiceName" > jboss:service=TransactionManager</depends>
<attribute name="Debug" > false</attribute>
</mbean>
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/xumiao19871129/archive/2009/10/14/4669898.aspx