Thanks Jeff. I will try this solution. Thanks Bala.
On Wed, Aug 20, 2008 at 12:12 PM, Jeff Butler <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >> 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. >> >> >> >> >> >> >
