[cosmo-dev] Cosmo 0.14 fresh install and MySQL Database

[Randy Letness]

Guillaume Gautreau wrote:
>
>
> As you can see, a table could not be created, due to a syntax error :
>
>     Unsuccessful schema statement: create table attribute [...]
>     com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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
>     '*clob*(102400000), intvalue bigint, stringvalue varchar(2048),
>     itemid bigint not n' at line 1
>


This looks like you need to set 
cosmo.hibernate.dialect=org.osaf.cosmo.hibernate.CosmoMySQL5InnoDBDialect 
in etc/cosmo.properties.

-Randy