Hi All,

I am using Jboss jboss-4.0.5.GA, spring, and firebird as database. I am facing intermittent problem, suddently error can't get connection.

I have been trying to reprocude but still can't, everytime i got this error i have check the connection pool whether is full or not. I found that my connection pool working find and my database server still up.

I wish can get the solution or any clue from you guys... thanks in advance.

org.springframework.transaction.interceptor.RuleBasedTransactionAttribute]Timer-3 Applying rules to determine whether transaction should rollback on org.firebirdsql.jdbc.FBSQLException: Problem getting connection: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=UZCXC01D/4946, BranchQual=, localId=4946])
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.interceptor.RuleBasedTransactionAttribute]Timer-3 Winning rollback rule is: RollbackRule with pattern [java.lang.Throwable]
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.interceptor.TransactionInterceptor]Timer-3 Invoking rollback for transaction on com.justcommodity.cxc.utils.SlJcDataModule.getCxcData due to throwable [org.firebirdsql.jdbc.FBSQLException: Problem getting connection: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=UZCXC01D/4946, BranchQual=, localId=4946])]
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.jta.JtaTransactionManager]Timer-3 Triggering beforeCompletion synchronization
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.jta.JtaTransactionManager]Timer-3 Initiating transaction rollback
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.jta.JtaTransactionManager]Timer-3 Triggering afterCompletion synchronization
2010-02-10 15:57:52,546 DEBUG[org.springframework.transaction.support.TransactionSynchronizationManager]Timer-3 Clearing transaction synchronization
2010-02-10 15:57:52,546 DEBUG[org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor]Timer-3 Trying to find handler for exception of type [org.firebirdsql.jdbc.FBSQLException]
2010-02-10 15:57:52,546 INFO [STDOUT]Timer-3 Before sleep:30000
2010-02-10 15:57:52,546 INFO [STDOUT]Timer-3 Myself is:com.jc.cxc.tasks.TaskWrapper@180fc02
2010-02-10 15:58:22,546 INFO [STDOUT]Timer-3 After sleep:30s
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3 org.firebirdsql.jdbc.FBSQLException: Problem getting connection: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=UZCXC01D/4946, BranchQual=, localId=4946])
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:88)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getConnection(TransactionAwareDataSourceProxy.java:107)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.justcommodity.cxc.utils.AbstractDataModule.getConnection(AbstractDataModule.java:51)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.justcommodity.cxc.utils.AbstractDataModule.getData(AbstractDataModule.java:81)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.justcommodity.cxc.utils.SlJcDataModuleBean.getCxcData(SlJcDataModuleBean.java:104)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at java.lang.reflect.Method.invoke(Method.java:585)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at x.vejb.VEjbHomeIntro.safe_invoke(VEjbHomeIntro.java:173)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at x.vejb.VEjbObjectIntro.invoke(VEjbObjectIntro.java:93)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at x.vejb.JbossSubjectCapture.invoke(JbossSubjectCapture.java:61)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:118)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at $Proxy128.getCxcData(Unknown Source)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.jc.cxc.ws.sap.CxcWsResenderTimer.reSendWsToSAP(CxcWsResenderTimer.java:37)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.jc.cxc.ws.sap.CxcWsResenderTimer.run(CxcWsResenderTimer.java:315)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at com.jc.cxc.tasks.TaskWrapper.run(TaskWrapper.java:84)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at java.util.TimerThread.mainLoop(Timer.java:512)
2010-02-10 15:58:22,546 ERROR[STDERR]Timer-3     at java.util.TimerThread.run(Timer.java:462)
2010-02-10 15:58:22,546 INFO [STDOUT]Timer-3 **************************Problem getting connection: org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=UZCXC01D/4946, BranchQual=, localId=4946])
2010-02-10 15:58:22,546 DEBUG[org.springframework.beans.factory.support.DefaultListableBeanFactory]Timer-3 Returning cached instance of singleton bean 'SlJcDataModuleHome'