Occassionally, the JDBC adapter connection will become “stale”. This is usually b/c of either inactivity, or the connected system is restarted. To fix the problem, you should schedule a service to bounce the adapter nightly. You can schedule this by using the following service:
wm.art.admin.connection:setResourceState
Setting the connectionState value to “disabled”, then to “enabled” will accomplish this.
#webMethods#Adapters-and-E-Standards#Integration-Server-and-ESB