Hey gang... sorry, I duped the subject of someone elses message... so I'm going to send this again....
In my dbMove application I have the following..... Ask SQL how many records I am moving -> OK Display that amount -> OK Delete all from corresponding MySQL table -> OK Long pause, get a coffee, take a nap.... java.sql.SQLException: Communication link failure: java.io.IOException I read in a few places that this is thrown by MySQL. The question is, can this be corrected by changing the timeout? This would be odd since it seems that the error happens somewhere in the call AND I don't get a connection closed exception. The table in question has 44 million records in it. I have increased my timeout for this connection to over six hours. And the error occurs happens around 3-5mins later. We never return from the delete call...(i.e. It fails in the delete) and we never get a 'X number of rows affected' response. If this is being tracked by a transaction... how can we fix this?... I need transactions for other operations... so INNODB is critical... Anybody have any ideas? I'm running MySQL version 4.0.6 gamma. _TheMechE [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
