0 Replies Latest reply on Nov 21, 2006 4:04 AM by Richard Rusinkiewicz

    How to map Oracle8 Char(3), Char(6) fields

    Richard Rusinkiewicz Newbie

      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