Database timeout causes wrong results auf <show_job/> (MySQL)

If the database connection timed out the history entries from the database are not provided in the xml response of a <show_job/> request:

<show_job job="jobname" max_task_history="10" what="task_history"/>

A java.sql.SQLNonTransientConnectionException is thrown instead.

See attachements for samples:

• show_job_ok.xml: Result of the command above before database timed out.
• show_job_error.xml: Result of the command above after database timed out.

This behaviour was observed with MySQL, probably it applies to other databases, too.

See http://sourceforge.net/apps/mediawiki/jobscheduler/index.php?title=MySQL_wait_timeout for a workaround.