Alex, I know sqlYoga does that and if the connection died, it tries to reopen it but I don't know the implementation details.
Andre On Wed, May 26, 2010 at 1:50 PM, Alex Adams <a...@a2technology.com> wrote: > Does anyone have a simple technique for testing to see if a DB connection > is > still functioning before trying to use it to execute some SQL? > > I have an app that accesses hosted databases directly (postgres). Users > logon at app startup. If they let the app sit for long enough, the > connection to the DB server is dropped. This is reasonable, but I want a > simple way of testing to see if the connection has been dropped and if it > has to reestablish the connection transparently before executing SQL > statements. > > I need a simple isDBStillThere handler. Is anyone doing anything similar? > > Thanks, > -- > Alex Adams > > hawkVision ‹ tools for solving Wicked Problems > > (a)2 Technology Partners, Inc. > 831-726-8013 > a...@a2technology.com > hawkVisionInfo.wordpress.com > universalConnector.wordpress.com > > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution