[jboss-user] [JBoss Seam] - EJB3, NVARCHAR2 and Oracle10g

I am using Seam 2.0 and when I try mapping a existing table nvarchar2 column to a EJb3 entity attribute, I am getting a following exception. | [testng] javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: CITY, expected: varchar2(255) | I googled and searched the forum(hibernate), but nothing solved my problem. I have set the defaultNChar flag both in hibernate(persistence.xml) and datasource.xml. I even tried the columnDefinition suggested in seam forum. Below is the persistence.xml I am using. | <persistence-unit name="hain"> | <provider>org.hibernate.ejb.HibernatePersistence</provider> | <jta-data-source>java:/hainDatasource</jta-data-source> | <properties> | <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/> | <property name="hibernate.hbm2ddl.auto" value="validate"/> | <property name="hibernate.show_sql" value="true"/> | <property name="jboss.entity.manager.factory.jndi.name" value="java:/ChainEntityManagerFactory"/> | <property name="hibernate.default_schema" value="hodb"/> | <property name="hibernate.connection.defaultNChar" value = "true"/> | </properties> | </persistence-unit> | | </persistence> hain-ds.xml <datasources> | | <local-tx-datasource> | <jndi-name>hainDatasource</jndi-name> | <connection-url>jdbc:oracle:thin:@ts-dev:1521:tcdev</connection-url> | <driver-class>oracle.jdbc.OracleDriver</driver-class> | <user-name>user</user-name> | <password>password</password> | <connection-property name = "oracle.jdbc.defaultNChar">true</connection-property> | | </datasources> | | Is there any standard way defined in EJB3?. I refered both Pro EJB and EJB in Action books. But both didnt help. Thanks in Advance View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4102413#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...