Jul 16th, 2007, 08:42 AM
can ehcahce help me
I need to write a reporting tool that pools a db every 20 mins and email users the results back.
Lets say it gets 10 results when query 1 runs at 12:30. (it should email the users these 10 results)
If the report runs again at 13:00 and contains 11 result sets, but 10 of them are from 12:30 i need to only email the user about the 1 extra result.
Is this something i can implement using ehcahce or another cahcing mechanism within spring.
Looks to try and implemnt a clean solution for this, but its getting tricky.
Jul 16th, 2007, 10:54 AM
I don't think caching solutions can help you, as you need opposite from caching - you need persistence. When emails are successfully sent, write a db record somewhere. Next time check the db for already done stuff.