ODBC Connection Pooling and Temp Tables

[eferreyra]

Hi, i need to filla .NET Data Set with 3 related tables, the bottom
line is for the best explain i need frst to do a select XXX into
temp...

And the fill the tables with joins to the TEMP table.

Im using ADO.NET Odbc Data Provider and IBM INFORMIX ODBC DRIVER (3.00
TC3)

I would like to work with/without Connection pooling support all
scenarios, but how connection pooling affects temp tables ?

Its possible that the first query goes thru a connection and laters
with others not finding the temp table ??

Also: The query is issued by a WCF service so probably multiple
threads can access the methods that run the querys.

How i can work with temp tables supporting connection pooling ?

Thanks people!!! (sorry my english)

Enrique

[Sheshnarayan Agrawal]

Temp table is something which will be dropped once database session closes and/or server gets down. Now when you use connection pooling you are not really closing connection to the database. In case of connection pooling (even though you call close connection) the connection will still exist until you exhaust the time out period. So within the time out period (until it physically closes the connection) I would expect temp table to be there ! I haven't seen anyone complaining about connection pooling with temp table, so I would assume it works !! ofcourse there could be the possibility that no one might be using this scenario !!

HTH
-Shesh

eferreyra <efer...@gmail.com> Sent by: informix-l...@iiug.org 12/04/2008 18:21

To inform...@iiug.org cc Subject ODBC Connection Pooling and Temp Tables

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[Jonathan Leffler]

The other possible area of concern (over Sheshnaryan's) is whether the
temp tables need to be accessed across pooled threads - that is,
whether the table might be created in one thread and then need to be
accessed in another. That would cause problems because temp tables
are private to a session.

--
Jonathan Leffler #include <disclaimer.h>
Email: jlef...@earthlink.net, jlef...@us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.