Re: global temporary table and connection pooling

From: Barnoit <jbarney_ca_at_yahoo.ca>
Date: 5 Mar 2004 17:41:48 -0800
Message-ID: <cd2c60c8.0403051741.7677854b@posting.google.com>

>
> Just because it is a multipart query doesn't mean you have to "on commit
> preserve rows". Do your multipart using the same session/connection and rows
> from the first query will still be there.

I'm using <xsql:dml> to insert into my gt table, and then <xsql:query> to query the temp table, and then I truncate the temp table. If I don't use preserve rows, the table is empty. You've got me thinking though, I'll check if there is an attribute in xsql to set the commit flag.

thanks

>
> Change the table to on commit delete, and make sure your session gets
> committed or rolled back after use.
>
Received on Fri Mar 05 2004 - 19:41:48 CST