Print Thread
Check connection vs. Check connections
#56439 05/11/17 01:10 PM
Joined: Nov 2008
Posts: 14
F
fctb Offline OP
Member
OP Offline
Member
F
Joined: Nov 2008
Posts: 14
Hi,

I'm having some problems with one database where idle connections (firewall problem to be fixed) are dropped.

I tried the "Check connection" option but seems like is keeping alive one connection not all established connections. In debug mode I was expected to see multiple "pings" every minute:

Code
07:03:03.892 TOracleQuery $0E43ADE0 Start Query.Execute
             SQL = select 'x' from dual
07:03:03.896 TOracleQuery $0E43ADE0 End  (1 record processed)
             Duration = 0
07:04:03.900 TOracleQuery $0E43ADE0 Start Query.Execute
             SQL = select 'x' from dual
07:04:03.902 TOracleQuery $0E43ADE0 End  (1 record processed)
             Duration = 0
07:05:03.912 TOracleQuery $0E43ADE0 Start Query.Execute
             SQL = select 'x' from dual
07:05:04.603 TOracleQuery $0E43ADE0 End  (1 record processed)
             Duration = 0.687

Is this an intended behavior or a bug?

Thanks!

Re: Check connection vs. Check connections
fctb #56442 05/12/17 09:01 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I think it would be an "unintended restriction". We'll check it out and will improve this.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.267s Queries: 14 (0.100s) Memory: 2.5006 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 05:47:35 UTC
Valid HTML 5 and Valid CSS