Changing Timeout

[Jason Dunn]

I am running scripts on a remote host which take a long time to run, I've been monitoring them with top since my terminal usually gets reset before they finish. The logging I've done doesn't point to a general error in the code, and it is heavily wrapped in try/catch blocks which should catch most errors.

Once a connection is open, how do you increase the period before the connection times out?

[Jason Dunn]

Sorry I forgot to add I'm opening the connection with a driver via:

Connection theConnection = DriverManager.getConnection(            "jdbc:mysql://localhost:3306/database", "username", "password");

Where database is the correct name, and username/password are for a root account.