Re: setQueryTimeout not work?

On Jan 30, 2:21 am, mttc <mtczx...@xxxxxxxxx> wrote:
I check Above loop with .NET, and I got timeout exception. I not see
any reason (according the JDBC spec) to implement it only by sending
cancel to the server. the app must sure that on any situation
operation cancel after timeout.

I sure that timeout with .NET stop waiting for unplug cable, even
socket not report error. I not think that have app that prefer
behaviour of waiting eternity.

I agree with you, in that the driver could/should have a (one) utility
thread that handles all timeouts for any connections, connection
attempts, statements etc. (never have one thread per connection),
but the question is what the driver can do to make the connection
viable after the timeout. Until the DBMS does respond to the original
query or the cancel, the connection is useless...
.

Relevant Pages

  • Re: OT: Testing SMTP connections
    ... In the same way that exim or exchange is a client. ... timeout after connection to this app, ... If we run nagios SMTP check on the machine hosting the receiving app, ... time the nagios checking code is reporting a timeout, ...
    (uk.rec.motorcycles)
  • OT: Testing SMTP connections
    ... We have an ongoing issue where exim reports that it has suffered a timeout after connection to this app, and we're having real trouble working out where this is. ...
    (uk.rec.motorcycles)
  • Re: OT: Testing SMTP connections
    ... timeout after connection to this app, ... If we run nagios SMTP check on the machine hosting the receiving app, ... time the nagios checking code is reporting a timeout, ...
    (uk.rec.motorcycles)
  • Re: Socket Conection
    ... a timeout mechanism which will terminate the ... >socket command if the connection has not been established within a set ... If the connect happens before the after event, cancel ...
    (comp.lang.tcl)
  • Re: setQueryTimeout not work?
    ... I check Above loop with .NET, and I got timeout exception. ... operation cancel after timeout. ... I not think that have app that prefer ... behaviour of waiting eternity. ...
    (microsoft.public.sqlserver.jdbcdriver)