Mmm, oh yes ... I copied them from another email, and did not see that typo. Let me try that change, and I'll let u know. Thanks!
Regards, me. 2006/3/20, Larry Meadors <[EMAIL PROTECTED]>: > Not 100% sure, but you have this: > > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" " > http://ibatis.apache.org/dtd/sql-map-2.dtd";> > > You should have this instead: > > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" " > http://ibatis.apache.org/dtd/sql-map-2.dtd";> > > Larry > > > > On 3/20/06, Dario Bahena Tapia <[EMAIL PROTECTED]> wrote: > > 2006/3/20, Dario Bahena Tapia < [EMAIL PROTECTED]>: > > > Hi, > > > > > > I'm using spring + iBatis, but having an issue when parsing sql-map > > > file. Here's the message in the logs: > > > > > > > > > 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: Element type "select" must be declared. > > > Caused by: org.xml.sax.SAXParseException: Element type "select" must > > > be declared. > > > > > > > > > I have one of this messages for each select element in my file: > > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" > > > " http://ibatis.apache.org/dtd/sql-map-2.dtd";> > > > > > > <!-- For testing purposes put all the warnings in true and all the --> > > > <!-- errors in false (where true means nonzero counter, and false --> > > > <!-- means zero counter). --> > > > > > > <sqlMap> > > > > > > <select id="delete.Company.warning" > > > parameterClass="java.lang.String" resultClass=" java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > <select id="delete.Company.error" parameterClass=" java.lang.String" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > <select id=" delete.Location.warning" > > > parameterClass="java.lang.String" resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > <select id="delete.Location.error" parameterClass="java.lang.String" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > <select id="delete.WWEnterprise.warning" > > > parameterClass="java.lang.String" resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > <select id="delete.WWEnterprise.error" > > > parameterClass="java.lang.String " resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > <select id="merge.Company.warning" parameterClass=" java.util.Map" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > > > > <select id=" merge.Company.warning" parameterClass="java.util.Map" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > > > > <select id="merge.Location.warning" parameterClass="java.util.Map" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > > > > <select id="merge.Location.error" parameterClass="java.util.Map" > > > resultClass="java.lang.Integer "> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > > > > <select id="merge.WWEnterprise.warning" > > > parameterClass=" java.util.Map" resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 1=1 > > > </select> > > > > > > > > > <select id=" merge.WWEnterprise.error" parameterClass="java.util.Map" > > > resultClass="java.lang.Integer"> > > > select count(*) from SYSIBM.SYSDUMMY1 where 0=1 > > > </select> > > > > > > </sqlMap> > > > > > > I think I'm declaring correctly the DTD type, what could be the > > > problem? Do I need to setup the default xml parser before using > > > iBatis or something like that? > > > > > > Thanks, > > > Regads. > > > > > >
