briany at qldlearning.com
Tue Feb 2 18:11:25 CST 2010
Although not pretty, you could possibly create a timer which just issues a useless query every 15 seconds or so:
executeSQL connectionID, SELECT "1"
send "keepAlive" to me in 15 seconds
> Well I've discovered in my experience that ALL SQL servers have a default timeout to clear stale connections. The server doesn't know if someone pulled the plug on a computer or took a meteor strike, and it can't leave the connection open forever.
> I think I have resolved the problem by re-issuing a connect command and then getting the database ID. Then I can use the <maybe> new ID in my queries.
> On Feb 2, 2010, at 4:01 PM, zryip theSlug wrote:
>> Hi Bob,
>> I've no experience with the on-rev server, but I suppose that it works
>> like another server.
>> 1) Check your logs. Often it contains the cause of how/why you have
>> reach the time out.
>> 2) If you have parameters like on an Apache server you maybe have an
>> equivalent to the KeepAliveTimeout directive.
More information about the use-livecode