Joined: Thu May 03, 2007 6:24 pm Posts: 14
|
If I try to persist some text with < 4000 char length in nclob column then no issues
But I try to persist >4000, invalid chars(like inverted ??) are persisted in DB instead of actual text. I'm using oracle 9i with 10g driver along with spring+hibernate.
following are the hibernate settings:
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
<!--
<prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</prop>
<prop key="hibernate.transaction.manager_lookup">org.hibernate.transaction.WebspherExtendedJTATransactionLookup</prop>
<prop key="hibernate.transaction.flush_before_completion">true</prop>
<prop key="hibernate.transaction.auto_close_session">true</prop>
-->
<prop key="hibernate.connection.SetBigStringTryClob">true</prop>
<prop key="hibernate.connection.autocommit">false</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.connection.characterEncoding">UTF-8</prop>
<prop key="hibernate.connection.useUnicode">true</prop>
</props>
</property>
I've mapped clob db field to 'text' type in hbm file
Please let me know how I can solve this issue.
|
|