ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liny <innocentl...@gmail.com>
Subject Need help in SqlMap.xml
Date Tue, 08 Jul 2008 10:01:11 GMT

Hi, below is the content of my SqlMap.xml
<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap      
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="acm.wafer">
  
  <cacheModel id="productCache" type="LRU" readOnly="true"
serialize="false">
    <flushInterval hours="24"/>
    <property name="size" value="1000" />
  </cacheModel>
  
  <!-- Use type aliases to avoid typing the full classname every time. -->
  <typeAlias alias="waferData" type="acm.wafer.model.WaferData"/>
  <typeAlias alias="invoiceWaferQuery"
type="acm.wafer.model.InvoiceWaferQuery"/>
  
  <!-- Result maps describe the mapping between the columns returned
       from a query, and the class properties.  A result map isn't
       necessary if the columns (or aliases) match to the properties 
       exactly. -->
  <resultMap id="invoiceWaferMap" class="acm.wafer.model.InvoiceWafer">
    <result property="extDelivery" column="EXT_DELIVERY"/>
    <result property="material" column="MATERIAL"/>
    <result property="invoiceBatchNo" column="BATCH"/>
    <result property="deliveryQty" column="DELIVERY_QTY"/>    
    <result property="batchNo" column="BATCH_NO"/>
    <result property="qty" column="qty"/>
    <result property="dieName" column="DIE_NAME"/>
    <result property="receiveDttm" column="RECEIVE_DATE"/> 
    <result property="boxes" column="boxes"/> 
  </resultMap>
  
  <insert id="insertWaferData" parameterClass="waferData" >
    insert into acm_wafer_data
    values(#batchNo#, #dieName#, #qty#, #receiveDttm#, #boxes#)
  </insert>
  
  <select id="getInvoiceWaferData" parameterClass="invoiceWaferQuery"
resultMap="invoiceWaferMap">
    select EXT_DELIVERY, MATERIAL, BATCH, DELIVERY_QTY, BATCH_NO, 
           sum(DIE_QTY) qty, DIE_NAME, RECEIVE_DATE, 
           sum(BOX_COUNT) boxes
    from
    (
      select * from acm_wafer_invoice sap,acm_wafer_data info
      where sap.batch = info.batch_no(+)
        and sap.material = info.die_name(+)
        <isParameterPresent>
          <isNotNull prepend="and" property="batchNo">
            info.batch_no = #batchNo#
          </isNotNull> 
          <isNotNull prepend="and" property="dieName">
            info.die_name = #dieName#
          </isNotNull>    
          <isNotNull prepend="and" property="fromDate">
            info.receive_dttm >= #fromDate#
          </isNotNull>
        </isParameterPresent>
      union
      select * from acm_wafer_invoice sap,acm_wafer_data info
      where sap.batch(+) = info.batch_no
        and sap.material(+) = info.die_name
        <isParameterPresent>
          <isNotNull prepend="and" property="batchNo">
            info.batch_no = #batchNo#
          </isNotNull> 
          <isNotNull prepend="and" property="dieName">
            info.die_name = #dieName#
          </isNotNull> 
          <isNotNull prepend="and" property="toDate">
            info.receive_dttm <= #toDate#
          </isNotNull>
        </isParameterPresent>
    )
    group by EXT_DELIVERY, MATERIAL, BATCH, DELIVERY_QTY, BATCH_NO, 
             DIE_NAME, RECEIVE_DATE, GROUP_ID

  </select>
</sqlMap>

And iBatis throws exception while loading xml file.
org.xml.sax.SAXParseException: The content of elements must consist of
well-formed character data or markup.     at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)     at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown
Source)     at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
Source)     at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
Source)     at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown
Source)     at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown
Source)     at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)     at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)     at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)    
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)     at
org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)     at
com.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java:157)    
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:50)     at
com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse(SqlMapParser.java:51)    
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:410)
   
at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)    
at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)     at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)     at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)     at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)     at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:86)
   
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)

What's wrong with it?
Thanks for any suggestion!
-- 
View this message in context: http://www.nabble.com/Need-help-in-SqlMap.xml-tp18335771p18335771.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message