Hello,

I've run into an odd problem.  I have a connection data management library for 
a project that we have been working with for a while.  The purpose of this 
library was to work around some oddities in the ODBC environment where lots of 
connections were being held open for a long period of time.  That's not really 
important though.

Here's the problem.  I maintain a list of open connections that are recycled.  
This is a pretty tight management list.  It works great until you do something 
stupid like issue restart command to the MySql server at which time the 
connection is broken.  What I  know is that when this happens, the connection 
is goes from state=open to state=close.  This is expected.  The problem is that 
it has to cycle through each connection before the good ones are loaded.

Is there a way to test a connection prior to using it to find out if it's 
actually open?  Like pinging the active connection.

If I could do something like that prior to returning the connection, I could 
then loop through the connections to check until I get a good one.  We have all 
of the general login in place, but the assumption was made that the connection 
state was real time, which is now known to be false.

Any ideas/assistance would be greatly appreciated.

Gary

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to