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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

JDBC Adapter services dont always work

  • 1.  JDBC Adapter services dont always work

    Posted Fri February 20, 2004 09:09 PM

    My JDBC adapter services seem to loose their ability to run if they are not used for a couple days. However, if I go and change anything with the adapter and save it, then they work again.

    My solution has been to schedule services that run a basic query every 2 minutes to keep connections alive. This is all right for now with only about 10 running integrations, but in the future this will be a major hassle.
    Is something not configured correctly? Pools, cache, stateless,TNSNAMES ???


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


  • 2.  RE: JDBC Adapter services dont always work

    Posted Mon February 23, 2004 04:24 PM

    By the way, I am running version 6.01.
    Has this been improved in later releases?


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


  • 3.  RE: JDBC Adapter services dont always work

    Posted Mon February 23, 2004 04:49 PM

    I’m new to webMethods but I also spotted this behaviour:

    If you stop\start the database, the connection is also lost. I wander if the Integration server hasn’t the ability to check if the connection is lost and restart another one (connection pooling)?


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