Re: Keep-alive?

Dave Page wrote:

>  
>
>>- this works only for the main window, not for those getting 
>>their own connection. The wxWin timer will conflict with the 
>>threaded executed queries, because it's not aware of 
>>previously or currently executed queries.
>>    
>>
>
>It purposefully only works on the master connection to each server as
>there is no point in individually polling individual databases on the
>same server.
>
Each database has its own connection to the server (just checked with 
netstat), and thus is individually target of a firewall surveillance/ 
forced tcp disconnect.

> Unless you've changed the code from what I originally
>wrote, the master connection will never be used for threaded queries.
>
Wouldn't make sense to thread them too, but what about disconnects on 
Query Tool, Data Grid etc?

>
>  
>
>>- Does it work at all? pgConn is no window, so where should 
>>the message come from?
>>    
>>
>
>Yes of course it works, I didn't just randomly type code and post it:
>
>class pgConn : wxFrame
>

Deriving from wxFrame doesn't mean it gets events, because the default 
wxFrame constructor won't create a window, so it's no window in win32's 
sense. I just checked the msw implementation of wxTimer, it doesn't use 
the message loop, but a callback proc, that's why it's working. Still, 
declaring pgConn to a kind-of window doesn't make me feel too 
comfortable (wxEvtHandler should be sufficient). I'd rather like to have 
the pg classes free of all this sm_xxx stuff.

Regards,
Andreas