Subject | Re: [firebird-support] Keep alive connection (Delpih, IBX) |
---|---|
Author | Martijn Tonies |
Post date | 2012-08-29T10:00:06Z |
Hi,
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
> When a user leave the machine for a while (not closeing the program) thenAs far as I know: per connection.
> after returning he cannot continue working. He gets "error reading from
> the connection" error. I know the cause. It's TCP timeout. To avoid I have
> to run dummy select to keep alive.
>
> I use IBX to connect FB.
>
> My question is : Do I need to run dummy select per active connection or
> per active transaction?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!