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 Swati Singhal <sw...@yahoo.com> on 2005/03/17 18:49:59 UTC
Re:
Yes, I found the problem and pointed to the right DTD
but still get the error saying
"There is no statement named insertRow in this SqlMap"
Wen can we get this sort of an error?
I know maybe it's a silly mistake on my end, but am
really lost on it..
Hope to get some help.
Thanks
--- Clinton Begin <cl...@gmail.com> wrote:
> now it looks like your DTD is missing or incorrect
> (make sure you're
> using the right DTD for the right kind of file).
>
> Clinton
>
>
> On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati
> Singhal
> <sw...@yahoo.com> wrote:
> > Hello,
> >
> > Well, I did solve this problem by copying all the
> DTDs
> > from the web.
> > I am able to get the instance of DAO through the
> > DAOManager.
> >
> > But what is weird is, that in my file which
> contains
> > the queries, if I have something like:
> >
> > <mapped-statement name="insertRow">
> > INSERT INTO ORDER (processed_ind, insr_dt,
> > processed_dt, order_det)
> > VALUES (#sProcessedInd#, #createdDate#,
> > #processedDate#, #sRow#)
> > </mapped-statement>
> >
> > However, this throws an error:
> >
> > I am in InsertDAO and error is:There is no
> statement
> > named insertRow in this SqlMap.
> >
> > Whereas if I have the query as
> >
> > <insert id="insertRow" parameter="Row">
> > INSERT INTO ORDER (processed_ind, insr_dt,
> > processed_dt, order_det)
> > VALUES (#sProcessedInd#, #createdDate#,
> > #processedDate#, #sRow#)
> > </insert>
> >
> > I get an error :
> > Error in
> >
>
DAOConfig:com.ibatis.common.exception.NestedRuntimeException:
> > Error occurred. 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 "insert" must be declared.
> > Caused by: org.xml.sax.SAXParseException: Element
> type
> > "insert" must be declared.
> > Caused by: com.ibatis.common.xml.NodeletException:
> > Error parsing XML. Cause:
> > org.xml.sax.SAXParseException: Element type
> "insert"
> > must be declared.
> > Caused by: org.xml.sax.SAXParseException: Element
> type
> > "insert" must be declared.
> >
> > --- Clinton Begin <cl...@gmail.com> wrote:
> > > It looks like your XML parser is trying to
> validate
> > > the DTD using the
> > > server (www.ibatis.com/dtd). There may be
> firewall
> > > issues in your
> > > environment that prevent this from working.
> > >
> > > iBATIS is configured to validate from the JAR
> file,
> > > but some parsers
> > > (I wish I knew which ones) don't seem to support
> > > EntityResolvers.
> > >
> > > So the solution for you might be to download the
> > > DTDs with your
> > > browser (or just grab them from the JAR), and
> then
> > > use a
> > > "file:///usr/local/ibatis/dtd" path or something
> > > like that.
> > >
> > > Cheers,
> > > Clinton
> > >
> > >
> > > On Wed, 16 Mar 2005 02:57:38 -0800 (PST), Swati
> > > Singhal
> > > <sw...@yahoo.com> wrote:
> > > > Hi,
> > > >
> > > > I was able to fix that.
> > > > But now I am getting this error:
> > > >
> > > > Error in DAOConfig:Error while configuring
> > > > DaoManager. Cause:
> > > >
> > >
> 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: java.net.ConnectException:
> Connection
> > > > timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> com.ibatis.common.xml.NodeletException:
> > > > Error parsing XML. Cause:
> > > java.net.ConnectException:
> > > > Connection timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> > > >
> > >
> com.ibatis.common.exception.NestedRuntimeException:
> > > > Error parsing XPath '/sqlMapConfig/sqlMap'.
> > > Cause:
> > > > com.ibatis.common.xml.NodeletException: Error
> > > parsing
> > > > XML. Cause: java.net.ConnectException:
> Connection
> > > > timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> com.ibatis.common.xml.NodeletException:
> > > > Error parsing XML. Cause:
> > > java.net.ConnectException:
> > > > Connection timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> 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: java.net.ConnectException:
> Connection
> > > > timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> com.ibatis.common.xml.NodeletException:
> > > > Error parsing XML. Cause:
> > > java.net.ConnectException:
> > > > Connection timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
> > > > out: connect
> > > > Caused by:
> > > >
> > >
> com.ibatis.common.exception.NestedRuntimeException:
> > > > Error parsing XPath '/sqlMapConfig/sqlMap'.
> > > Cause:
> > > > com.ibatis.common.xml.NodeletException: Error
> > > parsing
> > > > XML. Cause: java.net.ConnectException:
> Connection
> > > > timed out: connect
> > > > Caused by: java.net.ConnectException:
> Connection
> > > timed
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sorry
Posted by Swati Singhal <sw...@yahoo.com>.
Sorry for flooding everyone's mailbox with 6 mails,
got a page not found error on submitting the email and
so did it so many times without realizing that it
actually did get posted.
--- Swati Singhal <sw...@yahoo.com> wrote:
> Yes, I found the problem and pointed to the right
> DTD
> but still get the error saying
>
> "There is no statement named insertRow in this
> SqlMap"
>
> Wen can we get this sort of an error?
> I know maybe it's a silly mistake on my end, but am
> really lost on it..
> Hope to get some help.
>
> Thanks
> --- Clinton Begin <cl...@gmail.com> wrote:
>
> > now it looks like your DTD is missing or incorrect
> > (make sure you're
> > using the right DTD for the right kind of file).
> >
> > Clinton
> >
> >
> > On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati
> > Singhal
> > <sw...@yahoo.com> wrote:
> > > Hello,
> > >
> > > Well, I did solve this problem by copying all
> the
> > DTDs
> > > from the web.
> > > I am able to get the instance of DAO through the
> > > DAOManager.
> > >
> > > But what is weird is, that in my file which
> > contains
> > > the queries, if I have something like:
> > >
> > > <mapped-statement name="insertRow">
> > > INSERT INTO ORDER (processed_ind,
> insr_dt,
> > > processed_dt, order_det)
> > > VALUES (#sProcessedInd#, #createdDate#,
> > > #processedDate#, #sRow#)
> > > </mapped-statement>
> > >
> > > However, this throws an error:
> > >
> > > I am in InsertDAO and error is:There is no
> > statement
> > > named insertRow in this SqlMap.
> > >
> > > Whereas if I have the query as
> > >
> > > <insert id="insertRow" parameter="Row">
> > > INSERT INTO ORDER (processed_ind,
> insr_dt,
> > > processed_dt, order_det)
> > > VALUES (#sProcessedInd#, #createdDate#,
> > > #processedDate#, #sRow#)
> > > </insert>
> > >
> > > I get an error :
> > > Error in
> > >
> >
>
DAOConfig:com.ibatis.common.exception.NestedRuntimeException:
> > > Error occurred. 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 "insert" must be declared.
> > > Caused by: org.xml.sax.SAXParseException:
> Element
> > type
> > > "insert" must be declared.
> > > Caused by:
> com.ibatis.common.xml.NodeletException:
> > > Error parsing XML. Cause:
> > > org.xml.sax.SAXParseException: Element type
> > "insert"
> > > must be declared.
> > > Caused by: org.xml.sax.SAXParseException:
> Element
> > type
> > > "insert" must be declared.
> > >
> > > --- Clinton Begin <cl...@gmail.com>
> wrote:
> > > > It looks like your XML parser is trying to
> > validate
> > > > the DTD using the
> > > > server (www.ibatis.com/dtd). There may be
> > firewall
> > > > issues in your
> > > > environment that prevent this from working.
> > > >
> > > > iBATIS is configured to validate from the JAR
> > file,
> > > > but some parsers
> > > > (I wish I knew which ones) don't seem to
> support
> > > > EntityResolvers.
> > > >
> > > > So the solution for you might be to download
> the
> > > > DTDs with your
> > > > browser (or just grab them from the JAR), and
> > then
> > > > use a
> > > > "file:///usr/local/ibatis/dtd" path or
> something
> > > > like that.
> > > >
> > > > Cheers,
> > > > Clinton
> > > >
> > > >
> > > > On Wed, 16 Mar 2005 02:57:38 -0800 (PST),
> Swati
> > > > Singhal
> > > > <sw...@yahoo.com> wrote:
> > > > > Hi,
> > > > >
> > > > > I was able to fix that.
> > > > > But now I am getting this error:
> > > > >
> > > > > Error in DAOConfig:Error while configuring
> > > > > DaoManager. Cause:
> > > > >
> > > >
> >
> 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: java.net.ConnectException:
> > Connection
> > > > > timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > java.net.ConnectException:
> > > > > Connection timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > > > >
> > > >
> >
> com.ibatis.common.exception.NestedRuntimeException:
> > > > > Error parsing XPath '/sqlMapConfig/sqlMap'.
> > > > Cause:
> > > > > com.ibatis.common.xml.NodeletException:
> Error
> > > > parsing
> > > > > XML. Cause: java.net.ConnectException:
> > Connection
> > > > > timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > java.net.ConnectException:
> > > > > Connection timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > >
> > > >
> >
> com.ibatis.common.exception.NestedRuntimeException:
>
=== message truncated ===
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
Sorry
Posted by Swati Singhal <sw...@yahoo.com>.
Sorry for flooding everyone's mailbox with 6 mails,
got a page not found error on submitting the email and
so did it so many times without realizing that it
actually did get posted.
--- Swati Singhal <sw...@yahoo.com> wrote:
> Yes, I found the problem and pointed to the right
> DTD
> but still get the error saying
>
> "There is no statement named insertRow in this
> SqlMap"
>
> Wen can we get this sort of an error?
> I know maybe it's a silly mistake on my end, but am
> really lost on it..
> Hope to get some help.
>
> Thanks
> --- Clinton Begin <cl...@gmail.com> wrote:
>
> > now it looks like your DTD is missing or incorrect
> > (make sure you're
> > using the right DTD for the right kind of file).
> >
> > Clinton
> >
> >
> > On Thu, 17 Mar 2005 04:43:11 -0800 (PST), Swati
> > Singhal
> > <sw...@yahoo.com> wrote:
> > > Hello,
> > >
> > > Well, I did solve this problem by copying all
> the
> > DTDs
> > > from the web.
> > > I am able to get the instance of DAO through the
> > > DAOManager.
> > >
> > > But what is weird is, that in my file which
> > contains
> > > the queries, if I have something like:
> > >
> > > <mapped-statement name="insertRow">
> > > INSERT INTO ORDER (processed_ind,
> insr_dt,
> > > processed_dt, order_det)
> > > VALUES (#sProcessedInd#, #createdDate#,
> > > #processedDate#, #sRow#)
> > > </mapped-statement>
> > >
> > > However, this throws an error:
> > >
> > > I am in InsertDAO and error is:There is no
> > statement
> > > named insertRow in this SqlMap.
> > >
> > > Whereas if I have the query as
> > >
> > > <insert id="insertRow" parameter="Row">
> > > INSERT INTO ORDER (processed_ind,
> insr_dt,
> > > processed_dt, order_det)
> > > VALUES (#sProcessedInd#, #createdDate#,
> > > #processedDate#, #sRow#)
> > > </insert>
> > >
> > > I get an error :
> > > Error in
> > >
> >
>
DAOConfig:com.ibatis.common.exception.NestedRuntimeException:
> > > Error occurred. 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 "insert" must be declared.
> > > Caused by: org.xml.sax.SAXParseException:
> Element
> > type
> > > "insert" must be declared.
> > > Caused by:
> com.ibatis.common.xml.NodeletException:
> > > Error parsing XML. Cause:
> > > org.xml.sax.SAXParseException: Element type
> > "insert"
> > > must be declared.
> > > Caused by: org.xml.sax.SAXParseException:
> Element
> > type
> > > "insert" must be declared.
> > >
> > > --- Clinton Begin <cl...@gmail.com>
> wrote:
> > > > It looks like your XML parser is trying to
> > validate
> > > > the DTD using the
> > > > server (www.ibatis.com/dtd). There may be
> > firewall
> > > > issues in your
> > > > environment that prevent this from working.
> > > >
> > > > iBATIS is configured to validate from the JAR
> > file,
> > > > but some parsers
> > > > (I wish I knew which ones) don't seem to
> support
> > > > EntityResolvers.
> > > >
> > > > So the solution for you might be to download
> the
> > > > DTDs with your
> > > > browser (or just grab them from the JAR), and
> > then
> > > > use a
> > > > "file:///usr/local/ibatis/dtd" path or
> something
> > > > like that.
> > > >
> > > > Cheers,
> > > > Clinton
> > > >
> > > >
> > > > On Wed, 16 Mar 2005 02:57:38 -0800 (PST),
> Swati
> > > > Singhal
> > > > <sw...@yahoo.com> wrote:
> > > > > Hi,
> > > > >
> > > > > I was able to fix that.
> > > > > But now I am getting this error:
> > > > >
> > > > > Error in DAOConfig:Error while configuring
> > > > > DaoManager. Cause:
> > > > >
> > > >
> >
> 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: java.net.ConnectException:
> > Connection
> > > > > timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > java.net.ConnectException:
> > > > > Connection timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > > > >
> > > >
> >
> com.ibatis.common.exception.NestedRuntimeException:
> > > > > Error parsing XPath '/sqlMapConfig/sqlMap'.
> > > > Cause:
> > > > > com.ibatis.common.xml.NodeletException:
> Error
> > > > parsing
> > > > > XML. Cause: java.net.ConnectException:
> > Connection
> > > > > timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > java.net.ConnectException:
> > > > > Connection timed out: connect
> > > > > Caused by: java.net.ConnectException:
> > Connection
> > > > timed
> > > > > out: connect
> > > > > Caused by:
> > com.ibatis.common.xml.NodeletException:
> > > > > Error parsing XML. Cause:
> > > > >
> > > >
> >
> com.ibatis.common.exception.NestedRuntimeException:
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com