Hi,
I'm having trouble getting autoddl to generate the below class with Connector/J 3.1.12 (also 3.1.10, 3.1.11):

<class name="uk.ac.cam.caret.sakai.rwiki.component.message.model.impl.TriggerImpl"
table="rwikipagetrigger" >
<id name="id" unsaved-value="null" >
<column name="id" length="36" not-null="true"/>
<generator class="uuid.hex" />
</id>
<property name="user" column="userid" not-null="true" index="true" type="string" length="64" />
<property name="pagespace" column="pagespace" type="string" index="true" length="255"/>
<property name="pagename" column="pagename" type="string" index="true" length="255" />
<property name="lastseen" column="lastseen" type="timestamp" />
<property name="triggerspec" type="text" />
</class>

When hibernate starts up we get the below exception:

WARN: Unsuccessful schema statement: create table rwikipagetrigger (id varchar(36) not null, us
erid varchar(64) not null, pagespace varchar(255), pagename varchar(255), lastseen timestamp, t
riggerspec longvarchar, primary key (id)) (2005-12-07 10:20:03,267 main_org.springframework.orm
.hibernate.LocalSessionFactoryBean)
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'longvarchar, primary key (id))'
at line 1

Anyone got any ideas how to fix this?

It turns out that the dialect wasn't being set correctly, and auto.ddl was being generated for HSQL rather than MySQL.