ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eugeny N Dzhurinsky <b...@redwerk.com>
Subject dynamic tables names in query problem
Date Tue, 19 Sep 2006 13:01:38 GMT
I'm trying to do this:

    <statement id="prepareView" parameterClass="list">
        create temporary view task_url_view as
        <dynamic>
            <iterate conjunction=" union all ">
                select * from task_url_$values[]$
            </iterate>
        </dynamic>
    </statement>

but this seems not work - 
weird exception is thrown: ERROR - relation task_url_$1 does not exists

I'm calling this statement as SqlMapClient.update("prepareView",list).

-- 
Eugene N Dzhurinsky

Mime
View raw message