I'd use query.setCacheStrategy(..) / query.setCacheGroups(..) to cache the results, and then define expiration time for a given set of cache groups for whatever cache provider is in use (EhCache most likely, so this will go into ehcache.xml).
If you want real-time refresh, EhCache might be configured to listen to cache group refresh events via JMS. Your external process would send such events via ActiveMQ (that supports a bunch of command-line friendly protocols, not just JMS) whenever the data is changed. Andrus On May 15, 2013, at 4:28 PM, Markus Reich <markus.re...@markusreich.at> wrote: > Hi, > > is there really no better way than described here: > http://markmail.org/message/plnaj4zj4gxrt6hk > > regards > Meex
