Welcome! Log In Create A New Profile

Advanced

HFSQL-connection Android => Server stops after 5 minutes

Posted by gpredl 
HFSQL-connection Android => Server stops after 5 minutes
November 26, 2018 08:59AM
Hi,

we have a problem with Andrid mobile phones and a local HFSQL server connected by WLAN. The mobiles are "always on". Nevertheless the phones do not reconnect though there's a timer which re-connects (= should reconnect) in intervals.

Any ideas which could help solving this annoying problem?

Kind regards,
Guenter Predl
office@windev.at
Re: HFSQL-connection Android => Server stops after 5 minutes
November 26, 2018 10:40AM
Hi,

check the Hconf.ini file under HFSQL Server folder.
Two entries should be there under [INIT] section:

hkaInterval, hkaTimeout

If no, add them as follows:

hkaInterval=1800
hkaTimeout=120

The first is "Keep Alive Interval" in seconds (30 min)
The second is "Keep Alive Timeout" is seconds (2 min)

Good luck

Vassilis
Re: HFSQL-connection Android => Server stops after 5 minutes
November 26, 2018 10:42AM
Hi again,

The above settings are for V23 !!!

Regards

Vassilis
Re: HFSQL-connection Android => Server stops after 5 minutes
November 26, 2018 02:41PM
Hi Vassilis, THANK YOU VERY MUCH!!!

Kind regards,
Guenter Predl
office@windev.at
Re: HFSQL-connection Android => Server stops after 5 minutes
December 01, 2018 10:40AM
Hi Vassilis,

thx for the tipp, but I ended in the following code, because it did'nt work for me for the current problem: (but I'll change the .ini always, from now on!!)

HOnError("*",hErrConnectionLoss,"Reconnect")

This comes in the service routine OR you can place it in global code.

//This procedure is a global one...
PROCEDURE Reconnect()

ExecuteMainThread(ToastDisplayMain,"Connection lost, try to reconnect")

HReconnect()

RESULT opCancel

//Main thread routine (top/right click on "1:30" click on "Main thread")
PROCEDURE ToastDisplayMain(sMessage)

ToastDisplay(sMessage)

The result is, any time the connection is lost, the "Reconnect" routine will be fired, a message will appear, but no error will shown.
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: