-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
None
-
None
SwitchYard BPEL quickstarts are failing to deploy on WildFly10 due to following error:
Error
[0m[31m12:18:55,971 ERROR [org.apache.ode.store.ProcessStoreImpl] (ProcessStoreImpl-1) TxError: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) ..... (snip) ..... Caused by: org.h2.jdbc.JdbcSQLException: Column "PROPERTIE2_.PROCESSCONFDAOIMPL_PID" not found; SQL statement: select deployment0_.NAME as NAME1_17_0_, deployment0_.DEPLOYDT as DEPLOYDT2_17_0_, deployment0_.DEPLOYER as DEPLOYER3_17_0_, deployment0_.DIR as DIR4_17_0_, processes1_.DU as DU5_19_1_, processes1_.PID as PID1_19_1_, processes1_.PID as PID1_19_2_, processes1_.DU as DU5_19_2_, processes1_.STATE as STATE2_19_2_, processes1_.TYPE as TYPE3_19_2_, processes1_.VERSION as VERSION4_19_2_, propertie2_.ProcessConfDaoImpl_PID as ProcessC1_18_3_, processcon3_.ID as STORE_PR2_18_3_, (select a15.PROP_KEY from STORE_PROCESS_PROP a15 where a15.ID=propertie2_.STORE_PROPERTY_ID) as formula1_3_, processcon3_.ID as ID1_20_4_, processcon3_.PROP_KEY as PROP_KEY2_20_4_, processcon3_.PROP_VAL as PROP_VAL3_20_4_ from STORE_DU deployment0_ left outer join STORE_PROCESS processes1_ on deployment0_.NAME=processes1_.DU left outer join STORE_PROC_TO_PROP propertie2_ on processes1_.PID=propertie2_.ProcessConfDaoImpl_PID left outer join STORE_PROCESS_PROP processcon3_ on propertie2_.STORE_PROPERTY_ID=processcon3_.ID where deployment0_.NAME=? [42122-173] at org.h2.message.DbException.getJdbcSQLException(DbException.java:331) ..... (snip) .....
It looks like the JPA column mapping is working differently. On WF8, that column used to be mapped to STORE_PROCESS_PID
WildFly8/Hibernate4.3
[0m[32m00:12:42,993 DEBUG [org.hibernate.cfg.CollectionSecondPass] (MSC service thread 1-3) Second pass for collection: org.apache.ode.dao.jpa.store.ProcessConfDaoImpl._properties
[0m[32m00:12:42,994 DEBUG [org.hibernate.cfg.annotations.CollectionBinder] (MSC service thread 1-3) Binding a OneToMany: org.apache.ode.dao.jpa.store.ProcessConfDaoImpl._properties through an association table
[0m[0m00:12:42,999 INFO [org.hibernate.dialect.Dialect] (MSC service thread 1-3) HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect
[0m[32m00:12:43,003 DEBUG [org.hibernate.cfg.CollectionSecondPass] (MSC service thread 1-3) Mapped collection key: STORE_PROCESS_PID, index: (select a12.PROP_KEY from STORE_PROCESS_PROP a12 where a12.ID=STORE_PROPERTY_ID), element: STORE_PROPERTY_ID
WildFly10/Hibernate5.0
[0m[32m12:18:51,046 DEBUG [org.hibernate.cfg.CollectionSecondPass] (MSC service thread 1-4) Second pass for collection: org.apache.ode.dao.jpa.store.ProcessConfDaoImpl._properties
[0m[32m12:18:51,047 DEBUG [org.hibernate.cfg.annotations.CollectionBinder] (MSC service thread 1-4) Binding a OneToMany: org.apache.ode.dao.jpa.store.ProcessConfDaoImpl._properties through an association table
[0m[0m12:18:51,052 INFO [org.hibernate.dialect.Dialect] (MSC service thread 1-4) HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect
[0m[32m12:18:51,056 DEBUG [org.hibernate.cfg.CollectionSecondPass] (MSC service thread 1-4) Mapped collection key: ProcessConfDaoImpl_PID, index: (select a9.PROP_KEY from STORE_PROCESS_PROP a9 where a9.ID=STORE_PROPERTY_ID), element: STORE_PROPERTY_ID
Attaching full log file for both of wf8.0(SUCCESS) and wf10(FAILURE)