How to support multiple languages with hibernate

[samir ware]

Hello all
I am using hibernate along with spring and weblogic server. However when I persist any Chinese data into the database using hibernate, its not getting persisted properly. I was able to find its fix on local by using following configuration.

 <bean id="mydatasource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
        <property name="driverClassName" value="${database.driverClassName}"/>
        <property name="url" value="${database.url}"/>
        <property name="username" value="${database.username}"/>
        <property name="password" value="${database.password}"/>
        <property name="initialSize" value="5"/>
       [color=red] <property name="connectionProperties" value="defaultNChar=true"/>[/color]
       
    </bean>

However on production, I am using weblogic datasource thery by doing jndi lookup. Because of this there is no way I can use this configuration on production. The datasource look up is being done through below configuration.

<jee:jndi-lookup jndi-name="COIM_DS" id="dms_dataSource"></jee:jndi-lookup>

I tried setting up below mentioned configurations on persistence.xml although it did not yield any result

<property name="hibernate.connection.useUnicode" value="true" />
<property name="hibernate.connection.characterEncoding" value="UTF-8" />
<property name="hibernate.connection.charSet" value="UTF-8" />
<property name="hibernate.connection.defaultNChar" value="true"/>

Can someone please tell me how should I deal with this situation ?
Any link , white paper will greatly be appreciated.
Thanks in advance
Samir

[samir ware]

Hello Ranchers
I was able to resolve this issue. On weblogic console one need to set the below mentioned value in the "System Properties" box under "Data Source" -> "Your Data Source" -> "Connection Pool" - > properties

defaultNChar=true

This worked for me .
Happy coding
Thanks
Samir