I think the ns_odbc driver can survive from one connection to another. When I use it, I have to put in a trace filter to close/return the handle.
I can't imagine that it is a good idea to just randomly reuse an open handle. You risk running out of handles for one, but the state of the connection would be more or less random. BTW, this is one of the advantages of ns_db: a persistent shared pool of db connections, but they need to be cleaned up between requests (by ns_db releasehandle). tom jackson On Wednesday 16 April 2008 11:48, Brett Schwarz wrote: > > Hi, > > > > I know aolserver comes with postgres support, but I would like to use > > the Pgtcl library for a project. > > Has anybody managed to use Pgtcl and keep a persistent connection to > > the database that can be re-used by the requests coming in, or do you > > have to keep opening a connection to the db, query the db then close > > the connection for every single request? > > Just curious, why use pgtcl instead of the underlining db api in aolserver? > > Note that I am one of the maintainers of pgtcl (at least one of > theversions), and I don't use it within aolserver. I don't think it hasbeen > proven that pgtcl is thread safe...so I don't know what kind oftrouble you > will get in (although it's on my list to make it so). > > Given that, I don't think you want to share connection/resulthandles across > connections, so you would want to connect/disconnectevery time, just to be > safe...although you could give it a try to seewhat happens... > > I know people who use pgtcl from Apache + mod_tcl, but Apache is a > different environment. > > HTH, > --brett > > > > > ___________________________________________________________________________ >_________ Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > -- > AOLserver - http://www.aolserver.com/ > > To Remove yourself from this list, simply send an email to > <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the > email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
