Hi.
We are using webMethods jdbc v6.0.2. adapters to connect to as/400’s. These adapter connections seem to drop their connection occasionally and we don’t know why. If we look at the adapter on the JDBC adapter web page it shows as enabled. To solve the problem we disable and then re-enable the connection. Is there a patch or service pack for this ?
Regards,
Wayne
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.