ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darek Dober" <doover...@op.pl>
Subject Re: Result as Xml, and lower/upper case
Date Sun, 17 Jul 2005 17:24:56 GMT
In postgresql column names are converted to lower case, unless you write
your sql like this:

SELECT   AFFR.AFFAIR_NO AS "affairNumber"
                ,DEBT.LASTNAME as "lastName"

Just if someone had the same problem:)

Darek Dober


----- Original Message ----- 
From: <dooverone@op.pl>
To: <user-java@ibatis.apache.org>
Sent: Friday, July 15, 2005 2:09 PM
Subject: Result as Xml, and lower/upper case


> 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>
>
> But it doesn't work for me. All nodes are lower case:
>
>   <select id="getAffairForXmlDocumentByKey" resultClass="xml"
parameterClass="string" xmlResultName="person">
>     SELECT   AFFR.AFFAIR_NO AS affairNumber
>                  ,DEBT.LASTNAME as lastName
>     FROM AFFAIRS AFFR
>     LEFT JOIN DEBTORS DEBT ON (DEBT.DEBT_ID = AFFR.DEBT_DEBT_ID)
> ...
> </select>
>
> But I got xml like this
> <person>
>   <affairnumber>2342342</affairnumber>
>   <lastname>Johnson</lastname>
> </person>
>
> Ibatis 2.1.0
>
> Postgresql 8.0.1
>
> Any help would be appreciated.
> Anyone tried this ?
>
> Cheers
> Darek Dober
>


Mime
View raw message