Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1064

Dialect auto detection does not work properly for MySQL

    Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Explicitly specify the dialect in the source connection properties for the JPA connector.

      Show
      Explicitly specify the dialect in the source connection properties for the JPA connector.

      Description

      See result of the test JdbcConnectionTest for MySQL 5.x

      ModeShape requires InnoDB dialect but ordinary MySQL dialect is used.

      https://hudson.qa.jboss.com/hudson/view/SOA-Release/job/soa-modeshape-db-openjdk16/9/DATABASE=mysql51,jdk=openjdk-local,label=RHEL5_any/testReport/junit/org.modeshape.connector.store.jpa/JdbcConnectionTest/shouldAutoDetectDialectAndSetOnJpaSource/

      I am not sure if this causes any real harm, it may be sufficient to document that automatic detection does not work for MySQL.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  rhauch Randall Hauch
                  Reporter:
                  jpechanec Jiri Pechanec
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: