Opened 14 years ago
Closed 14 years ago
#1566 closed defect (fixed)
MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB
Reported by: | Nicklas Nordborg | Owned by: | everyone |
---|---|---|---|
Priority: | major | Milestone: | BASE 2.17 |
Component: | install | Version: | |
Keywords: | Cc: |
Description
According to the documentation at http://dev.mysql.com/doc/refman/5.5/en/create-table.html TYPE was deprecated in MySQL 4.0. It was removed in MySQL 5.5 and one should use ENGINGE=InnoDB instead.
Hibernate has fixed this some time ago, but it seems like we are still using the older MySQL dialect in the configuration file.
Note:
See TracTickets
for help on using tickets.
(In [5537]) Fixes #1566: MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB
Changes the default dialect to
org.hibernate.dialect.MySQL5InnoDBDialect
. An additional problem was found inContextData.java
which incorrectly usedtype="string" length="65535"
for a column declaration. We must usetype="text"
instead. Unfortunately this means that BASE will not install on MySQL 5.5 until 2.17 is released.