You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Jason Punzalan <ja...@gmail.com> on 2005/05/02 22:28:35 UTC

parameter map error

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.