Return-Path: 
 <user-java-return-4608-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 18075 invoked from network); 19 Oct 2005 14:30:11 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Oct 2005 14:30:11 -0000
Received: (qmail 83524 invoked by uid 500); 19 Oct 2005 14:30:09 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 83485 invoked by uid 500); 19 Oct 2005 14:30:09 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 83454 invoked by uid 99); 19 Oct 2005 14:30:09 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Oct 2005 07:30:09 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [62.241.162.31] (HELO galaxy.systems.pipex.net) (62.241.162.31)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Oct 2005 07:30:07 -0700
Received: from graticule.com (81-179-32-227.dsl.pipex.com [81.179.32.227])
	by galaxy.systems.pipex.net (Postfix) with ESMTP id 387E3E000498
	for <user-java@ibatis.apache.org>; Wed, 19 Oct 2005 15:29:45 +0100 (BST)
Received: by graticule.com (Postfix, from userid 506)
	id 086015AC002; Wed, 19 Oct 2005 15:29:44 +0100 (BST)
Received: from [127.0.0.1] (unknown [192.168.1.14])
	by graticule.com (Postfix) with ESMTP id F11EE5AC001
	for <user-java@ibatis.apache.org>; Wed, 19 Oct 2005 15:29:43 +0100 (BST)
Message-ID: <43565857.3070604@graticule.com>
Date: Wed, 19 Oct 2005 15:29:43 +0100
From: David Moss <davidm@graticule.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: org.xml.sax.SAXParseException: Attribute "id" is required and
 must be specified for element type "delete".
References: <4356575B.5030300@graticule.com>
In-Reply-To: <4356575B.5030300@graticule.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Sorry, I've found it.  Hadn't closed a tag correctly.  What a stupid 
mistake, and I'd spent ages looking for it too.

David Moss wrote:

> I'm getting this exception when trying to start my web app in Tomcat5.
>
> my sql-map-config.xml file contains:
>
>    <?xml version="1.0" encoding="UTF-8"?>
>    <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config
>    2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
>    <sqlMapConfig>
>        <sqlMap 
> resource="com/graticule/ecorisk/db/ibatis/maps/User.xml" />
>        <sqlMap resource="com/graticule/ecorisk/db/ibatis/maps/Map.xml" />
>        <!--<sqlMap
>    resource="com/graticule/ecorisk/db/ibatis/maps/Layer.xml" />-->
>    </sqlMapConfig>
>
>
>
> and Map.xml contains...
>
>
>
>    <?xml version="1.0" encoding="UTF-8"?>
>    <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
>    "http://www.ibatis.com/dtd/sql-map-2.dtd">
>
>    <sqlMap namespace="Map">
>
>        <resultMap id="result" class="com.graticule.ecorisk.bus.Map">
>            <result property="id" column="id" columnIndex="1" />
>            <result property="name" column="name" columnIndex="2" />
>            <result property="description" column="description"
>    columnIndex="3" />
>            <result property="owner" column="owner" columnIndex="4" />
>        </resultMap>
>              <delete id="removeMap">
>            delete from maps where id = #id#
>        <delete>
>              <insert id="addMap">
>            insert into maps (name, description, owner) values (#name#,
>    #description#, #owner#)
>        </insert>
>              <select id="getMapById" resultMap="result">
>            select * from maps where id = #id#
>        </select>
>              <select id="getMapList" resultMap="result">
>            select * from users
>        </select>
>              <update id="updateMap">
>            update maps set
>                name = #name#
>                description = #description#
>                owner = #owner#
>              where id = #id#
>        </update>
>          </sqlMap>
>
> If I comment out the Map sql resource file then the problems 
> dissappear, so I guess that there's something wrong with Map.xml but I 
> can't see what it is.  Could anyone help me?
>
> David Moss.
>

-- 
**********************************************************************
* The information in this message is confidential and is for         *
* the addressee(s) only.  If you have received this message in error,*
* please notify the sender. Unauthorised use,disclosure,duplication  *
* or alteration of this message are forbidden. This message and any  *
* attachments have been scanned for viruses. Graticule will not be   *
* liable for direct, indirect or consequential damages arising from  *
* altering the contents of this message by a third party or as a     *
* result of any virus being passed on.                               *
* ------------------------------------------------------------------ *
* Unless stated otherwise - prices quoted in this e-mail are in      *
*  British Pounds Sterling and exclude media charges, package and    *
*  postage and Value Added Tax (VAT), where applicable. Prices are   *
*  valid for a period of 30 days from the date of this e-mail. Annual*
*  renewal fees are subject to change without notice. Transactions   *
*  are subject to our Terms of Business:                             *
*  (http://www.graticule.com/company/terms.pdf).                     *
**********************************************************************