I sometimes leave long computations running overnight and return in the morning to find that my database connection has timed out. I typically have to kill the kernel and launch a new database connection in order to be sure everything works properly.
The lead error after a timeout suggests that I use
"the Connector/J connection property 'autoReconnect=true' to avoid this problem"
But Wolfram's documentation, to the best that I can find, never mentions this option. Given a connection command like
OpenSQLConnection[ JDBC["MySQL(Connector/J)", "localhost:3306/sample_schema"], "Username" -> XXXXXX, "Password" -> YYYYYY]
how and where do I set
autoReconnect to be True?