ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manikandan.R, ISDC Chennai" <manikand...@hcltech.com>
Subject RE: Inserting Blob Data in Oracle 9i
Date Fri, 18 Nov 2005 07:39:30 GMT
thanks Nathan.Now the problem is fixed with the help of ojdc14.jar of
oracle 10g( release 2),earlier we tested with older version oracle
driver which lead to the above said problem.

-----Original Message-----
From: Nathan.Maves@Sun.COM [mailto:Nathan.Maves@Sun.COM]
Sent: Thursday, November 17, 2005 10:59 PM
To: user-java@ibatis.apache.org
Subject: Re: Inserting Blob Data in Oracle 9i


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
<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. 



Mime
View raw message