0 Replies Latest reply on Sep 17, 2007 3:26 AM by yj4jboss

    Error porting Business Objects to Seam 2.0 Beta 1

      Hi All,
      I have been trying to port my Seam 1.1.0 Application to Seam 2.0. I have imported all my business objects which had been reverse engineered using Hibernate Tools in the new Seam 2.0 project environment and deployed under Jboss 4.2.1.

      I am getting errors like

      
      --- MBeans waiting for other MBeans ---
      ObjectName: persistence.units:ear=AEWAProject.ear,unitName=AEWAProject
       State: FAILED
       Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: ActionIndex, expected: integer
       I Depend On:
       jboss.jca:service=DataSourceBinding,name=AEWAProjectDatasource
      
      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: persistence.units:ear=AEWAProject.ear,unitName=AEWAProject
       State: FAILED
       Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: ActionIndex, expected: integer
       I Depend On:
       jboss.jca:service=DataSourceBinding,name=AEWAProjectDatasource
      
      
      
      




      The business objects were working correctly under Seam 1.1.0.


      My persistence.xml is as follows :

      
      <?xml version="1.0" encoding="UTF-8"?>
      <!-- Persistence deployment descriptor for dev profile -->
      <persistence xmlns="http://java.sun.com/xml/ns/persistence"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
       version="1.0">
      
       <persistence-unit name="AEWAProject">
       <provider>org.hibernate.ejb.HibernatePersistence</provider>
       <jta-data-source>java:/AEWAProjectDatasource</jta-data-source>
       <properties>
       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect" />
       <property name="hibernate.hbm2ddl.auto" value="validate"/>
       <property name="hibernate.cache.use_query_cache" value="true"/>
       <property name="hibernate.show_sql" value="true"/>
       <property name="jboss.entity.manager.factory.jndi.name" value="java:/AEWAProjectEntityManagerFactory"/>
       <property name="hibernate.default_catalog" value="accountingAudit"/>
       </properties>
       </persistence-unit>
      
      </persistence>
      
      
      
      





      I tried changing the property

       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect" />
      
      



      to

       <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
      
      



      and it resulted into a similar wrong column type error but for a different object.



      Can anyone suggest what might be the problems .



      Cheers,
      Jankee Yogesh
      M-ITC LTD