[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-656) nvarchar2

nvarchar2 --------- Key: HBX-656 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-656 Project: Hibernate Tools Issue Type: Improvement Components: reverse-engineer Affects Versions: 3.1.beta5 Environment: Oracle 10g release 2 Reporter: Francois Jean Fix For: 3.2.0.GA Hello, When using Oracle with columns of type NVARCHAR2, the reverse engineering tool maps the columns with a java attribute of type Serializable. We would prefer to have these columns mapped to String. However NVARCHAR2 has no corresponding JDBC type, so recognizing this type by Java would imply to verify the JDBC type and if the JDBC type is unknown then verify the type name and if it's VARCHAR2 than map it to String. Do you think it's a possible solution? For now, we are doing the following in the reverse-eng.xml file, but it's not very neat since it maps all the "OTHER" types to String: <type-mapping> <sql-type jdbc-type="OTHER" hibernate-type="String" /> </type-mapping> Link on Oracle listing the unsupported Oracle type: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/apxref.... Link explaining the use of String with NVARCHAR2: http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/global.... François Jean