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

  • 1.  Maximum Pool Size parameter in JDBC connection

    Posted Tue April 05, 2011 08:34 AM

    Hi,

    Is there any way to determine the maximum number of pool size has been reached for a JDBC adapter connection while executing the scheduled flow services?

    Thanks and Regards,
    Shriraksha A N


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Maximum Pool Size parameter in JDBC connection

    Posted Tue April 05, 2011 09:30 AM

    Well, if you will monitor server logs you will see messages like “no resources available to run this schedule task” … same will be updated in last run status of scheduled task.


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Maximum Pool Size parameter in JDBC connection

    Posted Tue April 05, 2011 10:34 AM

    Hi Shriraksha,

    We can generally get the statistics of a JDBC adapters using the service
    WMART\pub.art.connection:getConnectionStatistics and provide the input value as adapter service which do you want to monitor it. you can implement the logic for getting notification before reaches to maximum pool. if I am wrong can you suggest me

    Regards,
    Jeevan_mjk


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 4.  RE: Maximum Pool Size parameter in JDBC connection

    Posted Wed April 06, 2011 05:34 AM

    Thanks for the response…

    Regards,
    Shriraksha A N


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


Related Content