2 Replies Latest reply on Feb 11, 2010 4:59 AM by dejanmr

com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUTSIDE

fil78 Jun 3, 2008 3:14 AM

Hello people,

Before this moment I used only tx datasources. But now I have to configure XA. So I have 2 datasources - here they are:
1. JbpmDS

<xa-datasource>
 <jndi-name>JbpmDS</jndi-name>
 <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
 <track-connection-by-tx/>
 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
 <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/jbpmdb?characterEncoding=utf8</xa-datasource-property>
 <xa-datasource-property name="User">root</xa-datasource-property>
 <xa-datasource-property name="Password">aaaa</xa-datasource-property>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <idle-timeout-minutes>0</idle-timeout-minutes>
 <prepared-statement-cache-size>32</prepared-statement-cache-size>
 <track-connection-by-tx/>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </xa-datasource>

2. TIntra4DS

<xa-datasource>
 <jndi-name>TIntra4DS</jndi-name>
 <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
 <track-connection-by-tx/>
 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
 <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/tintra4?characterEncoding=utf8</xa-datasource-property>
 <xa-datasource-property name="User">root</xa-datasource-property>
 <xa-datasource-property name="Password">aaaa</xa-datasource-property>
 <min-pool-size>5</min-pool-size>
 <max-pool-size>20</max-pool-size>
 <idle-timeout-minutes>0</idle-timeout-minutes>
 <prepared-statement-cache-size>32</prepared-statement-cache-size>
 <track-connection-by-tx/>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </xa-datasource>
</datasources>

and when the first time after my JBoss restarting I try to invoke my ejb get method I get the following stack:

