Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 4466 invoked from network); 4 Jan 2008 12:57:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Jan 2008 12:57:57 -0000 Received: (qmail 71580 invoked by uid 500); 4 Jan 2008 12:57:44 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 71386 invoked by uid 500); 4 Jan 2008 12:57:43 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 71375 invoked by uid 99); 4 Jan 2008 12:57:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Jan 2008 04:57:43 -0800 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Yuvraj.Shinde@sos.sungard.com designates 216.32.180.16 as permitted sender) Received: from [216.32.180.16] (HELO outbound4-va3-R.bigfish.com) (216.32.180.16) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Jan 2008 12:57:18 +0000 Received: from outbound4-va3.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound4-va3-R.bigfish.com (Postfix) with ESMTP id 550611678ADF for ; Fri, 4 Jan 2008 12:54:30 +0000 (UTC) Received: from mail95-va3-R.bigfish.com (si1-va3 [10.7.14.5]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by outbound4-va3.bigfish.com (Postfix) with ESMTP id 52C7F1138051 for ; Fri, 4 Jan 2008 12:54:30 +0000 (UTC) Received: from mail95-va3 (localhost.localdomain [127.0.0.1]) by mail95-va3-R.bigfish.com (Postfix) with ESMTP id 3C403155816D for ; Fri, 4 Jan 2008 12:54:30 +0000 (UTC) X-BigFish: V X-MS-Exchange-Organization-Antispam-Report: OrigIP: 59.160.68.42;Service: EHS Received: by mail95-va3 (MessageSwitch) id 1199451270152172_24301; Fri, 4 Jan 2008 12:54:30 +0000 (UCT) Received: from smtp2.ascindia.com (unknown [59.160.68.42]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail95-va3.bigfish.com (Postfix) with ESMTP id B8FDC1040072 for ; Fri, 4 Jan 2008 12:54:28 +0000 (UTC) Received: from SOS-MAILSRV.ascindia.com (sos-mailsrv1.ascindia.com [10.253.58.2]) by smtp2.ascindia.com (8.12.8/8.12.8) with ESMTP id lBP5A6gw032234 for ; Tue, 25 Dec 2007 10:40:07 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C84ED0.EEADEFEF" Subject: RE: Issue: CLOB datatype used with iBATIS Date: Fri, 4 Jan 2008 18:24:23 +0530 Message-ID: <5EBE57594E74E84DB1DC6BA8E279389D0706F509@SOS-MAILSRV.ascindia.com> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Issue: CLOB datatype used with iBATIS Thread-Index: AchOz+CTNLrOVoKHTl6j+OuVDTr1xgAANhiQ References: From: "Yuvraj Shinde" To: X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C84ED0.EEADEFEF Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable hi manish, =20 use ClobTypeHandlerCallback in your resultmap of Sql file.it will resolve your issue. =20 Regards Yuvraj Shinde * Senior Software Engineer - Zainet* SunGard * Offshore Services * Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati Bapat Road, shivajinagar,Pune 411016 Tel Direct +91 20 66248045 * Main +91 20 66248000 * Fax +91 20 25606222 yuvraj.shinde@sos.sungard.com * www.sungard.com =20 =20 ________________________________ From: BEHL, Manish, IDC [mailto:Manish.BEHL@rbs.com]=20 Sent: Friday, January 04, 2008 6:17 PM To: user-java@ibatis.apache.org Subject: Issue: CLOB datatype used with iBATIS =20 Hi , =20 I am currently facing an issue with usage of iBATIS(to which i am new to). Hope somone(who might have faced the same issue before) can help me out upto some extent ! =20 There is an article already published with title ( How do I use a BLOB or CLOB ?) in FAQ section . Refer - http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+u se+a+BLOB+or+CLOB. This issue is absolutely similar to my problem, but after following all the steps (advised by Nathan) , i am still not able to get the solution=20 =20 My detailed problem definition is as follow-=20 In one of the database table , we are having a column of type CLOB (since we wish to persist xml data into it which may exceed 4k characters]. Even after using CLOB as the data type, I am getting the exception=20 --- Cause: java.sql.SQLException: Data size bigger than max size for this type: 7533 Following are the version details of softwares used - 1) Oracle database server --> Release 10.2.0.1.0=20 2) JDBC driver --> 10.2.0.3.0 (which i had recently upgraded from 9.0.2.0 ,based on your advise posted in this article) =20 I am stuck up with this issue for past couple of days, which is hampering my project's progress.=20 =20 Your timely response/assistance will be highly appreciated. =20 Regards Manish Behl RBS India Development Centre (P) Ltd T +91 124 433 6150 F +91 124 433 6500 manish.behl@rbs.com Unitech Business Park, Block F, Sector 41, South City 1, Gurgaon - 122001, Haryana, Delhi, India P Please don't print this e-mail unless you really need to.=20 www.rbs.com =20 =20 =20 ************************************************************************ *********** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB.=20 Authorised and regulated by the Financial Services Authority=20 =20 This e-mail message is confidential and for use by the=20 addressee only. If the message is received by anyone other=20 than the addressee, please return the message to the sender=20 by replying to it and then delete the message from your=20 computer. Internet e-mails are not necessarily secure. The=20 Royal Bank of Scotland plc does not accept responsibility for=20 changes made to this message after it was sent.=20 =20 Whilst all reasonable care has been taken to avoid the=20 transmission of viruses, it is the responsibility of the recipient to=20 ensure that the onward transmission, opening or use of this=20 message and any attachments will not adversely affect its=20 systems or data. No responsibility is accepted by The=20 Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.=20 Visit our websites at:=20 www.rbs.com www.rbs.com/gbm www.rbsgc.com ************************************************************************ *********** ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email=20 ______________________________________________________________________ ------_=_NextPart_001_01C84ED0.EEADEFEF Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

hi = manish,

 

=

     use = ClobTypeHandlerCallback in your resultmap of  Sql file.it will resolve your = issue.

 

=

Regards

Yuvraj Shinde • Senior Software = Engineer -  Zainet•  SunGard • Offshore Services • = Pride Portal,CTS No 103A/5A/1A/1B Bhamburda,Senapati Bapat Road, = shivajinagar,Pune 411016 Tel Direct +91 20 66248045 • Main +91 20 66248000 • = Fax +91 20  25606222 yuvraj.shinde@sos.sungard.com<= /a> • www.sungard.com=

 

From: BEHL, = Manish, IDC [mailto:Manish.BEHL@rbs.com]
Sent: Friday, January 04, = 2008 6:17 PM
To: = user-java@ibatis.apache.org
Subject: Issue: CLOB = datatype used with iBATIS

 

Hi = ,

 

I = am currently facing an issue with usage of iBATIS(to which i am new to). Hope somone(who might have faced the same issue before)  can = help me out upto some extent !

 

There is an article already published with title ( How = do I use a BLOB or CLOB ?) in FAQ section . Refer - http://opensource.atlassian.com/confluence/oss= /display/IBATIS/How+do+I+use+a+BLOB+or+CLOB. This issue is absolutely similar to my problem, but after following all = the steps (advised by Nathan) , i am still not able to get the solution =

 

My = detailed  problem definition is as follow-

In = one of the database table , we are having  a column of type CLOB = (since we wish to persist xml data into it which may exceed 4k characters]. = Even after using CLOB as the data type,

I = am getting the exception

--- = Cause: java.sql.SQLException: Data size bigger than max size for this type: = 7533

Following are the version details of softwares used -

1) = Oracle database server --> Release = 10.2.0.1.0 

2) = JDBC driver  --> 10.2.0.3.0 (which i had recently upgraded from = 9.0.2.0 ,based on your advise posted in this = article)

 

