Details
-
Bug
-
Resolution: Obsolete
-
Major
-
jboss-fuse-6.3
-
None
-
%
-
Description
It is not possible to deploy SwitchYard BPEL application to EAP in domain mode if you use Postres DB. I will attach server log.
[Server:server-one] 11:22:58,982 ERROR [org.apache.ode.store.ProcessStoreImpl] (ProcessStoreImpl-1) Error persisting deployment record for {http://www.jboss.org/bpel/examples}SayHello-0; process will not be available after restart!: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement [Server:server-one] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [Server:server-one] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [Server:server-one] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [Server:server-one] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881) [Server:server-one] at org.apache.ode.dao.jpa.store.ConfStoreDAOConnectionImpl.setVersion(ConfStoreDAOConnectionImpl.java:95) [riftsaw-dao-jpa-3.2.0.Final-redhat-4.jar:3.2.0.Final-redhat-4] [Server:server-one] at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:301) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5] [Server:server-one] at org.apache.ode.store.ProcessStoreImpl$2.call(ProcessStoreImpl.java:271) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5] [Server:server-one] at org.apache.ode.store.ProcessStoreImpl$Callable.call(ProcessStoreImpl.java:886) [riftsaw-bpel-store-3.2.0.Final-redhat-4.jar:3.2.2.Final-redhat-5] [Server:server-one] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_74] [Server:server-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_74] [Server:server-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_74] [Server:server-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_74] [Server:server-one] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement [Server:server-one] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) [Server:server-one] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [Server:server-one] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [Server:server-one] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [Server:server-one] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) [Server:server-one] at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) [Server:server-one] at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) [Server:server-one] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2987) [Server:server-one] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499) [Server:server-one] at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) [Server:server-one] at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) [Server:server-one] at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:229) [Server:server-one] at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:209) [Server:server-one] at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:193) [Server:server-one] at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) [Server:server-one] at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) [Server:server-one] at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) [Server:server-one] at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) [Server:server-one] at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) [Server:server-one] at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) [Server:server-one] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) [Server:server-one] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) [Server:server-one] at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:772) [Server:server-one] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:746) [Server:server-one] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:750) [Server:server-one] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875) [Server:server-one] ... 8 more [Server:server-one] Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint [Server:server-one] Detail: Failing row contains (null, 0). [Server:server-one] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270) [Server:server-one] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998) [Server:server-one] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) [Server:server-one] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) [Server:server-one] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) [Server:server-one] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366) [Server:server-one] at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) [Server:server-one] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [Server:server-one] ... 29 more
I also tried to use MySQL database. Quickstart works but server log contains a lot of errors.
https://gist.github.com/basovnik/ade659e3fe9b9c43e6ae
Attachments
Issue Links
- is related to
-
ENTESB-4160 BPEL - Domain mode - Deployment throws MySQLIntegrityConstraintViolationException
- Closed