webMethods

webMethods

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
  • 1.  JDBC Adapter Pool Problem

    Posted Wed October 05, 2005 03:16 PM

    The IS is 6.1. The JDBC Adapter is connected to an Oracle database with the following property settings: Minimum Pool Size = 5, Maximum Pool Size = 20, Pool Increment Size = 5. The Oracle database has “maximum idle time” set to 12 hours.

    During periods of low activity, one or more of the 5 connections in the pool will get automatically logged off on the Oracle side. We then get the following errors when the integrations attempt to make JDBC Adapter Service calls (ex. Select statement):
    2005-10-03 00:41:12 GMT [ART.0116.3001E] Adapter Runtime (Notification): Notification error … (61000/2396) ORA-02396: exceeded maximum idle time, please connect again.

    It appears that the JDBC Adapter Pool Manager does not gracefully handle connections that may have been logged off on the Oracle side. It still attempts to use these “stale” connections. Is this normal or is it a bug? Are there configuration properties that can be set to get around this?

    Thanks,
    Jay


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


  • 2.  RE: JDBC Adapter Pool Problem

    Posted Wed October 05, 2005 04:11 PM

    Hi Jay:
    What you didn’t mention was the parameters for block and expiring timeout values. For more details Refer to advantage article

    [url=“http://advantage.webmethods.com/cgi-bin/advantage/main.jsp?w=0&targChanId=knowledgebase&oid=1611541996”]http://advantage.webmethods.com/cgi-bin/advantage/main.jsp?w=0&targChanId=knowledgebase&oid=1611541996[/url]

    We are on version 6.5 but when we were on version 6.1 we were running all Minimum Pool Sizes = 0 without problem.
    HTHs


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


  • 3.  RE: JDBC Adapter Pool Problem

    Posted Wed October 05, 2005 04:16 PM

    Block Timeout (msec) = 1000
    Expire Timeout (msec) = 1000
    Startup Retry Count = 0
    Startup Backoff Timeout (sec) = 10


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


  • 4.  RE: JDBC Adapter Pool Problem

    Posted Wed October 05, 2005 04:25 PM

    “During periods of low activity, one or more of the 5 connections in the pool will get automatically logged off on the Oracle side. We then get the following errors…”

    As Randy pointed out, the trick to avoiding stale connections is to set the minimum pool size to 0. There is usually no need for keeping connections open during idle times.


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