ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bala r" <bala...@gmail.com>
Subject Re: Help needed for Handling Oracle XMLType in Ibatis
Date Wed, 20 Aug 2008 18:42:16 GMT
Jeff,
I think the solution is for SELECT not for Insert/Update..
I am having issue when i execute insert/update statement inside the
Procedure..

Thanks
Bala.



On Wed, Aug 20, 2008 at 12:12 PM, Jeff Butler <jeffgbutler@gmail.com> wrote:

> Wow - impatient!
>
> A simple google query lead me to this:
>
> https://issues.apache.org/jira/browse/IBATIS-397
>
> There is a known issue with iBATIS when using procedures and type handlers
> together with Oracle.  There is a suggested workaround in this bug report
> that requires a simple modification to iBATIS code, and to the type handler.
>
> Jeff Butler
>
> On Wed, Aug 20, 2008 at 10:28 AM, bala r <balar4u@gmail.com> wrote:
>
>> Hi All,
>> Any solution or suggestions for this XMLType issue? I will have to solve
>> this issue by end of today.
>> Any helps would be very highly appreciated.
>>
>> Thanks
>> Bala.
>>
>>
>> ---------- Forwarded message ----------
>> From: bala r <balar4u@gmail.com>
>> Date: Wed, Aug 20, 2008 at 10:06 AM
>> Subject: Help needed for Handling Oracle XMLType in Ibatis
>> To: user-java@ibatis.apache.org
>>
>>
>> Hi,
>>
>> I have to insert/update XMLtype datatype using Ibatis, My insert/update
>> statement are in storedprocedure
>>
>> 1. I added the following entry in the sqlMapConfig file
>> <typeHandler javaType="org.w3c.dom.Document"
>> callBack="XMLTypeHandlerCallBack"/>
>>
>> 2.My SQLmap Resource
>>
>> <parameterMap id="product_map" class="java.util.HashMap" >
>>        <parameter         property="item_type_id"
>> jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
>>         <parameter         property="item_id"
>> jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
>>         <parameter         property="web_display_name"
>> jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
>>         <parameter         property="url"
>> jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
>>         <parameter         property="uri"
>> jdbcType="VARCHAR2"    javaType="java.lang.String" mode="IN"/>
>>         <parameter         property="xml_content" jdbcType="XMLTYPE"
>> javaType="org.w3c.dom.Document" mode="IN/>
>> </parameter>
>> <procedure id="product" parameterMap="product_map">
>>         {call product.load (?,?,?,?,?,?)}
>>     </procedure>
>>
>> 3. Stored Procedure paramers are as
>>                   Procedure load(
>>                                   item_type_id IN VARCHAR2,
>>                                   item_id IN VARCHAR2,
>>                                   web_display_name IN VARCHAR2,
>>                                    url IN VARCHAR2,
>>                                    uri IN VARCHAR2,
>>                                    xml_content IN XMLTYPE);
>>
>> Getting the following exception..
>> org.springframework.jdbc. UncategorizedSQLException: SqlMapClient
>> operation; uncategorized SQLException for SQL []; SQL state [null]; error
>> code [0];
>> --- The error occurred in product_mapper.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the product_mapper.product_overview_map.
>> --- Check the parameter mapping for the 'xml_content' property.
>> --- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
>> supported for Oracle RDBMS; nested exception is
>> com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in product_mapper.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the product_mapper.product_overview_map.
>> --- Check the parameter mapping for the 'xml_content' property.
>> --- Cause: java.lang.UnsupportedOperationException: XMLType mapping only
>> supported for Oracle RDBMS
>> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
>>
>> If i move my insert statment to sqlMap  file instead of storedprocedure
>> call then XMLType works..
>> Struggling to solve this issue since from yesterday morning but keep
>> getting the same error.
>>
>> Thanks in Advance.
>>
>> Thanks
>> bala.
>>
>>
>>
>>
>>
>>
>

Mime
View raw message