MySQL

[drapierwim]

This has something to do with the sql syntax generated by hibernate(if i'm not wrong). You probably use the latest version of mySQL maybe you should change that to an earlier version and see whats happens.

[marius.oancea]

I use MySQL 5 without problems.

Check the dialect you are using, make sure you use the MySQL one.

my persistence.xml:
<entity-manager>
 <name>zDatabase</name>
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/zDatasource</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
 <property name="hibernate.show_sql" value="true" />
 <property name="hibernate.hbm2ddl.auto" value="update"/>
 </properties>
</entity-manager>

[armita]

Solved my problem Thanks a lot