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 <[EMAIL PROTECTED]>: > > 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 > [EMAIL PROTECTED] > 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 > ______________________________________________________________________ >
