Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 95746 invoked from network); 21 Mar 2007 18:27:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2007 18:27:15 -0000 Received: (qmail 77716 invoked by uid 500); 21 Mar 2007 18:27:19 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 77602 invoked by uid 500); 21 Mar 2007 18:27:19 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 77585 invoked by uid 99); 21 Mar 2007 18:27:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 11:27:19 -0700 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_10_20,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of mail.micke@gmail.com designates 64.233.182.186 as permitted sender) Received: from [64.233.182.186] (HELO nf-out-0910.google.com) (64.233.182.186) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Mar 2007 11:27:10 -0700 Received: by nf-out-0910.google.com with SMTP id q29so424593nfc for ; Wed, 21 Mar 2007 11:26:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=QHA16uU2/Rb8WnJNfGpsGO2G092OerrUPnJ/FcYU4OpX+nJTTweqs70BiJRHf3a9o1P4EJcRjdCoIVOQH3MC/o8SI9BC4XM1B3RNLo3Y6+EwXlrL4Z/QLETiK/feKFEuHhRWZ7P/2rb1FmAxFUzmlug8gQZHLBG+WcyHBYj6uRM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=FiJ2QnBd23Mukd6I8up9mFnr2qyCHOla3u0ViKhKMAEQD3p7fONHIMKjcVcrP3IR2lTySWo2x9iAO5/cTbPzZC6sK4Jo6EnuqkCwSgVw1oFfsRFVLoQua8MIemgCWZNqjHweC6OqlhnUln0JkiN0etQEx60CW3QXvg7QuSTvrCs= Received: by 10.82.178.11 with SMTP id a11mr2217653buf.1174501608464; Wed, 21 Mar 2007 11:26:48 -0700 (PDT) Received: by 10.82.183.15 with HTTP; Wed, 21 Mar 2007 11:26:48 -0700 (PDT) Message-ID: <8eed5c5b0703211126v5d65d050sb5b3c434bc169883@mail.gmail.com> Date: Wed, 21 Mar 2007 18:26:48 +0000 From: "Mikael Andersson" To: user-java@ibatis.apache.org Subject: Usage of namespace and select ids MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_90792_23933837.1174501608430" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_90792_23933837.1174501608430 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I have yet another beginner question. Can I have the same select id in multiple sqlMap XML files? Currently I have two sqlMap XML files, which are specifying namespace (generated by Abator, with custom stuff added to them), with the same select id in both files. When invoking a query in the DAO I use the NAMESPACE.ID notation. I get this error: There is already a statement named selectAll in this SqlMap org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in class path resource [ spring-referencedata-test.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'. Cause: com.ibatis.sqlmap.client.SqlMapException: There is already a statement named selectAll in this SqlMap. java.lang.RuntimeException: Error occurred. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'. Cause: com.ibatis.sqlmap.client.SqlMapException: There is already a statement named selectAll in this SqlMap. at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse( SqlMapConfigParser.java:89) at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient( SqlMapClientBuilder.java:63) at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet( SqlMapClientFactoryBean.java:258) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods (AbstractAutowireCapableBeanFactory.java:1091) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:396) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:233) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:145) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons (DefaultListableBeanFactory.java:277) at org.springframework.context.support.AbstractApplicationContext.refresh( AbstractApplicationContext.java:313) at org.springframework.context.support.ClassPathXmlApplicationContext .(ClassPathXmlApplicationContext.java:87) at org.springframework.context.support.ClassPathXmlApplicationContext .(ClassPathXmlApplicationContext.java:72) Cheers, Mike ------=_Part_90792_23933837.1174501608430 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,
I have yet another beginner question.

Can I have the same select id in multiple sqlMap XML files?

Currently I have two sqlMap XML files, which are specifying namespace (generated by Abator, with custom stuff added to them), with the same select id in both files.
When invoking a query in the DAO I use the NAMESPACE.ID notation.

I get this error: There is already a statement named selectAll in this SqlMap

org.springframework.beans.factory.BeanCreationException : Error creating bean with name 'sqlMapClient' defined in class path resource [spring-referencedata-test.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: There is already a statement named selectAll in this SqlMap.
java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMap/select'.  Cause: com.ibatis.sqlmap.client.SqlMapException: There is already a statement named selectAll in this SqlMap.
    at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse (SqlMapConfigParser.java:89)
    at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:63)
    at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java :258)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1091)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean (AbstractAutowireCapableBeanFactory.java:396)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean (AbstractBeanFactory.java:145)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)
    at org.springframework.context.support.AbstractApplicationContext.refresh (AbstractApplicationContext.java:313)
    at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:87)
    at org.springframework.context.support.ClassPathXmlApplicationContext .<init>(ClassPathXmlApplicationContext.java:72)

Cheers,
 Mike
------=_Part_90792_23933837.1174501608430--