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

[xhemjl]

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 at 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#4024914

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4024914