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