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.
