Hello,

i use FBXADataSource in JBoss Application Server.
Firebird SuperServer v2.5.6 on linux.

The isolation level is set to READ_COMMITTED.

Now i execute the following statement in two separate transactions:

UPDATE ITEM_TYPES SET ITEM_TYPE = 1 WHERE ITEM_TYPE = 1;

My expectations are, that the second transaction waits until first 
transaction commits.
After that it procees with the update statement.

In isql this works as expected.

In JBoss using FBXADataSource the following exception is thrown:

update conflicts with concurrent updateconcurrent transaction number is 
36123
     at 
de.procar.ecaros2.server.ItemModuleBean.test(ItemModuleBean.java:12834) 
[ecaros2-server-DEV.jar:DEV]
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
[rt.jar:1.8.0_111]
     at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111]
     at 
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:278) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:330) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:242) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:79) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:116) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:86) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler.invokeMethod(MethodInvocationMessageHandler.java:332) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler.access$100(MethodInvocationMessageHandler.java:69) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.remote.protocol.versionone.MethodInvocationMessageHandler$1.run(MethodInvocationMessageHandler.java:202) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
[rt.jar:1.8.0_111]
     at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
[rt.jar:1.8.0_111]
     at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
[rt.jar:1.8.0_111]
     at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
[rt.jar:1.8.0_111]
     at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
     at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 
335544336. deadlockupdate conflicts with concurrent updateconcurrent 
transaction number is 36123
     at 
org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:262) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
[rt.jar:1.8.0_111]
     at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111]
     at 
org.firebirdsql.ds.StatementHandler.invoke(StatementHandler.java:112) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at com.sun.proxy.$Proxy173.executeUpdate(Unknown Source)
     at 
org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
     at 
de.procar.sql.bundle.basic.BundleContainer.executeLockStatement(BundleContainer.java:388) 
[ecaros2-sqlbundle-DEV.jar:DEV]
     at 
de.procar.sql.bundle.basic.DefaultSQLBundle.lockContainer(DefaultSQLBundle.java:865) 
[ecaros2-sqlbundle-DEV.jar:DEV]
     at 
de.procar.ecaros2.server.MainClientDataSourceBean.lockContainer(MainClientDataSourceBean.java:800) 
[ecaros2-server-DEV.jar:DEV]
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
[rt.jar:1.8.0_111]
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
[rt.jar:1.8.0_111]
     at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111]
     at 
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:257) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:332) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:242) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.security.AuthorizationInterceptor.processInvocation(AuthorizationInterceptor.java:116) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:86) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) 
[jboss-as-ejb3-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) 
[jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]
     at 
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73) 
[jboss-as-ee-7.5.3.Final-redhat-2.jar:7.5.3.Final-redhat-2]
     at 
de.procar.ecaros2.server.MainClientDataSourceLocal$$$view154.lockContainer(Unknown 
Source) [ecaros2-server-DEV.jar:DEV]
     at 
de.procar.ecaros2.server.ItemModuleBean.test(ItemModuleBean.java:12819) 
[ecaros2-server-DEV.jar:DEV]    ... 58 more
Caused by: org.firebirdsql.gds.GDSException: deadlockupdate conflicts 
with concurrent updateconcurrent transaction number is 36123
     at 
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2120) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at 
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2070) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at 
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1162) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at 
org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:251) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at 
org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1371) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 date=201608071009)]
     at 
org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:258) 
[jaybird-2.2.11.jar:2.2.11-JDK_1.8 (build: tag=v2.2.11 
date=201608071009)]    ... 121 more

Debugging the FBXADataSource shows that the following transaction 
parameters are used:
9 = isc_tpb_write
6 = isc_tpb_wait
15 = isc_tpb_read_committed
17 = isc_tpb_rec_version

Any ideas what went wrong?
This is reproduceable.

I will attach my jboss datasource configuration.

Thanks in advance.

Regards.

-- 
Mit freundlichen Grüßen,

Sascha Horn
Dipl. Ing. Informationstechnik (BA)

procar informatik AG
Software Entwicklung

Stammsitz in Darmstadt:

procar informatik AG
Heinrich-Hertz-Str. 1
64295 Darmstadt

Geschäftsstelle Berlin:

Justus-von-Liebig-Str.7
12489 Berlin-Adlershof

Geschäftsstelle Leipzig:

Schongauer Straße 29-31
04328 Leipzig


Telefon (Zentrale): +49 6151/85048-0
Fax (Zentrale):     +49 6151/85048-29

mailto:info@...
http://www.procar.de
http://www.facebook.com/procar.de

Amtsgericht Darmstadt HRB 8268
USt.-IdNr. DE195354166
Vorstand: Dipl.-Ing. Volker Holthaus, Karl-Heinz Schlapp
Vorsitzender des Aufsichtsrats: Dipl.-Ing. Wilfried Holthaus
============================================================

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.



[Non-text portions of this message have been removed]



------------------------------------
Posted by: Sascha Horn <s.horn@...>
------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Firebird-Java/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/Firebird-Java/join
    (Yahoo! ID required)

<*> To change settings via email:
    Firebird-Java-digest@yahoogroups.com 
    Firebird-Java-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    Firebird-Java-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/