freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] How to determine if there is any active statement or not on a connection handle

From: Robert Klemme <shortcutter AT googlemail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Cc: FreeTDS AT lists.ibiblio.org
Subject: Re: [freetds] How to determine if there is any active statement or not on a connection handle
Date: Fri, 9 Dec 2005 09:18:32 +0100

2005/12/8, cui yanxin <cuiyanxin AT hotmail.com>:
> Hi ALL,
>
> For some reason I have to use multiple connections for multiple statements.
> What I am trying to do is to reuse a connection handle or close it if there
> is no active statement on the connection handle, is there any way to know
> it?

The usual approach is to obtain a connection, use it and return it
(probably to a connection pool) after usage. What usage pattern do
you have?

Kind regards

robert

[freetds] How to determine if there is any active statement or not on a connection handle, cui yanxin, 12/08/2005
- Re: [freetds] How to determine if there is any active statement or not on a connection handle, Robert Klemme, 12/09/2005