Page History

Database Connections to MySQL get lost

Question:

JobScheduler 

I encounter the error:

Error connecting to [host]:[port]: SOS-JAVA-105 Java-Exception java.sql.SQLException("No operations allowed after connection closed."), methode=rollback []

...

How to Change MySQL wait_timeout                

• Steps to change the wait_timeout server system variable
  1. Login into database which is used by JOC Cockpit via MySQL command line or any other MySQL GUI client such as MySQL Workbench. (IMP Note: the following commands will only be effective for the currently selected database.)
  2. Set wait_timeout variable's value by running following command. To get the default and maximum value for idle wait_timeout for your platform refer following article  : Server System Variables : wait_timeout
     • set @wait_timeout = 31536000;
  3. To check  updated Check the updated value of the wait_timeout variable  by by running the following command:
     • select  @wait_timeout;

...