You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "BEHL, Manish, IDC" <Ma...@rbs.com> on 2008/01/04 13:46:51 UTC
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<ma...@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<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/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.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
______________________________________________________________________
Re: problem in using jdbcType="CHAR"
Posted by Richard Yee <ry...@cruzio.com>.
Manish,
I think you are looking in the wrong place. The error says: "--- Check
the insertCashFlowMessage-InlineParameterMap."
It appears that you are trying to insert a null value in a field that is
Not Null?
-Richard
BEHL, Manish, IDC wrote:
> Hi,
>
> I having a column of datatype CHAR in database. I am encountering
> NullPointerException when i use jdbcType='CHAR' in my resultMap (see
> line in red)
> Below is the snippet of xml file -
>
> <resultMap id="outMsgMap"
> class="com.rbs.rbsgbl.loaniq.cashflows.datastore.data.OutboundMessage">
>
> <result column="MESSAGE_ID" property="lgMessageId" jdbcType="NUMBER"/>
>
> <result column="PAYLOAD" property="strPayload" jdbcType="CLOB"
> typeHandler="com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback" />
>
> <result column="MESSAGE_TYPE" property="strMessageType"
> jdbcType="VARCHAR"/>
>
> <result column="MESSAGE_VERSION" property="intMessageVersion"
> jdbcType="NUMBER"/>
>
> <result column="ARGON_ID" property="strArgonId" jdbcType="VARCHAR"/>
>
> <result column="CREATE_TIME" property="tstmpCreateTime"
> jdbcType="TIMESTAMP"/>
>
> <result column="MESSAGE_STATUS" property="chMessageStatus"
> jdbcType="CHAR" />
>
> </resultMap>
>
> *Exception log is as follows:*
>
> --- The error occurred in
> com/rbs/rbsgbl/loaniq/cashflows/datastore/outboundMessage.xml.
>
> --- The error occurred while applying a parameter map.
>
> --- Check the insertCashFlowMessage-InlineParameterMap.
>
> --- Check the parameter mapping for the 'chMessageStatus' property.
>
> --- Cause: java.lang.NullPointerException; nested exception is
> _com.ibatis.common.jdbc.exception.NestedSQLException_:
>
> --- The error occurred in
> com/rbs/rbsgbl/loaniq/cashflows/datastore/outboundMessage.xml.
>
> --- The error occurred while applying a parameter map.
>
> --- Check the insertCashFlowMessage-InlineParameterMap.
>
> --- Check the parameter mapping for the 'chMessageStatus' property.
>
> --- Cause: _java.lang.NullPointerException_
>
> Caused by: _java.lang.NullPointerException_
>
> Kinly let me know solution to this , if anyone knows about it already
>
> Regards
>
> *Manish Behl*
> RBS India Development Centre (P) Ltd
>
> T +91 124 433 6150
> F +91 124 433 6500
> _manish.behl@rbs.com <ma...@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
> <outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/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.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
> ______________________________________________________________________
problem in using jdbcType="CHAR"
Posted by "BEHL, Manish, IDC" <Ma...@rbs.com>.
Hi,
I having a column of datatype CHAR in database. I am encountering NullPointerException when i use jdbcType='CHAR' in my resultMap (see line in red)
Below is the snippet of xml file -
<resultMap id="outMsgMap" class="com.rbs.rbsgbl.loaniq.cashflows.datastore.data.OutboundMessage">
<result column="MESSAGE_ID" property="lgMessageId" jdbcType="NUMBER"/>
<result column="PAYLOAD" property="strPayload" jdbcType="CLOB" typeHandler="com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback" />
<result column="MESSAGE_TYPE" property="strMessageType" jdbcType="VARCHAR"/>
<result column="MESSAGE_VERSION" property="intMessageVersion" jdbcType="NUMBER"/>
<result column="ARGON_ID" property="strArgonId" jdbcType="VARCHAR"/>
<result column="CREATE_TIME" property="tstmpCreateTime" jdbcType="TIMESTAMP"/>
<result column="MESSAGE_STATUS" property="chMessageStatus" jdbcType="CHAR" />
</resultMap>
Exception log is as follows:
--- The error occurred in com/rbs/rbsgbl/loaniq/cashflows/datastore/outboundMessage.xml.
--- The error occurred while applying a parameter map.
--- Check the insertCashFlowMessage-InlineParameterMap.
--- Check the parameter mapping for the 'chMessageStatus' property.
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/rbs/rbsgbl/loaniq/cashflows/datastore/outboundMessage.xml.
--- The error occurred while applying a parameter map.
--- Check the insertCashFlowMessage-InlineParameterMap.
--- Check the parameter mapping for the 'chMessageStatus' property.
--- Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Kinly let me know solution to this , if anyone knows about it already
Regards
Manish Behl
RBS India Development Centre (P) Ltd
T +91 124 433 6150
F +91 124 433 6500
manish.behl@rbs.com<ma...@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<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/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.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
______________________________________________________________________
RE: Issue: CLOB datatype used with iBATIS
Posted by "BEHL, Manish, IDC" <Ma...@rbs.com>.
Hi Nathan,
You were right !! The issue was with the JDBC driver. After thorough investigation, i came to know that our application had been using 2 differrent jars - classes12.jar(for Oracle 9.0.2.0) and ojdbc14.jar(for Oracle 10.2.0.1.0). Unfortunately , the sequence for the classes12.jar was before ojdb14.jar in Project's classpath.
After having removed classes12.jar from classpath, my issue got resolved.
Thanks for all your support !!
Regards
Manish Behl
RBS India Development Centre (P) Ltd
T +91 124 433 6150
F +91 124 433 6500
manish.behl@rbs.com<ma...@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<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/www.rbs.com>
________________________________
From: Nathan Maves [mailto:nathan.maves@gmail.com]
Sent: 05 January 2008 03:44
To: user-java@ibatis.apache.org
Subject: Re: Issue: CLOB datatype used with iBATIS
Generally this is most often a driver issue. Unsure that you are infact using the correct jar file for 10g.
Nathan
On Jan 4, 2008 5:46 AM, BEHL, Manish, IDC < Manish.BEHL@rbs.com<ma...@rbs.com>> wrote:
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<http://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<ma...@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.com<http://www.rbs.com>
www.rbs.com/gbm<http://www.rbs.com/gbm>
www.rbsgc.com<http://www.rbsgc.com>
***********************************************************************************
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
Re: Issue: CLOB datatype used with iBATIS
Posted by Nathan Maves <na...@gmail.com>.
Generally this is most often a driver issue. Unsure that you are infact
using the correct jar file for 10g.
Nathan
On Jan 4, 2008 5:46 AM, BEHL, Manish, IDC <Ma...@rbs.com> wrote:
> 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
> ______________________________________________________________________
>
RE: Issue: CLOB datatype used with iBATIS
Posted by Yuvraj Shinde <Yu...@sos.sungard.com>.
Update you resultmap with following line this will solve your problem.
<result column="PAYLOAD" property="strPayload" jdbcType="CLOB"
typeHandler="com.ibatis.sqlmap.engine.type.ClobTypeHandlerCallback"/>
________________________________
From: BEHL, Manish, IDC [mailto:Manish.BEHL@rbs.com]
Sent: Friday, January 04, 2008 6:36 PM
To: user-java@ibatis.apache.org
Subject: RE: Issue: CLOB datatype used with iBATIS
Hi Yuvraj,
Thanks for your response. kindly see the line in bold below. Can u let
me know the of precise syntax for the setting that needs to be done here
?
<resultMap id="outMsgMap"
class="com.rbs.rbsgbl.loaniq.cashflows.datastore.data.OutboundMessage">
<result column="MESSAGE_ID" property="lgMessage_id" jdbcType="NUMBER"/>
<result column="PAYLOAD" property="strPayload" jdbcType="CLOB" />
<result column="MESSAGE_TYPE" property="strMessage_type"
jdbcType="VARCHAR"/>
<result column="MESSAGE_VERSION" property="intMessage_version"
jdbcType="NUMBER"/>
<result column="MESSAGE_STATUS" property="chMessage_status"
jdbcType="CHAR"/>
<result column="ARGON_ID" property="strArgonId" jdbcType="VARCHAR"/>
<result column="CREATE_TIME" property="tstmpCreate_time"
jdbcType="TIMESTAMP"/>
</resultMap>
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
<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/www.rbs.c
om>
________________________________
From: Yuvraj Shinde [mailto:Yuvraj.Shinde@sos.sungard.com]
Sent: 04 January 2008 18:24
To: user-java@ibatis.apache.org
Subject: RE: Issue: CLOB datatype used with iBATIS
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
<bl...@sos.sungard.com> * www.sungard.com
<blocked::http://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+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
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
<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/www.rbs.c
om>
************************************************************************
***********
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
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
RE: Issue: CLOB datatype used with iBATIS
Posted by "BEHL, Manish, IDC" <Ma...@rbs.com>.
Hi Yuvraj,
Thanks for your response. kindly see the line in bold below. Can u let me know the of precise syntax for the setting that needs to be done here ?
<resultMap id="outMsgMap" class="com.rbs.rbsgbl.loaniq.cashflows.datastore.data.OutboundMessage">
<result column="MESSAGE_ID" property="lgMessage_id" jdbcType="NUMBER"/>
<result column="PAYLOAD" property="strPayload" jdbcType="CLOB" />
<result column="MESSAGE_TYPE" property="strMessage_type" jdbcType="VARCHAR"/>
<result column="MESSAGE_VERSION" property="intMessage_version" jdbcType="NUMBER"/>
<result column="MESSAGE_STATUS" property="chMessage_status" jdbcType="CHAR"/>
<result column="ARGON_ID" property="strArgonId" jdbcType="VARCHAR"/>
<result column="CREATE_TIME" property="tstmpCreate_time" jdbcType="TIMESTAMP"/>
</resultMap>
Regards
Manish Behl
RBS India Development Centre (P) Ltd
T +91 124 433 6150
F +91 124 433 6500
manish.behl@rbs.com<ma...@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<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/www.rbs.com>
________________________________
From: Yuvraj Shinde [mailto:Yuvraj.Shinde@sos.sungard.com]
Sent: 04 January 2008 18:24
To: user-java@ibatis.apache.org
Subject: RE: Issue: CLOB datatype used with iBATIS
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<bl...@sos.sungard.com> * www.sungard.com<blocked::http://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<ma...@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<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/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.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
______________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
RE: Issue: CLOB datatype used with iBATIS
Posted by Yuvraj Shinde <Yu...@sos.sungard.com>.
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
<bl...@sos.sungard.com> * www.sungard.com
<blocked::http://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+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
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
<outbind://180/WILLIAC/Application%20Data/Microsoft/Signatures/www.rbs.c
om>
************************************************************************
***********
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
______________________________________________________________________
Re: Issue: CLOB datatype used with iBATIS
Posted by Chema <de...@gmail.com>.
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 <Ma...@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
> ______________________________________________________________________
>