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