title: How to refresh iBatis Cache with database operations
body: <p><p>We have an Java EE web application using iBatis for ORM. One of the dropdown (select box) shows a master data which is refreshed on a daily basis (say 4.00 AM) via cron jobs loading flat file into oracle database table. <br><br></p>
  
  <p><p> Since the dropdown/select-box has to list ~1000 records and it was static data for 24 hrs, we used the CacheModel feature in iBatis. The select query was made to use a CacheModel with settings "ReadOnly=true &amp; Serialized=true flushInterval=24 hours", so that a single cache will be shared across all users.  <br><br></p>
  
  <p><p> There will no insert/update/delete operations happening from the application to modify this master data <br><br></p>
  
  <p><p> <strong>Question</strong>: <br><br></p>
  
  <p><p> If the external job loading data to this oracle table fails and if the iBatis cache is flushed for the day before we manually load the data in the table, how can i get the iBatis cache flushed again inbetween of the day when i rerun a failed cron job ? <br><br></p>
  
  <p><p> <b> Please note that, there will not be any Insert/Update/Delete operations from the application </b></p>