XML Type error

[felix thomas <re...@yahoo.co.in>]

hi,

 I am getting the below error while inserting into
oracle table with xmltype datatype.

com.ibatis.common.jdbc.exception.NestedSQLException:  

--- The error occurred in
com/sb/dao/ibatis/maps/CustomField.xml.  
--- The error occurred while applying a parameter map.
 
--- Check the insertCustomField-InlineParameterMap.  
--- Check the parameter mapping for the 'formula'
property.  
--- Cause: java.sql.SQLException: Invalid column type

I have a column named formula with xmltype.i have
mapped it this way
 <result column="FORMULA" property="formula"
jdbcType="OTHER" />

My insert statementis as below

 <insert id="insertCustomField"
parameterClass="com.sb.model.CustomField" >
    
    insert into FIELD (FIELD_ID, NAME, OBJECT_ID,
SORT_ORDER, FIELD_SIZE, FIELD_TYPE_ID,
      FIELD_TYPE_CODE, DEFAULT_VALUE, IS_STANDARD,
IS_PRIMARY_KEY, IS_REQUIRED, IS_UNIQUE_VALUE,
      IS_UNIQUE_IGNORE_CASE, IS_EXTERNAL_ID,
IS_CHANGE_RECORDS, IS_TRACK_CHANGES, LENGTH,
      DECIMAL_PLACES, DISPLAY_FORMAT, STARTING_NUMBER,
PARENT_OBJECT_ID, LOV_TYPE_ID, IS_LOV_SORT,
      IS_LOV_DEFAULT_FIRST, FORMULA,
FORMULA_FIELD_TYPE_ID, VISIBLE_LINES,
CONTROLLING_FIELD_ID,
      PARENT_SIZE, CHILD_SIZE, LANGUAGE_ID, LABEL,
DESCRIPTION, PARENT_RELATED_LIST_LABEL,
      CREATED_BY, CREATED_ON, MODIFIED_BY,
MODIFIED_ON)
    values (SELECT record_id.NEXTVAL AS ID  FROM DUAL,
#name:VARCHAR#, '2593', '11',
      #fieldSize:DECIMAL#, #fieldTypeId:DECIMAL#,
#fieldTypeCode:DECIMAL#, #defaultValue:OTHER#,
      'Y','N','Y','N',
      'N','N','N','N',
      #length:DECIMAL#, #decimalPlaces:DECIMAL#,
#displayFormat:VARCHAR#, #startingNumber:DECIMAL#,
      #parentObjectId:DECIMAL#, #lovTypeId:DECIMAL#,
#isLovSort:CHAR#, #isLovDefaultFirst:CHAR#,
      xmltype(#formula#),
#formulaFieldTypeId:DECIMAL#, #visibleLines:DECIMAL#,
      #controllingFieldId:DECIMAL#,
#parentSize:DECIMAL#, #childSize:DECIMAL#,'6',
      #label:OTHER#, #description:OTHER#,
#parentRelatedListLabel:OTHER#, '1',
      '17-Jul-2007','1','17-Jul-2007')
  </insert>

I even tried without the xmltype() function also still
it gave me error.
I am using ibatis 2.2.3

I saw in the forumn that ibatis does not support
xmltype columns. is it true ? or is there anyway i can

handle it.

i saw the xmltypehandler code also ,but i am unable to
download the xdb.jar from any site so can't test it.


Can anyone help.

Regards,
Felix T







      Get the freedom to save as many mails as you wish. To know how, go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html