Help! Database exception!

[chengyao]

I deployed my ejb3 program in JBoss-4.0.3RC1.

It ran well with Hypersonic. But when I changed the datasource to MySQL, there is something wrong. The tables have been created successfully in MySQL. The problem is when JBoss insert new records automatically into these tables. The program throws exception:

WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1C00
14:08:09,102 ERROR [JDBCExceptionReporter] Feature not implemented
14:08:09,118 INFO [STDOUT] javax.ejb.EJBException: null; CausedByException is: could not insert: [mase.wikipage.Requirement]

The persistence.xml file:

<entity-manager>
 <name>mase</name>
 <provider>org.hibernate.ejb.HibernatePersistence</provider>
 <jta-data-source>java:/maseDS</jta-data-source>
 <properties>
 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
 <property name="hibernate.case.use_query_cache" value="true" />
 <property name="hibernate.show_sql" value="true" />
 <property name="hibernate.hbm2ddl.auto" value="update" />
 <property name="hibernate.connection.datasource" value="java:/maseDS"/>
 </properties>
</entity-manager>

Does someone know the reason? Thank you very much.

[jbosschecker]

I have a similar problem with mySQL. I have developed an ejb 3.0 application with jboss 4.0.3 and mySQL, but I did not let JBoss create the tabels. I have created them myself. I get these warnings and error everytime jboss starts up:

... "ERROR could not alter table" ....

But the application does what it has to do!!