can ehcahce help me

[reddeagle]

Hi Guys,

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.

[dejanp]

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.