Hi,

I have a single thread trying to connect to a database using JDBCTemplate as follows:

    JDBCTemplate jdbcTemplate =  new JdbcTemplate(dataSource); 

    try{
        jdbcTemplate.execute(new CallableStatementCreator() {
   @Override
   public CallableStatement createCallableStatement(Connection con)
     throws SQLException {
    return con.prepareCall(query);
   }
  }, new CallableStatementCallback() {
    @Override
    public Object doInCallableStatement(CallableStatement cs)
      throws SQLException {
     cs.setString(1, subscriberID);
     cs.execute();
     return null;
    }
   });
     } catch (DataAccessException dae) {
   throw new CougarFrameworkException(
     "Problem removing subscriber from events queue: "
       + subscriberID, dae);
  }

I want to make sure that if the above code throws DataAccessException or SQLException, the thread waits a few seconds and tries to re-connect, say 5 more times and then gives up. How can I achieve this? Also, if during execution the database goes down and comes up again, how can i ensure that my program recovers from this and continues running instead of throwing an exception and exiting?