ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: nested iterate over 2 different properties
Date Mon, 08 May 2006 14:07:16 GMT
No, the use of $'s is required because it is begin used to specify columns and tables in the
SELECT-clause. #'s would pass the columns as a parameter for the prepared statements, this
would cause an SQLException.

 

This is definitely related to the iterate-tag, I believe some rework is done to this part
of iBATIS by Jeff Butler, do not know the details about this.

 

Niels

 

________________________________

From: Olaf Bey [mailto:olaf.bey@gmail.com] 
Sent: maandag 8 mei 2006 16:01
To: user-java@ibatis.apache.org
Subject: Re: nested iterate over 2 different properties

 

Hello Guido,

shouldn't it be #agrupaciones[]# instead of $agrupaciones[]# ?

Greetings,

Olaf

On 5/8/06, Guido García Bernardo <ggb275@tid.es> wrote:

Hello, 

I am using ibatis 2.1.7, and I have the following sql statement:

<statement ...>
    <iterate property="tabla" conjunction="UNION">
    SELECT       
        <iterate property="agrupaciones" conjunction=",">
            TABLA.$agrupaciones[]$
        </iterate>
    FROM $tabla[]$ TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')
    </iterate>
</statement>

where:
    $tabla[]$ = { "PENDIENTES", "ANULADAS" }
    $agrupaciones[]$ = { "AREA" }

but the generated sentence is:

    SELECT
        TABLA.AREA
    FROM PENDIENTES TABLA 
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')    
    UNION
    SELECT
    FROM ANULADAS TABLA WHERE
        TABLA.A IN ('A','B','C','D','W','G')

instead of:

    SELECT
        TABLA.AREA
    FROM PENDIENTES TABLA
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')     
    UNION    
    SELECT
        TABLA.AREA
    FROM ANULADAS TABLA 
    WHERE
        TABLA.A IN ('A','B','C','D','W','G')    

It seems not to be using the correct index for the property "agrupaciones" in the second iteration
of the property "tabla"... I think this is a bug (maybe related to http://issues.apache.org/jira/browse/IBATIS-281)

Is there any idea or workaround to solve it?

Thank you very much,
Guido García Bernardo

 


Mime
View raw message