17 messages in com.mysql.lists.dotnetidle connection timeout| From | Sent On | Attachments |
|---|---|---|
| Bill Angus | 21 Dec 2005 09:56 | |
| Jorge Bastos | 21 Dec 2005 10:13 | |
| Darren Hill | 21 Dec 2005 13:40 | |
| Darren Hill | 21 Dec 2005 13:46 | |
| Darren Hill | 21 Dec 2005 14:09 | |
| Philip Denno | 21 Dec 2005 14:13 | |
| Chris Herridge | 21 Dec 2005 14:16 | |
| Darren Hill | 21 Dec 2005 14:54 | |
| Darren Hill | 21 Dec 2005 15:28 | |
| Chris Herridge | 21 Dec 2005 15:34 | |
| Philip Denno | 21 Dec 2005 15:37 | |
| Darren Hill | 21 Dec 2005 15:39 | |
| Bill Angus | 21 Dec 2005 19:09 | |
| Kevin Turner | 22 Dec 2005 01:10 | |
| Daniel Fisla | 22 Dec 2005 08:18 | |
| mdan...@psychtest.com | 22 Dec 2005 09:43 | |
| David Dindorp | 27 Dec 2005 03:22 |
| Subject: | idle connection timeout![]() |
|---|---|
| From: | Bill Angus (mdan...@psychtest.com) |
| Date: | 12/21/2005 07:09:48 PM |
| List: | com.mysql.lists.dotnet |
Thanks for your reply Jorge:
I think perhaps I miscommunicated... I do establish a connection with
connector.net. The connection works fine without pooling. I use the same
connection object in all my forms by sharing the single connection as a public
variable of the application's main class/window. This connection object works
very well as long as the user is actually using it. The single connection is
quite happilly being used for everything done in the application.
I think .net rather than MySql may be closing the connection object when the
connection is idle for some time (say 15 minutes).
I had a look at the connection object properties using the debugger, and there
is a READ-ONLY run-time integer property called myConnection.ConnectionTimeout
which is set at 15
I assume this means 15 minutes. Interestingly, 15 minutes is more or less the
time that the connection stays alive when the app is idle.
Does anyone know if there is a way to set this connection timeout higher (say to
the 8 hours that mySQL is documented to give as timeout of MySQL server
connection)?
I found a property variable MyConnection.InitializeLifetimeService which may
have something to do with this -- but I don't know how to use it to change the
ConnectionTimeout away from the default value of 15.
Thanks anyone who has solved this.
Have a great day!
Bill Angus, MA http://www.psychtest.com




