Changeset 5537

Timestamp:

Dec 21, 2010, 1:52:31 PM (12 years ago)

Author:

Nicklas Nordborg

Message:

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 in ContextData.java which incorrectly used type="string" length="65535" for a column declaration. We must use type="text" instead. Unfortunately this means that BASE will not install on MySQL 5.5 until 2.17 is released.

Location:

trunk

Files:

• config/dist/base.config (modified) (1 diff)
• src/core/net/sf/basedb/core/data/ContextData.java (modified) (1 diff)

trunk/config/dist/base.config

@@ -28 +28 @@
 # MySQL
 # -----
-db.dialect          = org.hibernate.dialect.MySQLInnoDBDialect
+db.dialect          = org.hibernate.dialect.MySQL5InnoDBDialect
 db.driver           = com.mysql.jdbc.Driver
 db.url              = jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true

trunk/src/core/net/sf/basedb/core/data/ContextData.java

@@ -253 +253 @@
     @hibernate.collection-key column="`context_id`"
     @hibernate.collection-index column="`name`" type="string" length="255"
-    @hibernate.collection-element column="`value`" type="string" length="65535"
+    @hibernate.collection-element column="`value`" type="text"
   */
   public Map<String, String> getSettings()