[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-886) hbm2ddl generating too long index on MySQL

hbm2ddl generating too long index on MySQL ------------------------------------------ Key: HHH-886 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-886 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.0.5 Environment: MySQL 4.1.11-standard, MyISAMI, table with default charset utf8 Reporter: Oleg Marchuk SchemaExport log: alter table CountryLocal drop foreign key FK610C39952D58FB2F; drop table if exists CountryLocal; drop table if exists schedule; create table CountryLocal ( id varchar(255) not null, name varchar(255) not null, lang varchar(255) not null, primary key (id, lang) ); 17:19:59,997 ERROR SchemaExport:167 - Unsuccessful: create table CountryLocal (id varchar(255) not null, name varchar(255) not null, lang varchar(255) not null, primary key (id, lang)) 17:20:00,003 ERROR SchemaExport:168 - Syntax error or access violation message from server: "Specified key was too long; max key length is 1000 bytes" create table schedule ( id varchar(255) not null, primary key (id) ); alter table CountryLocal add index FK610C39952D58FB2F (id), add constraint FK610C39952D58FB2F foreign key (id) references schedule (id); 17:20:00,014 ERROR SchemaExport:167 - Unsuccessful: alter table CountryLocal add index FK610C39952D58FB2F (id), add constraint FK610C39952D58FB2F foreign key (id) references schedule (id) 17:20:00,015 ERROR SchemaExport:168 - Base table or view not found message from server: "Table 'test_oleg.CountryLocal' doesn't exist" Mapping: <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="com.softzonenet"> <class name="Test" table="schedule" lazy="false"> <id name="id" type="string"> <generator class="assigned" /> </id> <map name="names" lazy="false" table="CountryLocal" cascade="delete"> <key column="id" not-null="true" /> <map-key type="string" column="lang" /> <element type="string" column="name" not-null="true" /> </map> </class> </hibernate-mapping> Class: package com.softzonenet; public class Test { private String id = null; Test() { } public String getId() { return id; } public void setId(String id) { this.id = id; } }