Check JDBC Connections status

,
1

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?

2

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

3

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

4

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