EJB/JPA error when call to persist

[lynx6]

Hi all,

I will try to explain my situation, I using:

- WildFly 8.1.0.CR2

- EclipseLink 2.5.1

- JSF to develop the app.

Example:

- I have an entity with ID = 1 stored in the database.

Steps to reproduce:

1) Create a new object using the JSF interface, add like ID the number 1.

2) Try to save (internally the application calls the EJB method to persist the entity), we get an exception because of duplicate primary key.

3) Change the ID (using the interface) with other number, like 2. We are using the same referenced object in memory.

4) Try to save again, we will get an exception like this:

13:44:07,636 INFO  [org.eclipse.persistence] (default task-87) Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

Error Code: 0

Call: SELECT COM_CODIGO, AUD_ADICIONADO, AUD_ELIMINADO, AUD_FECHA_ADICION, AUD_FECHA_MODIFICACION, AUD_MODIFICADO, COM_ARCHIVO, COM_CONTENIDO, COM_FECHA_FIN, COM_FECHA_INICIO, COM_VIGENTE, PRE_NUMERO, TDT_CODIGO FROM PED.PED_COMPONENTE WHERE (PRE_NUMERO = ?)

    bind => [1 parameter bound]

Query: ReadAllQuery(name="pedComponenteCollection" referenceClass=PedComponente sql="SELECT COM_CODIGO, AUD_ADICIONADO, AUD_ELIMINADO, AUD_FECHA_ADICION, AUD_FECHA_MODIFICACION, AUD_MODIFICADO, COM_ARCHIVO, COM_CONTENIDO, COM_FECHA_FIN, COM_FECHA_INICIO, COM_VIGENTE, PRE_NUMERO, TDT_CODIGO FROM PED.PED_COMPONENTE WHERE (PRE_NUMERO = ?)").

After a seconds the record is stored but this exception is consuming a lot of time.

I have tested the same application on GlassFish 4 with JSF(Mojarra) 2.2.6, EclipsLink 2.5.1 and this error is not fired, all works fine.

I also tried changing the default datasource setting in Wildfly.

How could I resolve this? Is a wildfly error?

Regards,

Wilber S.

This is the complete stacktrace:

13:44:22,642 WARN  [com.arjuna.ats.jta] (default task-87) ARJUNA016029: SynchronizationImple.afterCompletion - failed for org.eclipse.persistence.transaction.JTASynchronizationListener@dee7541 with exception: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

Error Code: 0

Call: SELECT COM_CODIGO, AUD_ADICIONADO, AUD_ELIMINADO, AUD_FECHA_ADICION, AUD_FECHA_MODIFICACION, AUD_MODIFICADO, COM_ARCHIVO, COM_CONTENIDO, COM_FECHA_FIN, COM_FECHA_INICIO, COM_VIGENTE, PRE_NUMERO, TDT_CODIGO FROM PED.PED_COMPONENTE WHERE (PRE_NUMERO = ?)

    bind => [1 parameter bound]

Query: ReadAllQuery(name="pedComponenteCollection" referenceClass=PedComponente sql="SELECT COM_CODIGO, AUD_ADICIONADO, AUD_ELIMINADO, AUD_FECHA_ADICION, AUD_FECHA_MODIFICACION, AUD_MODIFICADO, COM_ARCHIVO, COM_CONTENIDO, COM_FECHA_FIN, COM_FECHA_INICIO, COM_VIGENTE, PRE_NUMERO, TDT_CODIGO FROM PED.PED_COMPONENTE WHERE (PRE_NUMERO = ?)")

    at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl$1.handleException(EntityManagerSetupImpl.java:696) [eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]

    at org.eclipse.persistence.transaction.AbstractSynchronizationListener.handleException(AbstractSynchronizationListener.java:275) [eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]

    at org.eclipse.persistence.transaction.AbstractSynchronizationListener.afterCompletion(AbstractSynchronizationListener.java:242) [eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]

    at org.eclipse.persistence.transaction.JTASynchronizationListener.afterCompletion(JTASynchronizationListener.java:79) [eclipselink-2.5.1.jar:2.5.1.v20130918-f2b9fc5]

    at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:96)

    at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:532)

    at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:101)

    at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)

    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1166)

    at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)

    at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:93) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:277) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.1.0.CR2.jar:8.1.0.CR2]

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)

    at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)

    at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)

    at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

    at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)

    at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)

    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

    at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)

    at ec.edu.ups.ped.logic.sessions.PedProyectoEducacionFacade$$$view105.createRecord(Unknown Source) [classes:]

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0]

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0]

    at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0]

    at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:401) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:99) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at ec.edu.ups.ped.logic.sessions.PedProyectoEducacionFacade$Proxy$_$$_Weld$EnterpriseProxy$.createRecord(Unknown Source) [classes:]

    at ec.edu.ups.ped.view.controllers.AbstractController.persist(AbstractController.java:362) [classes:]

    at ec.edu.ups.ped.view.controllers.AbstractController.saveNew(AbstractController.java:314) [classes:]

    at ec.edu.ups.ped.view.controllers.PedProyectoEducacionController.saveNew(PedProyectoEducacionController.java:93) [classes:]

    at ec.edu.ups.ped.view.controllers.PedProyectoEducacionController$Proxy$_$$_WeldClientProxy.saveNew(Unknown Source) [classes:]

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0]

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0]

    at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0]

    at com.sun.el.parser.AstValue.invoke(AstValue.java:275) [javax.el-3.0.0.jar:]

    at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304) [javax.el-3.0.0.jar:]

    at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:40) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]

    at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105) [jsf-impl-2.2.6-jbossorg-4.jar:]

    at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:147) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:813) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at javax.faces.component.UICommand.broadcast(UICommand.java:300) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl-2.2.6-jbossorg-4.jar:]

    at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl-2.2.6-jbossorg-4.jar:]

    at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:198) [jsf-impl-2.2.6-jbossorg-4.jar:]

    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:646) [jboss-jsf-api_2.2_spec-2.2.6.jar:2.2.6]

    at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.omnifaces.filter.FacesExceptionFilter.doFilter(FacesExceptionFilter.java:56) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:77) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.omnifaces.filter.CacheControlFilter.doFilter(CacheControlFilter.java:226) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:77) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:98) [primefaces-5.0.jar:5.0]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:70) [cas-client-core-3.3.0.jar:3.3.0]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:238) [cas-client-core-3.3.0.jar:3.3.0]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.jasig.cas.client.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:107) [cas-client-core-3.3.0.jar:3.3.0]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76) [cas-client-core-3.3.0.jar:3.3.0]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:149) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:77) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.omnifaces.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:115) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:77) [omnifaces-1.8-SNAPSHOT.jar:1.8-SNAPSHOT-20140513]

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146) [undertow-servlet-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.server.Connectors.executeRootHandler(Connectors.java:168) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727) [undertow-core-1.0.10.Final.jar:1.0.10.Final]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0]

    at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0]

