locked
Max Idle Time for a Connection in SQL Server 2005 RRS feed

  • Question

  • Can you please let me know where I can set the MAX IDLE TIME for the SQL SERVER CONNECTION.

    IS this the value set for the KEEp Alive propoerty in the sql server configuration Manager.

    Thanks.

    Friday, October 1, 2010 6:59 PM

Answers

All replies

  • Hello Koduru,

    there is no Max Idle Time setting in SQL Server 2005.

    What are you trying to achieve? If you want to control orphan connections, then please use this guide - Understanding Keep Alive:

    http://blogs.msdn.com/b/sql_protocols/archive/2006/03/09/546852.aspx?wa=wsignin1.0


    Arthur My Blog
    By: TwitterButtons.com
    • Proposed as answer by ArthurZ Friday, October 1, 2010 8:22 PM
    • Marked as answer by Alex Feng (SQL) Wednesday, October 20, 2010 10:42 AM
    Friday, October 1, 2010 8:22 PM
  • Hi Arhur:

    We are receiving the below errors from our of our portal applications,they say the liferay portal is set to max idle time of 0(which is indefinite) so the sql server needs to be configured to addess the below issues.

    > 10:30:17,947 ERROR [JDBCExceptionReporter:101] Invalid state, the Connection object is closed.

    > 10:30:17,979 WARN  [NewPooledConnection:486] [c3p0] A PooledConnection

    > that has already signalled a Connection error is still in u se!

    > 10:30:17,979 WARN  [NewPooledConnection:487] [c3p0] Another error has

    > occurred [ java.sql.SQLException: Invalid state, the Connect ion object is closed. ] which will not be reported to listeners!

    Thanks.

     

    Monday, October 4, 2010 5:47 PM
  • Try setting the Remote Query Timeout to 0 on the Connections Page of the SQL Server configuration properties.


    Arthur My Blog
    By: TwitterButtons.com
    Monday, October 4, 2010 6:08 PM
  • Hi Arthur :

     

    I don't think this would resolve my problem as this setting is not for connectivity.

    Monday, November 1, 2010 6:36 PM
  • Hi Arhur:

    We are receiving the below errors from our of our portal applications,they say the liferay portal is set to max idle time of 0(which is indefinite) so the sql server needs to be configured to addess the below issues.

    > 10:30:17,947 ERROR [JDBCExceptionReporter:101] Invalid state, the Connection object is closed .

    > 10:30:17,979 WARN  [NewPooledConnection:486] [c3p0] A PooledConnection

    > that has already signalled a Connection error is still in u se!

    > 10:30:17,979 WARN  [NewPooledConnection:487] [c3p0] Another error has

    > occurred [ java.sql.SQLException: Invalid state, the Connect ion object is closed. ] which will not be reported to listeners!

    Thanks.

     

    Hi, I faced the same error..Did you solve this problem on liferay (c3p0) side?

    Please Let me know!

    Wednesday, November 10, 2010 12:06 AM