10:29:09,943 WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror
] [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror] TransactionImple.enlistResou
rce - XAResource.start returned: XAException.XAER_OUTSIDE for < 131075, 26, 24, 1-ae96860:9bd:4844e3a9:172ae96860:9bd:4844e3a9:177>
10:29:09,943 ERROR [STDERR] com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUTSIDE: Some work
is done outside global transaction
10:29:09,958 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.mapXAExceptionFromSQ
LException(MysqlXAConnection.java:564)
10:29:09,958 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(Mysq
lXAConnection.java:547)
10:29:09,958 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.start(MysqlXAConnect
ion.java:488)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManag
edConnection.java:121)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(J
caXAResourceWrapper.java:113)
10:29:09,958 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.
enlistResource(TransactionImple.java:776)
10:29:09,958 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.
enlistResource(TransactionImple.java:499)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectio
nEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectio
nEventListener.enlist(TxConnectionManager.java:564)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager.managedConn
ectionReconnected(TxConnectionManager.java:337)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnec
tManagedConnection(BaseConnectionManager2.java:518)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocate
Connection(BaseConnectionManager2.java:399)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connecti
onManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
10:29:09,958 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrap
perDataSource.java:88)
10:29:09,974 ERROR [STDERR] at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.ge
tConnection(InjectedDataSourceConnectionProvider.java:47)
10:29:09,974 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManage
r.java:423)
10:29:09,974 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager
.java:144)
10:29:09,974 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBat
cher.java:139)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.doQuery(Loader.java:673)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L
oader.java:236)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.doList(Loader.java:2220)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.Loader.list(Loader.java:2099)
10:29:09,974 ERROR [STDERR] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
10:29:09,974 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.j
ava:338)
10:29:09,974 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.jav
a:172)
10:29:09,974 ERROR [STDERR] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
10:29:09,974 ERROR [STDERR] at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
10:29:09,974 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:80)
10:29:09,974 ERROR [STDERR] at com.tsystems.tintra4.ejb.um.session.UserManagerBean.getUser(UserMana
gerBean.java:707)
10:29:09,974 ERROR [STDERR] at com.tsystems.tintra4.ejb.um.session.UserManagerBean.getUserName(User
ManagerBean.java:116)
10:29:09,974 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10:29:09,974 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
.java:39)
10:29:09,974 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
ssorImpl.java:25)
10:29:09,974 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:112)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationC
ontextImpl.java:166)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3In
terceptorsInterceptor.java:63)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invo
ke(TransactionScopedEntityManagerInterceptor.java:54)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperations
Interceptor.java:47)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
10:29:09,974 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.jav
a:191)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationIn
terceptor.java:95)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(Statele
ssInstanceInterceptor.java:62)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(Authenti
cationInterceptor.java:77)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3Aut
henticationInterceptor.java:110)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterc
eptor.java:46)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(Asynchron
ousInterceptor.java:106)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessC
ontainer.java:304)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterc
eptor.java:81)
10:29:09,974 ERROR [STDERR] at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor
.java:72)
10:29:09,974 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation
.java:101)
10:29:09,989 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemote
Proxy.java:107)
10:29:09,989 ERROR [STDERR] at $Proxy185.getUserName(Unknown Source)
10:29:09,989 ERROR [STDERR] at com.tsystems.tintra4.actions.common.CommonAction.execute(CommonActio
n.java:33)
10:29:09,989 ERROR [STDERR] at com.tsystems.tintra4.actions.common.Start.execute(Start.java:67)
10:29:09,989 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10:29:09,989 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
.java:39)
10:29:09,989 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
ssorImpl.java:25)
10:29:09,989 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(Default
ActionInvocation.java:404)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Def
aultActionInvocation.java:267)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:229)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doInt
ercept(DefaultWorkflowInterceptor.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercep
t(MethodFilterInterceptor.java:86)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(
ValidationInterceptor.java:150)
10:29:09,989 ERROR [STDERR] at org.apache.struts2.interceptor.validation.AnnotationValidationInterc
eptor.doIntercept(AnnotationValidationInterceptor.java:48)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercep
t(MethodFilterInterceptor.java:86)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.inter
cept(ConversionErrorInterceptor.java:123)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercep
t(ParametersInterceptor.java:167)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercep
t(MethodFilterInterceptor.java:86)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inte
rcept(StaticParametersInterceptor.java:105)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(Checkbo
xInterceptor.java:83)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileU
ploadInterceptor.java:207)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept
(ModelDrivenInterceptor.java:74)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.int
ercept(ScopedModelDrivenInterceptor.java:127)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at org.apache.struts2.interceptor.ProfilingActivationInterceptor.interc
ept(ProfilingActivationInterceptor.java:107)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.interc
ept(DebuggingInterceptor.java:206)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(Ch
ainingInterceptor.java:115)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:09,989 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nIn
terceptor.java:143)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(P
repareInterceptor.java:121)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercep
t(MethodFilterInterceptor.java:86)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:10,005 ERROR [STDERR] at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(Se
rvletConfigInterceptor.java:170)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(Alias
Interceptor.java:123)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.inte
rcept(ExceptionMappingInterceptor.java:176)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:224)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Defaul
tActionInvocation.java:223)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTi
merStack.java:455)
10:29:10,005 ERROR [STDERR] at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultAction
Invocation.java:221)
10:29:10,005 ERROR [STDERR] at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.
java:50)
10:29:10,005 ERROR [STDERR] at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.ja
va:504)
10:29:10,005 ERROR [STDERR] at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispat
cher.java:419)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
licationFilterChain.java:235)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
FilterChain.java:206)
10:29:10,005 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF
ilter.java:96)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
licationFilterChain.java:235)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
FilterChain.java:206)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
Valve.java:230)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
Valve.java:175)
10:29:10,005 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi
tyAssociationValve.java:179)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentic
atorBase.java:524)
10:29:10,005 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal
ve.java:84)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
java:127)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
java:102)
10:29:10,005 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(Cached
ConnectionValve.java:157)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
lve.java:109)
10:29:10,005 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
va:262)
10:29:10,005 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
a:844)
10:29:10,005 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proc
ess(Http11Protocol.java:583)
10:29:10,005 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:4
46)
10:29:10,005 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)

I would be very grateful if someone could help me with datasources configuration.

1. Re: com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUT

vickyk Jun 10, 2008 2:07 PM (in response to fil78)

no-tx-separate-pools: The presence of this element indicates that two connection pools are required to isolate connections used with JTA transaction from those used without a JTA transaction. The pools are lazily constructed on first use. Its use case is for Oracle (and possibly other vendors) XA implementations that don't like using an XA connection with and without a JTA transaction.

http://docs.jboss.org/jbossas/jboss4guide/r5/html/ch7.chapt.html

Configure no-tx-seperate-pools in your xa-datasource configurations files .

Also check this
http://bugs.mysql.com/bug.php?id=12935

If this does not work I will investigate this in more detail .
Actions
2. Re: com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER_OUTSIDE

dejanmr Feb 11, 2010 4:59 AM (in response to fil78)

This post is old, but is ranked high on google, so I will answer it just to save some people time.

I have solved the same by simple replacing driver. I had problems with mysql connector version 5.0.5, but upgrading it to 5.0.8 made it work fine. I now use 5.1.11 connector version, and it seems to work fine too.
Actions

Go to original post