IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Check JDBC Connections status

    Posted 05/26/20 06:34 AM

    Goodmorning everyone!
    In the IT system in which we are configuring webMethods IS, there is a server with an Oracle Database to which IS must connect. Sometimes the Oracle Database does not respond for a long time, and we have to enable the connection from the IS administration page.
    Is there a way to check through a scheduled flow if the connection is enabled?


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Check JDBC Connections status

    Posted 05/26/20 02:36 PM

    Hi Diego,

    There is a service, pub.art.connection:queryConnectionState, which returns the connection state, error (if it exists) and last error time. This is version 8.2.

    Thanks,
    Mary


    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Check JDBC Connections status

    Posted 05/27/20 12:56 PM

    Hi Diego,

    Yes as Mary mentioned above you can look in WmArt package connection* services to be able to access the connection metadata to check its (enable/disable) status programmatically doable with run-time aspect… Please explore and try it out.

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Check JDBC Connections status

    Posted 05/27/20 01:33 PM

    thanks, it works! I hadn’t seen the service


    #webMethods
    #Integration-Server-and-ESB