Check JDBC Connections status

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?

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

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

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