[jboss-user] [JBoss/Spring Integration] - JBOSS+SPRING+IBATIS [CachedConnectionManager] Closing a conn

[anthonyhong]

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!!


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008576#4008576

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