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 Nathan Maves <Na...@Sun.COM> on 2005/01/11 00:04:28 UTC
Re: Default CLOB/BLOB Handlers in 2.0.9
Steve,
I use the 2.0.9 version with Oracle9i Enterprise Edition Release
9.2.0.2.0. I have never tried CLOB's but I use BLOB's all the time and
they are all larger then 4k.
I would suggest not specifying the type and let iBatis figure it out
for you. I assume that the description field is a java.lang.String.
Nathan
On Jan 10, 2005, at 3:41 PM, stevem@teamics.com wrote:
> Can the new Default CLOB/BLOB Handlers in 2.0.9 be used with Oracle
> 9i? I looked in http://issues.apache.org/jira/browse/IBATIS-4 for
> iBATISClob.zip, but I didn't find the ZIP file there. I tried using
> the 2.0.9 default CLOB Handler with Oracle, but it only works with
> data less than 4 KB. If I have more than 4 KB of data I get
> "java.sql.SQLException: Data size bigger than max size for this type:
> xxxx".
>
> My mapping looks like this:
> <insert id="insertProductRequirement"
> parameterClass="com.serff.prl.core.ProductRequirement">
> INSERT INTO
> PRODUCT_REQ (PRODUCT_REQ_ID, DESCRIPTION, FILING_TYPES,
> PRODUCT_ID, PRODUCT_REQ_CAT_ID, SERFF_STATE_ID,
> DATE_LAST_MODIFIED, USER_LAST_MODIFIED, DATE_CREATED, USER_CREATED)
> VALUES (#id:NUMERIC#, #description:CLOB#,
> #filingTypes:VARCHAR#,
> #product.id:NUMERIC#,
> #productRequirementCategory.id:NUMERIC#, #state.id:NUMERIC#,
> #lastModified#, #userLastModified:VARCHAR#, #dateCreated#,
> #userCreated:VARCHAR#)
> </insert>
>
>