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 Clinton Begin <cl...@gmail.com> on 2005/01/11 03:37:05 UTC

Re: JIRA Load missing attachments

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, stevem@teamics.com
<st...@teamics.com> 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>
>  
>