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: [email protected] > > > 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. > > > > > >
