You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Dario Bahena Tapia <da...@gmail.com> on 2006/03/20 18:08:31 UTC
Re: Undeclared types & DTD ...
2006/3/20, Dario Bahena Tapia <da...@gmail.com>:
> 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.
>
Re: Undeclared types & DTD ...
Posted by Dario Bahena Tapia <da...@gmail.com>.
Oh yes, it was that. Thanks a lot.
Regards,
Dario.
2006/3/20, Dario Bahena Tapia <da...@gmail.com>:
> 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 <lm...@apache.org>:
> > 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 <da...@gmail.com> wrote:
> > > 2006/3/20, Dario Bahena Tapia < dario.mx@gmail.com>:
> > > > 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.
> > > >
> > >
> >
>
Re: Undeclared types & DTD ...
Posted by Dario Bahena Tapia <da...@gmail.com>.
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 <lm...@apache.org>:
> 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 <da...@gmail.com> wrote:
> > 2006/3/20, Dario Bahena Tapia < dario.mx@gmail.com>:
> > > 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.
> > >
> >
>
Re: Undeclared types & DTD ...
Posted by Larry Meadors <lm...@apache.org>.
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 <da...@gmail.com> wrote:
> 2006/3/20, Dario Bahena Tapia <da...@gmail.com>:
> > 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.
> >
>