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.