I = am stuck up with this issue for past couple of days, which is hampering my = project's progress.

 

Your timely response/assistance will be highly = appreciated.

 

Regards

Manish = Behl
RBS India Development Centre = (P) Ltd

T  +91 124 433 = 6150
F  +91 124 433 = 6500
manish.behl@rbs.com
Unitech = Business Park, Block = F, Sector 41, South City 1,
Gurgaon - 122001, Haryana, Delhi, India

P Please don't print this e-mail unless you really need to.
www.rbs.com<= /p>

 

 
**********************************************=
*************************************
=
The Royal =
Bank of Scotland plc. Registered in Scotland No 90312. =
Registered Office: 36 St Andrew Square, =
Edinburgh EH2 =
2YB. =

Authorised and regulated by the Financial =
Services Authority 
 
This =
e-mail message is confidential and for use by the =

addressee =
only. If the message is received by anyone other =

than the =
addressee, please return the message to the sender =

by =
replying to it and then delete the message from your =

computer. =
Internet e-mails are not necessarily secure. The =

Royal =
Bank of Scotland plc does not accept responsibility for =

changes =
made to this message after it was sent. =

 
Whilst =
all reasonable care has been taken to avoid the =

transmission of viruses, it is the =
responsibility of the recipient to =

ensure =
that the onward transmission, opening or use of this =

message =
and any attachments will not adversely affect its =

systems =
or data. No responsibility is accepted by The =

Royal =
Bank of Scotland plc in this regard and the recipient should carry =

out such =
virus and other checks as it considers appropriate. =

Visit our =
websites at: 
www.rbs.com
www.rbs.com/gbm= 
www.rbsgc.com
**********************************************= *************************************


______________________________________________________________________ This email has been scanned by the MessageLabs Email Security = System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

------_=_NextPart_001_01C84ED0.EEADEFEF--