I'm having trouble inserting or updating on a varchar2(4000) field in oracle. It works for anything under a 1000 characters otherwise it throws an Exception....


org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation): encountered SQLException [  
--- The error occurred in com/company/maps/Content.xml.
--- The error occurred while applying a parameter map.
--- Check the updateContent-InlineParameterMap.
--- Check the parameter mapping for the 'summary' property.
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 1229]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/company/maps/Content.xml.
--- The error occurred while applying a parameter map.
--- Check the updateContent-InlineParameterMap.
--- Check the parameter mapping for the 'summary' property.
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 1229
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/company/maps/Content.xml.
--- The error occurred while applying a parameter map.
--- Check the updateContent-InlineParameterMap.
--- Check the parameter mapping for the 'summary' property.
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 1229
Caused by: java.sql.SQLException: Data size bigger than max size for this type: 1229

content.xml:

    <update id="updateContent" parameterClass="Content" >
        <![CDATA[
            update content
            set  title = #title# , summary = #summary:VARCHAR# ,  enabled = #enabled#
            where  id = #id#
        ]]>
    </update>

Any help would be great...thanks.


Reply via email to