Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-7804

Update MySQLDialect since it uses MyISAM instead of InnoDB with upgraded Hibernate libs

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: EJBCA 7.0.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      JBoss EAP 7.2 with hibernate-core-5.3.7.Final-redhat-00001.jar
    • Issue discovered during:
      Another issue
    • Sprint:
      EJBCA Team Alice - 2019 w6

      Description

      org.hibernate.dialect.MySQLDialect will generate tables with type=MyISAM. Using org.hibernate.dialect.MySQL5InnoDBDialect instead will fix this.

      According to https://docs.jboss.org/hibernate/orm/5.3/javadocs/org/hibernate/dialect/package-summary.html the org.hibernate.dialect.MySQL5InnoDBDialect is deprecated.

      The correct future way would be to use org.hibernate.dialect.MySQL5Dialect with the additional property hibernate.dialect.storage_engine=innodb, but the current framework / build scripts would require a bit more handling for this to happen.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              tomas Tomas Gustavsson
              Reporter:
              johan Johan Eklund
              Verified by:
              Henrik Sunmark
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 hour
                  1h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h