Re: connection timeouts



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.

.

Relevant Pages

  • RE: LAN Connection jumping in and out of connectivity - again
    ... am experiencing exactly the same problem to "anonymous". ... I am useing a Netgear FR114P which I had replaced under warranty as I was ... and internet connection is fine at that stage), ... > I've also updated all drivers and firmware for the router and adapters. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Network Connection
    ... From last December I have been experiencing network connection problem on ... the server to SP2 and install the updated to disable the SNP and the TCP ...
    (microsoft.public.windows.server.general)
  • Re: Screen Cut Off
    ... and why you are experiencing this... ... As a follow-up to my original question, in applications like Rescoe File ... I can just barely tap the "Find" ... > where it finalizes the connection to a PC over Bluetooth for ActiveSync, ...
    (microsoft.public.pocketpc)
  • Re: Remote Desktop Connection and XP Service Pack 3
    ... Everything was fine prior to SP3. ... I am experiencing an issue using Remote Desktop Connection after ...
    (microsoft.public.windowsxp.work_remotely)
  • Internet slow? Virus / Spy ware
    ... I am experiencing a really slow internet speed. ... experiencing the problem of slow connection. ... I All three have Norton Internet Security. ... a virus scan but cannot find any virus etc. Could this be the result of Spy ...
    (microsoft.public.windowsxp.general)
Loading