NO : Postgresql re-establishing connection

[Ken Dimson]

the test for kSessionStateLoggedOn in my email would return true if the session is OK so my if statement would need to be reversed to handle the false event not the true as i to hastily typed.

KEn


On Dec-3-10, at 9:06 AM, Ken Dimson wrote:

> The Postgresql dam has the $connectstatus method which returns the status of the connection.
> 
> The dam also has a $reset method to reconnect to the server.
> 
> In my super table class $construct I experimented with the following although have not proven it works perfectly yet. I cannot remember if the test $connectstatus hangs if connection is lost which would defeat the purpose.
> 
> I test the connection and then do a $reset 
> Do oSession.$connectstatus() Returns isConnected
> If isConnected<>kPgSqlConnectionOK&oSession.$reset.$cando
> Do oSession.$reset
> End If
> 
> There is also a session property $state so one could test that as well
> 
> If oSession.$state=kSessionStateLoggedOn
> do something such as $reset
> end
> 
> Ken
> 
> 
> On Dec-3-10, at 7:37 AM, Andy Hilton wrote:
> 
>> Postgres Gurus
>> 
>> Is there an easy way (or any way !) within Omnis to re-establish a connection to Postgres in the event of a momentary lapse of network ?
>> 
>> In MySQL I can use their ping command which does a nice job of re-establishing a connection if it was broken, and am looking for something similar in Postgres ?
>> 
>> Andy_____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> Ken Dimson
> kdimson at dimson.com
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com

Ken Dimson
kdimson at dimson.com