Re: Undeclared types & DTD ...

[Larry Meadors]

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.
> >
>