ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ste...@teamics.com
Subject Default CLOB/BLOB Handlers in 2.0.9
Date Mon, 10 Jan 2005 22:41:02 GMT
<div>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.&nbsp; I tried
using the 2.0.9 default CLOB Handler with Oracle, but it only works
with data less than 4 KB.&nbsp; If I have more than 4 KB of data I get
"java.sql.SQLException: Data size bigger than max size for this type:
xxxx".<br>
<br>
My mapping looks like this:<br>
&nbsp;&nbsp;&nbsp; &lt;insert id="insertProductRequirement" parameterClass="com.serff.prl.core.ProductRequirement"&gt;<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; INSERT INTO<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; PRODUCT_REQ (PRODUCT_REQ_ID,
DESCRIPTION, FILING_TYPES, <br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; PRODUCT_ID, PRODUCT_REQ_CAT_ID,
SERFF_STATE_ID, DATE_LAST_MODIFIED, USER_LAST_MODIFIED, DATE_CREATED,
USER_CREATED)<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; VALUES (#id:NUMERIC#, #description:CLOB#,
#filingTypes:VARCHAR#,<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; #product.id:NUMERIC#,
#productRequirementCategory.id:NUMERIC#, #state.id:NUMERIC#,
#lastModified#, #userLastModified:VARCHAR#, #dateCreated#,
#userCreated:VARCHAR#)<br>
&nbsp;&nbsp;&nbsp; &lt;/insert&gt;<br>
<br><div><br></div></div>
Mime
View raw message