Yes, I tried like this:

<insert id="xxx" parameterClass="xxx">
        create table if not exist #temp  
        (  
        ...               
        )
                
        INSERT INTO #temp
        (...)
        VALUES(...)
</insert>

But it doesn't work. 
I looked in the documentation, but I didn't find a tag like "<create id""
...>



Larry Meadors wrote:
> 
> If you can do it with JDBC, you can probably do it with iBATIS.
> 
> Did you try it?
> 
> Larry
> 
> 
> On Mon, Jul 7, 2008 at 3:46 AM, mimy17 <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> I would like to know if it's possible to create a temporary table in
>> mapping
>> file and how?
>>
>> Thanks
>> --
>> View this message in context:
>> http://www.nabble.com/create-table-in-a-mapping-file---tp18313227p18313227.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/create-table-in-a-mapping-file---tp18313227p18318965.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Reply via email to