Pinned topic Timer Event to cache data from database nightly
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-02-01T04:41:13Z at 2012-02-01T04:41:13Z by Michael Burati
SystemAdmin 110000D4XK1493 Posts
Re: Timer Event to cache data from database nightly2012-01-31T18:41:54ZThis is the accepted answer. This is the accepted answer.Hi,
That doesn't sound like a good fit for a portlet application. I would suggest some type of scheduled process outside the context of a portlet request/response.
DGawron 10000054HC76 Posts
Re: Timer Event to cache data from database nightly2012-01-31T22:54:10ZThis is the accepted answer. This is the accepted answer.WEF relies upon an inbound client request to cause a model to execute. You cannot easily execute models outside of a request / session. I've worked with customers that had a similar requirement and they performed the back-end calls outside of WEF, but made the results available to WEF through a global cache that was accessed as needed by models. You may be able to do the same and leverage the J2EE timer service to run the SQL and refresh the cache.
Michael Burati 060000VQ20427 Posts
Re: Timer Event to cache data from database nightly2012-02-01T04:41:13ZThis is the accepted answer. This is the accepted answer.
- DGawron 10000054HC