on-rev queries

[Bob Sneidar]

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. 

Bob


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.