Added by Chris Henson, last edited by Chris Henson on Jun 24, 2009  (view change)

Labels:

oracle oracle Delete
clob clob Delete
17157 17157 Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

If you have a CLOB column on Oracle that is failing to sync because of the size with the following error:

SQL state [null]; error code [17157]; setString can only process strings of less than 32766 chararacters;

Starting with 10.2g you can set a connection property (SetBigStringTryClob) to allow the JDBC driver to treat the CLOB properly.

The following is an example of how to configure SymmetricDS's datasource in an symmetric-*-ext.xml Spring file.

<bean class="org.springframework.beans.factory.config.MethodInvokingFactoryBean" lazy-init="false">
        <property name="targetObject" ref="dataSource"/>
        <property name="targetMethod" value="addConnectionProperty" />
        <property name="arguments">
            <list>
                <value>SetBigStringTryClob</value>
                <value>true</value>
            </list>
        </property>
    </bean>