1 Reply Latest reply on Jun 20, 2017 12:02 PM by andey

    Hbm2ddl.auto not creating tables for JBPM7.0.0.Final

    yellapusony

      Hi All,

      I am trying to configure mysql datasource for jbpm7 latest release. I followed the instructions given in jbpm 7 documentation, Ideally the very first time when we run the jbpm it should generate the table automatically by using hbm2ddl.auto hiberanate property. But it is not creating for JBPM 7. In log  i am finding below lines :

      2017-06-20 15:53:13,314 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 65) HHH000204: Processing PersistenceUnitInfo [

      name: org.jbpm.domain

        ...]

      2017-06-20 15:53:13,408 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 65) HHH000412: Hibernate Core {5.1.4.Final}

      2017-06-20 15:53:13,408 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 65) HHH000206: hibernate.properties not found

      2017-06-20 15:53:13,408 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 65) HHH000021: Bytecode provider name : javassist

      2017-06-20 15:53:13,470 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 65) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

      2017-06-20 15:53:14,048 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 65) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

      2017-06-20 15:53:14,064 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 65) HHH000431: Unable to determine H2 database version, certain features may not work

      2017-06-20 15:53:16,892 INFO  [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (ServerService Thread Pool -- 65) HHH000397: Using ASTQueryTranslatorFactory

      2017-06-20 15:53:17,048 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,080 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,142 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,173 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,220 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,423 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,486 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,533 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,548 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,611 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,705 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:17,798 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:18,064 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:18,080 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:18,236 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

      2017-06-20 15:53:18,345 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

       

      Thanks in advance .

        • 1. Re: Hbm2ddl.auto not creating tables for JBPM7.0.0.Final
          andey

          ~~~

          2017-06-20 15:53:18,345 WARN  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 65) HHH90000016: Found use of deprecated 'collection property' syntax in HQL/JPQL query [null.elements]; use collection function syntax instead [elements(null)].

          ~~~

           

          It's not the MEMBER OF which got deprecated, it's the collection properties that were dropped in favor of functions.

          MEMBER OF is JPA 2.0 compliant, so it shouldn't be depreciated.

           

          This is the issue:

           

          https://hibernate.atlassian.net/browse/HHH-10070

          1 of 1 people found this helpful