ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <demablo...@gmail.com>
Subject Re: Issue: CLOB datatype used with iBATIS
Date Fri, 04 Jan 2008 20:27:51 GMT
Are you sure that you're using  10g Oracle JDBC driver ?
I got that exception with  9i Oracle JDBC drivers , but 10g solved it



2008/1/4, BEHL, Manish, IDC <Manish.BEHL@rbs.com>:
>
>   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
>
>
> ***********************************************************************************
> 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.comwww.rbs.com/gbmwww.rbsgc.com
> ***********************************************************************************
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>

Mime
View raw message