[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - How to map Oracle8 Char(3), Char(6) fields

[rrusinkiewicz]

I've tried to map oracle char(3) as follows:
         
            <java-type>java.lang.String</java-type>
            <jdbc-type>VARCHAR</jdbc-type>
            <sql-type>CHAR(3)</sql-type>
         
but it does not help I get the following exceptions:

ObjectName: persistence.units:ear=roc-ejb1.ear,jar=roc-ejb1.jar,unitName=reportoperation
  State: FAILED
  Reason: javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: t$SUNO, expected: varchar2(255)
  I Depend On:
    jboss.jca:service=DataSourceBinding,name=DefaultDS
  Depends On Me:
    jboss.j2ee:ear=roc-ejb1.ear,jar=roc-ejb1.jar,name=ReportOperation,service=EJB3



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987495#3987495

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987495