Re: connection timeouts

On Aug 28, 12:26 pm, Kev <K...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi Joe,

I ran some queries to determine if there were any blocking proesses at the
time and none showed up. Also, the number of locks was normal, nothing out of
the ordinary.

Kev.

"Joe Weinstein" wrote:

Kev wrote:

Hi,
Experiencing a problem whereby a jdbc connection seems to become stuck while
executing a prepared/callable statement (and does not return from the call).
The connection will then throw an SQLServerException some time later
reporting a Connection Timed Out error. It appears to be random and does not
consistently fail on the same area of code.
Also, is there a way to set a connection timeout that may help with this?

SQL Server 2005 SP1

Anyone else experienced this problem or has any ideas?

Cheers.

The first thing you'd want to look at is at the DBMS. You'd want
to find out what the DBMS thinks is going on with that connection.
It might be that your statement's SQL is blocked by locks in the
DBMS that are being held by another process.

Ok, I would double-check, and verify what the DBMS thinks
specifically
is being done by the JDBC connection. If the DBMS says there is
nothing at all being done, then there's a complicated problem. What
version of the JDBC driver are you using?
Joe

.

Relevant Pages

  • Re: JDBC or ODBC?
    ... JDBC connection for a high traffic site. ... performance will come by doing as much of the DBMS-related work in the DBMS where the data is. ... Always do all you can to avoid shipping huge wads of raw data out of the DBMS to be processed. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • [opensuse] opensuse 11.1 on a Lenovo Thinkpad T61p
    ... -The kernel shipped with 11.1 locks up on this machine. ... -the machine will not suspend to ram or disk. ... Connection was not provided by any settings service ...
    (SuSE)
  • Re: Abnormally dropped sessions & running programs
    ... by clicking on the close window button or killing it through Task ... TCP/IP connection to the server via a virtual workstation ... terminate the interactive process is via SIGNOFF or ENDJOB at the ... created under a default system user, etc, if a JDBC connection is ...
    (comp.sys.ibm.as400.misc)
  • Re: Blocking problems
    ... This locks the connections collection, but does not show if an existing ... connection in a send loop also locks "this._connections" in its loop. ... > private SoapTcpConnection GetConnection ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Locking a SQL Server Record from ASP + Batch Transactions
    ... people trying to edit the same record at the same time. ... I would expect that if someone locks a record and goes away for lunch, ... database locking may not work at all since the connection actually drops the ... you solution of setting up a reservation field to kludge it has ...
    (microsoft.public.dotnet.framework.aspnet)