HOWTO Recover from Database failure

Migrateduser

Hi all,

I'm looking for help on getting my report running without user intervention.

The reports runs in a separate thread and is started every 5 minutes.
Connection is made via a DataSource with JDBC (defined in the report) to an Oracle database running on a separate server.

The only part that runs in the thread is the 'task.run()' to reduce overhead from creating factory, engine , design and report. No changes to the report are needed.

Now this all runs fine and the html output is generated every 5 mins.
So far so good.

However when one of the following errors occur, it does not seem to recover.
. network connection failure
. tns listener failure/down
. database failure/down

I can catch the errors and I'm generating an HTML file indicating an error occurred.

Is there a way to recover from these types of errors so when the errors are gone, the report is generated again without user intervention.