Chances are that Hibernate generates invalid SQL. Please post the code that Hibernate generates from the statement. (You have to put something like
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.format_sql" value="true" />
into your persistence.xml or hibernate.cfg.xml)
Karsten