Uploaded image for project: 'RiftSaw'
  1. RiftSaw
  2. RIFTSAW-558

Cannot deploy on WildFly10 due to Column PROPERTIE2_.PROCESSCONFDAOIMPL_PID not found error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ODE
    • Labels:
      None

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              igarashitm tomohisa igarashi
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: