iBatis

[Patricia Samuel]

Hi All,

I am new in using iBatis.
I am facing this problem while deploying my application -


Caused by: com.ibatis.common.exception.NestedRuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: com.ibatis.common.exception.NestedRuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
Caused by: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.

    
<?xml version="1.0" encoding="UTF-8" ?>
 
<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
 
<sqlMapConfig>
<settings enhancementEnabled="true" useStatementNamespaces="true"/>
  <!-- Configure a built-in transaction manager.  If you're using an 
       app server, you probably want to use its transaction manager 
       and a managed datasource -->
  <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="url"/>
      <property name="JDBC.Username" value="sa"/>
      <property name="JDBC.Password" value="sa"/>
    </dataSource>
  </transactionManager>
 
  <!-- List the SQL Map XML files. They can be loaded from the 
       classpath, as they are here (com.domain.data...) -->
  <sqlMap resource="Query.xml"/>
  <!-- List more here...
  <sqlMap resource="com/mydomain/data/Order.xml"/>
  <sqlMap resource="com/mydomain/data/Documents.xml"/>
  -->
 
</sqlMapConfig>
------------------------------------------------------------------------
Query.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="qt">
 
<typeAlias alias="qt" type="Quote" />
 
<select id="getData" resultClass="qt">
SELECT ID FROM TestTable Q WHERE
Q.DATE >=TO_DATE('04/024/2008 00:00:00','mm/dd/yyyy hh24:mi:ss') 
AND Q.DATE <=TO_DATE('04/24/2008 23:4:39','mm/dd/yyyy hh24:mi:ss')
    AND Q.NAME_ID=11534 

 
</select>
</sqlMap>
 

Please help.

Thanks

[Gregg Bolinger]

Where does Query.xml exist? What package structure?