Re: ODBC Connection Pooling and Temp Tables

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 <eferreyra@xxxxxxxxx>
Sent by: informix-list-bounces@xxxxxxxx
12/04/2008 18:21

To
informix-list@xxxxxxxx
cc

Subject
ODBC Connection Pooling and Temp Tables






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


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

Relevant Pages

  • ODBC Connection Pooling and Temp Tables
    ... Hi, i need to filla .NET Data Set with 3 related tables, the bottom ... And the fill the tables with joins to the TEMP table. ... I would like to work with/without Connection pooling support all ... Its possible that the first query goes thru a connection and laters ...
    (comp.databases.informix)
  • Re: VB with SQL Server... Unable to create temp table using ADO connection object
    ... I am not using connection pooling. ... I am not able to create the temp table ... FYI - While execute the SQL in VB, I am not getting any error. ... but when I query the temp table either in VB or in SQL server ...
    (microsoft.public.sqlserver.programming)
  • Re: VB with SQL Server... Unable to create temp table using ADO connection object
    ... > I am not using connection pooling. ... SQL Server MVP ... but when I query the temp table either in VB or in SQL ...
    (microsoft.public.sqlserver.programming)
  • Re: ssis error
    ... Connection Pooling to on, ... create database toto ... after query I open query analyse and my table is there in toto ...
    (microsoft.public.sqlserver.dts)
  • Re: Connection Pooling(Expecting Quick reply to get help)
    ... and disable the Connection pooling by DB. ... On SQL Server at least, ... OLE DB cancels the query - but cancelling a query is not cause for ... OLE DB opens a second connection behind your back. ...
    (microsoft.public.data.oledb)
Loading