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