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