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]
<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>
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!!