1 Reply Latest reply on Feb 5, 2007 4:39 PM by Ales Justin

    JBOSS+SPRING+IBATIS [CachedConnectionManager] Closing a conn

    Anthony Hong Newbie

      I use jboss4.0.2+spring1.2.8+ibatis2.x+Oracle10g
      I configured an xa datasource in jboss, everthing configured fine and startup without errors.
      But when request a function with db operation. Functions work fine but jboss has shown following errors:
      20:46:01,687 INFO [CachedConnectionManager] Closing a connection for you. Plea
      se close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@ 4b2f7f

      java.lang.Exception: STACKTRACE
      at org.jboss.resource.connectionmanager.CachedConnect ionManager.register
      Connection(CachedConnectionManager.java:321)
      at org.jboss.resource.connectionmanager.BaseConnectio nManager2.allocateC
      onnection(BaseConnectionManager2.java:467)
      at org.jboss.resource.connectionmanager.BaseConnectio nManager2$Connectio
      nManagerProxy.allocateConnection(BaseConnectionMan ager2.java:874)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource. getConnection(Wrapp
      erDataSource.java:103)
      at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(D
      ataSourceUtils.java:112)
      at org.springframework.jdbc.datasource.TransactionAwa reDataSourceProxy.g
      etConnection(TransactionAwareDataSourceProxy.java: 107)
      at org.springframework.jdbc.datasource.DataSourceUtil s.doGetConnection(D
      ataSourceUtils.java:112)
      at org.springframework.jdbc.datasource.DataSourceUtil s.getConnection(Dat
      aSourceUtils.java:77)
      at org.springframework.orm.ibatis.SqlMapClientTemplat e.execute(SqlMapCli
      entTemplate.java:165)
      at org.springframework.orm.ibatis.SqlMapClientTemplat e.insert(SqlMapClie
      ntTemplate.java:303)
      at com.iBatisDaoBase.insert(iBatisDaoBase.java:22)
      at com.MyDaoImpl.createData(MyDaoImpl.java:10)
      at com.MyServiceImpl.createData(MyServiceImpl.java:18 )
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.springframework.aop.support.AopUtils.invokeJoi npointUsingReflecti
      on(AopUtils.java:287)
      at org.springframework.aop.framework.ReflectiveMethod Invocation.invokeJo
      inpoint(ReflectiveMethodInvocation.java:181)
      at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
      ReflectiveMethodInvocation.java:148)
      at org.springframework.transaction.interceptor.Transa ctionInterceptor.in
      voke(TransactionInterceptor.java:96)
      at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(
      ReflectiveMethodInvocation.java:170)
      at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynami
      cAopProxy.java:176)
      at $Proxy406.createData(Unknown Source)

      I saw there are some discussion on hibernate + spring run on jboss to contol the connection close on each transaction. how to configure with ibatis?
      Thanks a lot!!