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.

 View Only
Expand all | Collapse all

jdbc v6.0.2. adapter loses connection

  • 1.  jdbc v6.0.2. adapter loses connection

    Posted Thu August 26, 2004 09:14 AM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: jdbc v6.0.2. adapter loses connection

    Posted Thu August 26, 2004 05:02 PM

    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