iBatis help on list

[Gana <ma...@roomity.com>]

I am wondering any future releases on the way!!!! We are abt implement 
for new release if the beta is available...

- Gana.

Re: Result as Xml, and lower/upper case

[Larry Meadors <la...@gmail.com>]

IMO, xml results are not that great in iBATIS. 

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 <do...@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>
> 
> 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
> 
>

Re: Result as Xml, and lower/upper case

[Darek Dober <do...@op.pl>]

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: <do...@op.pl>
To: <us...@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
>

Result as Xml, and lower/upper case

[do...@op.pl]

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

Re: iBatis help on list

[Clinton Begin <cl...@gmail.com>]

Yep. Version 2.1.5 can be released any time. I think everyone just got 
really busy in the last couple of weeks. We'll try to release it ASAP.

Cheers,
Clinton

On 7/15/05, Gana <ma...@roomity.com> wrote:
> 
> I am wondering any future releases on the way!!!! We are abt implement
> for new release if the beta is available...
> 
> - Gana.
>