Check connection vs. Check connections

[fctb]

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:

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

Is this an intended behavior or a bug?

Thanks!

 

[Marco Kalter]

I think it would be an "unintended restriction". We'll check it out and will improve this.