ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Punzalan <jasonpunza...@gmail.com>
Subject parameter map error
Date Mon, 02 May 2005 20:28:35 GMT
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.

Mime
View raw message