1 Reply Latest reply on Oct 13, 2005 5:28 PM by kourosh bagheri

    Help! Database exception!

    Chengyao Deng Newbie

      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.

        • 1. Re: Help! Database exception!
          kourosh bagheri Newbie

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