Return-Path: 
 <user-java-return-3326-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 31535 invoked from network); 17 Jul 2005 12:47:28 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 17 Jul 2005 12:47:28 -0000
Received: (qmail 86391 invoked by uid 500); 17 Jul 2005 12:47:27 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 86375 invoked by uid 500); 17 Jul 2005 12:47:26 -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 86362 invoked by uid 99); 17 Jul 2005 12:47:26 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jul 2005 05:47:26 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 64.233.162.203 as permitted sender)
Received: from [64.233.162.203] (HELO zproxy.gmail.com) (64.233.162.203)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 17 Jul 2005 05:47:23 -0700
Received: by zproxy.gmail.com with SMTP id x3so662878nze
        for <user-java@ibatis.apache.org>;
 Sun, 17 Jul 2005 05:47:25 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=sKtUMi4NlXF67yPX+S5Jfwd+pfEgLIBF4Izi0OyvmuIEeg/stKItCIeoHO0oWPvhZdsGp5KxZirXGCi76LDppvQ+bavSdX/OWnpKM9v/83O4yk5zbF57N6FQ44t7sujQTKclpl7Wv2Ielpjyd2MPoRywe0L2LNO3bwRMDyFFUfM=
Received: by 10.36.221.76 with SMTP id t76mr2683784nzg;
        Sun, 17 Jul 2005 05:47:25 -0700 (PDT)
Received: by 10.36.90.14 with HTTP; Sun, 17 Jul 2005 05:47:25 -0700 (PDT)
Message-ID: <a10a823c050717054719a92548@mail.gmail.com>
Date: Sun, 17 Jul 2005 06:47:25 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: Result as Xml, and lower/upper case
In-Reply-To: <20050715210932Z686201-22463+353@kps2.test.onet.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <16178eb105071513075125e78a@mail.gmail.com>
	 <20050715210932Z686201-22463+353@kps2.test.onet.pl>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

IMO, xml results are not that great in iBATIS.=20

My suggestion is that if you are going to try to create XML results
from a mapped statement, use a RowHandler and construct the XML in it.

It will give you WAY more flexibility, and decent performance as well.

Larry


On 7/15/05, dooverone@op.pl <dooverone@op.pl> wrote:
> Hi,
> According to the documentation it is possible to name xml nodes with mix =
of upper/lower case, i.e
> <person>
>   <lastName>Johnson</lastName>
> </person>
>=20
> But it doesn't work for me. All nodes are lower case:
>=20
>   <select id=3D"getAffairForXmlDocumentByKey" resultClass=3D"xml" paramet=
erClass=3D"string" xmlResultName=3D"person">
>     SELECT   AFFR.AFFAIR_NO AS affairNumber
>                  ,DEBT.LASTNAME as lastName
>     FROM AFFAIRS AFFR
>     LEFT JOIN DEBTORS DEBT ON (DEBT.DEBT_ID =3D AFFR.DEBT_DEBT_ID)
> ...
> </select>
>=20
> But I got xml like this
> <person>
>   <affairnumber>2342342</affairnumber>
>   <lastname>Johnson</lastname>
> </person>
>=20
> Ibatis 2.1.0
>=20
> Postgresql 8.0.1
>=20
> Any help would be appreciated.
> Anyone tried this ?
>=20
> Cheers
> Darek Dober
>=20
>