Language characters save as ¿¿¿¿¿¿¿¿ in Oracle data base with jboss 7

[sirikumara]

Dear All,

I want to know how to save language characters(Japanese,Arabic, Russian) in data base. I have defined data source in standalone-full-standalone.xml as bellow.

<connection-url>Connection URL</connection-url>

<connection-property name="char.encoding">UTF-8</connection-property>

<driver>oracle</driver>

<pool>

<min-pool-size>2</min-pool-size>

<max-pool-size>10</max-pool-size>

<prefill>true</prefill>

</pool>

<security>

<user-name>UserName</user-name>

<password>Password</password>

</security>

<statement>

<prepared-statement-cache-size>100</prepared-statement-cache-size>

<share-prepared-statements>true</share-prepared-statements>

</statement>

Records are saved with java code :  getHibernateTemplate().saveOrUpdate(Object);

Please let me know the correct configuration to save language text in data base.

Thanks.

[sirikumara]

Please any idea.. ????

[lafr]

Hard to guess. Some thoughts that came to my mind:

Oracle server has appropriate settings for UTF-8 content?

You're using the correct datatype for those columns?

You're using the latest JDBC database driver ojdbc6.jar?

Do you have any NLS-variables set in your environment where starting jboss?

[sirikumara]

Thanks for reply..

Column data type : NCLOB;

Driver ojdbc6.jar : Version: 11.2.0.2.0 and I replaced with the latest one. but same result.

In DB, NLS_LANGUAGE : AMERICAN

Language characters are saved correctly with websphere and jboss 4.2. After migrating to jboss EAP 6, Language character saved as invalid. So problem should be with jboss EAP 6 configuration.

There are 17 Languages in the project. all non English characters are saved as ¿¿¿¿¿¿¿¿.