This topic has been locked.
3 replies Latest Post - 2012-02-01T04:41:13Z by mburati
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 mburati
SystemAdmin 110000D4XK1493 Posts
DGawron 10000054HC76 PostsACCEPTED ANSWER
Re: Timer Event to cache data from database nightly2012-01-31T22:54:10Z in response to EJWWEF 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.
mburati 060000VQ20423 PostsACCEPTED ANSWER
Re: Timer Event to cache data from database nightly2012-02-01T04:41:13Z in response to DGawronThe following WebSphere Scheduler Service doc may help you find more about mechanisms that could help you accomplish what Tom/Dave appear to be recommending: