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