Hi,
while trying to insert and retrieve the Japanese character into oracle DB
i am facing to connect the DB using Hibernate 3.2 with having the property

<property name="charSet" value="UTF-8"/>

without using this property if i retrieve the Japanese string then i getting the string like "ƒƒOƒCƒ“"

on using this property i am getting invalid property Error

org.springframework.beans.InvalidPropertyException: Invalid property 'charSet' of bean class [org.apache.commons.dbcp.BasicDataSource]: No property 'charSet' found.


For Reference i Have the Properties like this.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
<property name="url" value="jdbc:oracle:thin:@10.33.195.65:1521:mydb"/>
<property name="username" value="mydb"/>
<property name="password" value="mydb"/>
<property name="charSet" value="UTF-8"/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>
</beans>

please help me to have the correct property in Hibernate configuration for inserting the Japanese character.
Thanks in advance.
Mallikarjun

The complete name for this property is "connection.charset"

Regards,
Eva.

Thanks Eva for your info,

However i resolved this issue by instilling the new Oracle DB instance By setting the CharacterSet="AL32UTF8" instead of the default one. this will save all the Japanese and Chinese characters,
If you are using the third party clients like Toad make sure these tools will support multi language.

Now even not using the "connection.charset" property also it is working fine i guess this will be taken care by the Drivar.

Thanks you all
Mallikarjun Revgond