Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3791

sql server scripts use identities instead of sequences for springboot

    XMLWordPrintable

Details

    • Bug
    • Status: Verified (View Workflow)
    • Major
    • Resolution: Done
    • 7.8.1.GA
    • 7.12.0.GA
    • jBPM Core
    • None
      • Sql Server 2017
    • Hide

      Try to start RHPAM from springboot with an Sql server 2017 database using SQLServer2012Dialect and tables created with our provided scripts in https://access.redhat.com/jbossnetwork/restricted/listSoftware.html?downloadType=distributions&product=rhpam&version=7.08.1

      Show
      Try to start RHPAM from springboot with an Sql server 2017 database using SQLServer2012Dialect and tables created with our provided scripts in https://access.redhat.com/jbossnetwork/restricted/listSoftware.html?downloadType=distributions&product=rhpam&version=7.08.1
    • Workaround Exists
    • Hide

      Letting hibernate to create the tables

      <hibernate.hbm2ddl.auto>create</hibernate.hbm2ddl.auto>
      

      All work correctly

      Show
      Letting hibernate to create the tables <hibernate.hbm2ddl.auto>create</hibernate.hbm2ddl.auto> All work correctly
    • ?

    Description

      Using our provided ddl scripts sql server tables are created with identities:

          create table SessionInfo (
              id numeric(19,0) identity not null,
              lastModificationDate datetime,
              rulesByteArray image,
              startDate datetime,
              OPTLOCK int,
              primary key (id)
          );
      

      but sqlserver2012dialect is expecting sequences

      WARN  SqlExceptionHelper             |  |: SQL Error: 208, SQLState: S0002
      SqlExceptionHelper             |  |: Invalid object name 'SESSIONINFO_ID_SEQ'.
      WARN  PersistableRunner              |  |: Could not commit session
      javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      

      Looks like jbpm project distinguish from sqlserver2008 and sqlserver above 2008 but use of identities is the same:

      Attachments

        Issue Links

          Activity

            People

              elguardian@gmail.com Enrique González Martínez (Inactive)
              afanjula@redhat.com Alberto Fanjul Alonso
              Gonzalo Muñoz Fernández Gonzalo Muñoz Fernández
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: