Hello, I have a Talend job that executes a stored procedure. The stored procedure takes a really long time to finish. Due to this long processing time, the MySQL connection is lost and the job cannot gracefully complete. I have ensured that all my connections are "using existing connections". Does anyone know what I can do to keep the connection alive, indefinitely? Thanks, Zack
Sometimes this does not help, if the server its self kills the connection. It is always a good design to keep the transaction as short as possible. You should consider to open and close the connection and reopen it again. As a database administrator I would not be happy to see connection open that long.