My environment is JBoss 3.2.7+Spring 1.2.6+Hibernate 3.0.5. In a stateless bean I used Spring to retrieve data. Since Spring is configured as openSessionViewFilter so session isn't close after each query execution. Then JBoss detects this unclosed connection and shuts it down(error as below). My question is how I don't allow JBoss to close this session connection in EJB.
2006-03-28 23:19:10,135 INFO [org.jboss.resource.connectionmanager.CachedConnectionManager] (http-0.0.0.0-8080-Processor23) Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@3daebc
java.lang.Exception: STACKTRACE
at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:321)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:526)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:888)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
