Hi Steve, I removed the attachment for two reasons: 1) It contained a restrictive license and 2) iBATIS 2.0.9 includes default BLOB/CLOB typehandlers.
Cheers, Clinton On Mon, 10 Jan 2005 16:13:48 -0600, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi Clinton, > > Can you please attach iBATISClob.zip to > http://issues.apache.org/jira/browse/IBATIS-4? I suspect your JIRA import > did not setup the attachment directory for JIRA. I had the same issue > migrating a test implementation of JIRA to a production server. I had to > manually copy my attachments to the attachment directory on the new server. > > Here is a post I just sent from my client's email account, but I suspect it > may have gotten caught up in my client's spam filter because I haven't seen > it appear it my inbox for this email account. > > > ################################################# > 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> > >
