Testing a DB connection

Andre Garzia andre at andregarzia.com
Wed May 26 13:23:38 EDT 2010


I know sqlYoga does that and if the connection died, it tries to reopen it
but I don't know the implementation details.


On Wed, May 26, 2010 at 1:50 PM, Alex Adams <alex at 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
> alex at a2technology.com
> hawkVisionInfo.wordpress.com
> universalConnector.wordpress.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at 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.

More information about the Use-livecode mailing list