webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

cache DB data on service startup

  • 1.  cache DB data on service startup

    Posted Wed November 30, 2016 07:49 AM

    Hi, hope this is the right spot!

    I am newish to webMethods IS and I would like to cache some data in my flow service from the Database so I don’t have to go and read it every time. Basically a one off call to the DB table to store some configuration/environment information.

    I’m using webMethods IS version 9.8.

    Has anyone done this and able to give an example or point me to some documentation?

    Thanks

    John


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: cache DB data on service startup

    Posted Wed November 30, 2016 09:01 AM

    Hi John,

    you can use the properties of the service to define caching.

    Make sure, that you call the service either as transformer or define the appropriate scope for the service.
    Otherwise the caching is not working correctly as the key for the caching is the pipeling being present at the time when the caching service is invoked.

    See Working-With-Designer Guide as well as Service-Development-Help for further informations.

    Regards,
    Holger


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: cache DB data on service startup

    Posted Wed November 30, 2016 11:09 AM

    Additionally you can also leverage the feature of EhCache and Terracotta capabilities for putting and getting from cache eliminating DB reads and writes which increases performance and cluster aware.


    #Integration-Server-and-ESB
    #webMethods-General
    #webMethods