Hi David,
Set wait_timeout can not solve the problem as it just give a longer time, if time out, still has the same problem of failed to connect to database. We want to let it reconnects automatically.
For MySQL 5.0 and lower versions, the property in jdbc driver (Connector/J) of "autoReconnect=true&failOverReadOnly=false" can work, but for newer versions we don't know how to set it to reconnect automatically.
We have 20 actions and each action has an Advaned Find element to get new status records every 2 seconds, is that means the process connects to database every 2 seconds or connected to database as process started and stop when wait time setted in database out? can not understand why it will get an error of failed to connect database and need to set wait_timeout value, and seems wait_timeout maximum value can not avoid this problem.
By the way, we use MySQL 5.7 and JDBC Driver 5.1.34
Thanks
Best Regards.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
