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: <[EMAIL PROTECTED]>
To: <[email protected]>
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
>
