Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Thu, 17 Nov 2005 10:29:06 -0700
From: Nathan Maves <Nathan.Maves@Sun.COM>
Subject: Re: Inserting Blob Data in Oracle 9i
In-reply-to: 
 <083743079D8BF041B38B3E2BE77A6F53080C1912@hwdsaddc.msdc.hcltech.com>
Sender: Nathan.Maves@Sun.COM
To: user-java@ibatis.apache.org
Message-id: <583407EF-2EA7-496F-BA18-1D9B3779459D@sun.com>
MIME-version: 1.0
Content-type: multipart/alternative;
 boundary="Boundary_(ID_UZvffehJf4cbNCuZA0t4TA)"
References: 
 <083743079D8BF041B38B3E2BE77A6F53080C1912@hwdsaddc.msdc.hcltech.com>


--Boundary_(ID_UZvffehJf4cbNCuZA0t4TA)
Content-type: text/plain; format=flowed; delsp=yes; charset=US-ASCII
Content-transfer-encoding: 7BIT

Well for starters I am not sure why you wrote your own Custom Type  
Handler (CTH).  Both the CLOB and BLOB handlers are now built into  
iBatis.

But in any case I think you will find your answer here...

http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do 
+I+use+a+BLOB+or+CLOB

Looks towards the bottom.

Nathan

On Nov 17, 2005, at 9:48 AM, Manikandan.R, ISDC Chennai wrote:

> Hi,
> We are doing some feasibility analysis on IBatis SqlMapper. We are  
> using Oracle 9i database and ojdbc14.jar as driver, and we have  
> external Typehandlers for clob and blob data and are matched to  
> String and byte array respectively. As for as fetching blob and  
> clob from database there is no issue. Whenever we tried to insert  
> some binary data of size greater than 4k we come across an issue of  
> 'connection reset by peer - socket write error'. We persume that  
> this error is because of taking lot of time to execute the query.  
> What could be the change we need to do, to resolve this issue.
>
> thanks in advance,
> Manikandan R.
>


--Boundary_(ID_UZvffehJf4cbNCuZA0t4TA)
Content-type: text/html; charset=ISO-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; ">Well for starters I am not su=
re why you wrote your own Custom Type Handler (CTH).=A0 Both the CLOB=
 and BLOB handlers are now built into iBatis.<DIV><BR class=3D"khtml-=
block-placeholder"></DIV><DIV>But in any case I think you will find y=
our answer here...</DIV><DIV><BR class=3D"khtml-block-placeholder"></=
DIV><DIV><A href=3D"http://opensource2.atlassian.com/confluence/oss/d=
isplay/IBATIS/How+do+I+use+a+BLOB+or+CLOB">http://opensource2.atlassi=
an.com/confluence/oss/display/IBATIS/How+do+I+use+a+BLOB+or+CLOB</A><=
/DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV><DIV>Looks towa=
rds the bottom.</DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV=
><DIV>Nathan</DIV><DIV><BR><DIV><DIV>On Nov 17, 2005, at 9:48 AM, Man=
ikandan.R, ISDC Chennai wrote:</DIV><BR class=3D"Apple-interchange-ne=
wline"><BLOCKQUOTE type=3D"cite"> <P><FONT size=3D"2">Hi,</FONT> <BR>=
<FONT size=3D"2">We are doing some feasibility analysis on IBatis Sql=
Mapper. We are using Oracle 9i database and ojdbc14.jar as driver, an=
d we have external Typehandlers for clob and blob data and are matche=
d to String and byte array respectively. As for as fetching blob and =
clob from database there is no issue. Whenever we tried to insert som=
e binary data of size greater than 4k we come across an issue of 'con=
nection reset by peer - socket write error'. We persume that this err=
or is because of taking lot of time to execute the query. What could =
be the change we need to do, to resolve this issue.</FONT></P><P><FON=
T size=3D"2">thanks in advance,</FONT> <BR><FONT size=3D"2">Manikanda=
n R.</FONT> </P>  </BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>

--Boundary_(ID_UZvffehJf4cbNCuZA0t4TA)--