Spinning wheel and Postgresql?
David McKeone
david at artsman.com
Sat Aug 16 10:49:17 EDT 2014
I haven’t tried this myself, but if your connection is always done over a long distance (or unreliable) you may want to use the background worker in Studio 6 to test it first. That would at least allow you to display a message to the user, and the UI would still be responsive while you are waiting for the connection to work or timeout. If it does succeed, then you could create a regular PostgreSQL connection immediately after that.
__________________________________
David McKeone
Arts Management Systems Ltd.
mailto:david at artsman.com
http://www.artsman.com
Phone: (403) 536-1203 Fax: (403) 536-1210
On Aug 15, 2014, at 7:15 AM, Franco Maregotto <franco at hotelaqua.it> wrote:
> I could be another experience, but the criminal is not postgres (and I use Omnis 5.2 against a postgres remote server)
> The spinning wheel (both mac and Win7) behave like in any browser when you look for a IP address not responding.
> Sometimes chrome or explorer does not say you immediately "This site is unreachable". You must wait a (long) while and look the wheel spinning
> The hard thing here is to "teach" the local computer to stop trying to obtain a server response after x seconds, when the connection drops, maybe after one hour of inactivity (and the local computer isn't aware of this).
> Server (postgres) knows perfectly you're logged off, but local PC or Mac don't.
> The code I wrote to reconnect works good, but I found no way to make my local computer avoid to wait several seconds (up to 45) to decide that there is nobody listening out there.
> Still looking the trick to workaround this issue.
>
> Franco
>
>
> Franco Maregotto
> franco at hotelaqua.it
>
>
>
>
> Il giorno 15/ago/2014, alle ore 10:56, ADJob <mats at adjob.se> ha scritto:
>
>> Hi,
>>
>> I just wonder how many experience ”spinning wheel” (hangs) when using Omnis 6.x and Postgresql? (Especially after a period of inactivity)
>>
>> TIA,
>>
>> Mats Olsson, ADJob Nordic AB, Sweden_____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en
mailing list