Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 99792 invoked from network); 17 Mar 2005 17:57:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 17 Mar 2005 17:57:12 -0000 Received: (qmail 3730 invoked by uid 500); 17 Mar 2005 17:57:11 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 3710 invoked by uid 500); 17 Mar 2005 17:57:11 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 3697 invoked by uid 99); 17 Mar 2005 17:57:11 -0000 X-ASF-Spam-Status: No, hits=2.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,FORGED_YAHOO_RCVD X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from web30504.mail.mud.yahoo.com (HELO web30504.mail.mud.yahoo.com) (68.142.200.117) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 17 Mar 2005 09:57:10 -0800 Received: (qmail 9634 invoked by uid 60001); 17 Mar 2005 17:57:08 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=gMA3cSXtaQ0k2VdnrhCfqSqvHhTVhjnkNmuZkYnkZNzbzUeEUuq4NOPgPr0HtqJsP3y+LKVqrrEb4zHkvOypZwXP5mga0tfjKY/wqRS7NJJUDp58+ZHI9BhhSVuTFY5gPgAlXmZbvAOKqg6YlNZfZ/e41EGEB2zbgZN7Z81Ey6c= ; Message-ID: <20050317175708.9632.qmail@web30504.mail.mud.yahoo.com> Received: from [219.65.252.131] by web30504.mail.mud.yahoo.com via HTTP; Thu, 17 Mar 2005 09:57:08 PST Date: Thu, 17 Mar 2005 09:57:08 -0800 (PST) From: Swati Singhal Subject: Sorry To: ibatis-user-java@incubator.apache.org In-Reply-To: <20050317174959.7077.qmail@web30504.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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 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 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 > > 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: > > > > > > > > > INSERT INTO ORDER (processed_ind, > insr_dt, > > > processed_dt, order_det) > > > VALUES (#sProcessedInd#, #createdDate#, > > > #processedDate#, #sRow#) > > > > > > > > > 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 INTO ORDER (processed_ind, > insr_dt, > > > processed_dt, order_det) > > > VALUES (#sProcessedInd#, #createdDate#, > > > #processedDate#, #sRow#) > > > > > > > > > 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 > 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 > > > > 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