Post reply

Connection time out using both JDBC and SQL Client but Management Studio is fine

  • July 12, 2018 at 5:07 am

    #407176

    Hi, I am having trouble with timeouts in applications and none the wiser as to why.

    I am getting connection timeouts reported from applications using JDBC and SQL Clients - they are set not to timeout for 300 seconds but they always timeout after 60 seconds.

    To replicate in ssms I run the following then undertake the same stored procedure the applications are trying to run.
    BEGIN TRANSACTION
    SELECT * FROM ALLCLASSESWCOMMENTS_PS_SR WITH (TABLOCKX, HOLDLOCK)
    WHERE 0 = 1
    WAITFOR DELAY '01:00'
    ROLLBACK TRANSACTION

    The  query windows containing the exec SP command keeps on waiting, until I run the rollback and then 7 seconds later completes the task - this works after  5 minutes and does not time out.

    My question is why am I experiencing the 60 second timeout for the applications and am unable to replicate in SSMS.

    Many Thanks for your help,

    Oliver

  • July 12, 2018 at 5:55 am

    #1997265

    It seems likely that there is some configuration element in your applications that is overridden somewhere that at the moment, you are unaware of.   Something in your connection to SQL Server is forcing a timeout value smaller than you want.   Things it might be:  Connection Pooling, dot net configuration, or some use of some feature that forces the timeout value.  Of course, that's not exactly a large list, and I'm guessing there may well be a whole bunch of other stuff to check, but it's the first few things that come to mind.   Hope that helps...

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • July 12, 2018 at 6:43 am

    #1997273

    Thanks for the reply. I tried it with MS Access as well using a pass through query and it worked fine. I think the trouble lies with the application. I will review your suggestions. Many Thanks

  • July 12, 2018 at 6:46 am

    #1997275

    olibbhq - Thursday, July 12, 2018 6:43 AM

    Thanks for the reply. I tried it with MS Access as well using a pass through query and it worked fine. I think the trouble lies with the application. I will review your suggestions. Many Thanks

    Glad I could help.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply