[DB-SIG] how to know the connexion is closed

[Bill Campbell]

On Mon, Apr 24, 2006, Dieter Maurer wrote:
>William Dode wrote at 2006-4-22 18:53 +0000:
>>I search for a generic way (for psycopg, mysqldb, adodbapi) to
>>know that the connexion is closed
>
>I fear there is no generic way....

One could use something like:

try: cur = conn.cursor()
except: cur = None

I would think that attempting to get a cursor from a closed
connection would always raise an error.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

``Intellectually, teachers fall between education theorists and bright
cocker spaniels. (Probably closer to the education theorists. The AKC has
been doing wonders with spaniels.) If you think I'm kidding look at the
GREs for education majors, whose scores are the lowest of all fields, and
remember that these are the smart ones.'' -- http://www.FredOnEverything.net