MySQL Keeps Dropping the Connection
If adjusting the Keep Alive settings via the Edit->Preferences menu does not
solve the problem, MySQL does provide several JDBC properties to allow the
user to set the connection timeout, socket timeout, and auto reconnect
properties of the MySQL JDBC driver. Listed below is some information about how
to connect to MySQL with these properties set.
1. Click the "Add Connection Profile" button or select DB Tools -
Add Connection Profile in RazorSQL.
2. Select MySQL as the database type and JDBC as the connection type.
3. Enter the following information:
Profile Name: <the name you want the connection described as>
Driver Location: <browse to the location of the MySQL JDBC driver>
Driver Class: com.mysql.jdbc.Driver (assumes the use of the MySQL Connector/J driver)
Login: <your login id>
Password: <your password>
JDBC URL:
jdbc:mysql://<host>:<port>/<database_name>?
connectTimeout=0&socketTimeout=0&autoReconnect=true
autoReconnect should only be set to true if using the other connection
properties does not solve the problem.
Replace <host> with the ip address or name of the server.
Replace <port> with the port. The default is 3306.
Replace <database_name> with the name of the database if applicable
Here is a link with some information about the properties in the JDBC URL:
http://dev.mysql.com/doc/refman/5.0/
