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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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 > > > > <[EMAIL PROTECTED]> 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
