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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Maximum Pool Size parameter in JDBC connection

    Posted 04/05/11 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 04/05/11 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 04/05/11 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 04/06/11 05:34 AM

    Thanks for the response…

    Regards,
    Shriraksha A N


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