[jaikiran]

Moved to WildFly forum.

[smarlow]

How are you packaging the EclipseLink 2.5.1 jars?  Are they packaged with the application or in the /modules/system/layers/base/org/eclipse/persistence/main folder?

Are you sure that the same exception is not thrown on glassfish?  Or is it more that you don't see the exception being printed on the glassfish console?  I'm not sure of the best way to answer this but perhaps running glassfish in a debugger and setting a breakpoint on org.eclipse.persistence.exceptions.DatabaseException would be one way.

I don't recall seeing this warning before from the WildFly testsuite (we are using EclipseLink 2.4.2) for this simple test that creates an entity. 

[lynx6]

Hi Scott,

Eclipselink is added like a module in /org/eclipse/persistence/main, where is the jipijapa file...

I'm complety sure, because I ran the same application without change the version of jars files, in glassfish I can save the record in the database, with WildFly I can't because of the exception.

The test SFSB1 will run because is not following the steps, is a simple persist. I'm testing with a JSF app and EJB. I suppose the problem is with EJB.

Edit: The problem still exists with WF 8.1.0.Final

[smarlow]

I reformatted the original exception call stack.  Not sure how much better the formatting is but link is http://pastie.org/9250267.

Could you enable TRACE logging for org.jboss.as.jpa (while the WildFly app server is stopped, start the app server and then recreate).  It might also help if you start with an empty wildfly/standalone/log/server.log file (so that it is smaller when you attach it).  Instructions for enable TRACE logging for org.jboss.as.jpa are here.

I'm not yet sure why org.eclipse.persistence.transaction.AbstractSynchronizationListener.afterCompletion() is executing a SELECT. 

We might also want to show some of the relevant source from ec.edu.ups.ped.logic.sessions.PedProyectoEducacionFacade$$$view105.createRecord() and the EJB(s) methods that are called from there.  The trace output may give us enough information, so not yet sure if we need the source yet.

Another approach (if the above doesn't help), would be for you to recreate the failure with the simple (non-JSF) unit test that I linked to above.

Scott

[lynx6]

Log file link:

https://www.dropbox.com/s/59hteganb9mei4u/server_log_WF81Final_jpa_ejb_error.log

Exactly, I don't know why is executing the select if PedComponente is LAZY, but with GlassFish the SELECT is executed too...

createRecord is inside an abstract class:

public void createRecord(T entity) {

try {

getEntityManager().persist(entity);

getEntityManager().flush();

} catch (PersistenceException ex) {

wrapException(DataAction.INSERT, ex);

}

}

UPSDataCreateExistException is a wrapper for an constraint exception because of duplicate primary key.

[smarlow]

Can you update your standalone.xml again and try changing from:

<logger category="com.arjuna">

                <level name="WARN"/>

</logger>

To:

<logger category="com.arjuna">

                <level name="ERROR"/>

</logger>

[smarlow]

I can explain more if that helps. 

[lynx6]

Link: https://www.dropbox.com/s/hmt6q1653ms66oj/server_log_WF81Final_jpa_ejb_error2.log

The result would be the same because with WARN we can see ERROR logs.

[smarlow]

Actually, it might be better for me to see this locally.  I'm not sure yet.

[smarlow]

I'm thinking it would be best if you could reproduce the failure with the WildFly testsuite.  Have you checked out the source yet?  Instructions are here.

[lynx6]

I will try it...