[jboss-user] [Beginners Corner] - CachedConnectionManager is closing connection for me - why?

Hi all, I have sucessfully deployed data source for DB2. I have also created DB2ConnectionFactory class: public final class DB2ConnectionFactory { | private static Connection connection; | static { | try { | connection = CachingServiceLocator.getInstance().getDataSource("java:/DataWeaverDS").getConnection(); | } catch (Exception e) { | e.printStackTrace(); | } | } | public static Connection getConnection() { | return connection; | } | } well - it works i can connect to DB2 from my servlet but after the response is sent to browser i recieve this message: 17:57:22,265 INFO [CachedConnectionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@50a11a | java.lang.Throwable: STACKTRACE | at org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290) | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417) | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) next WWW request fails because of already closed connection: 18:14:41,312 ERROR [STDERR] java.sql.SQLException: Connection handle has been closed and is unusable | 18:14:41,312 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537) | 18:14:41,312 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524) | 1 | my DS looks like this: <?xml version="1.0" encoding="UTF-8"?> | <datasources> | <local-tx-datasource> | <jndi-name>DataWeaverDS</jndi-name> | <connection-url>jdbc:db2://localhost:50000/Test1:retrieveMessagesFromServerOnGetMessage=true;</connection-url> | <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> | <user-name>****</user-name> | <password>****</password> | <min-pool-size>5</min-pool-size> | <max-pool-size>20</max-pool-size> | <idle-timeout-minutes>5</idle-timeout-minutes> | </local-tx-datasource> | </datasources> is my data source definition missing something or is it my Java code? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4024914#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...