4 Replies Latest reply on Feb 13, 2014 8:19 AM by Khalid Hussain

    No ManagedConnections available within configured blocking timeout in Jboss 4.0.1 sp1

    Khalid Hussain Newbie

      Hi,

       

      I have replied to a post based on the same question with my query, have the problems with connection pool, using Jboss AS 4.0.1 sp1, jdk 1.4, sql server 2005 on a legacy application. No. of users have also grown recently and so has increase the max pool size from 200/300 to the current one.

      The net result is my application gets extremely slow and unable to process any request and ultimately i restarts the JBoss AS to get application available for end users and things move on. DS details are below. Please suggest any solution to this.

       

      <?xml version="1.0" encoding="UTF-8"?>

      <datasources>

        <local-tx-datasource>

        <jndi-name>MYDS</jndi-name>

        <connection-url>

        jdbc:sqlserver://serverurl:Port;DatabaseName=MYDB;SelectMethod=cursor

        </connection-url>

        <driver-class>

        com.microsoft.sqlserver.jdbc.SQLServerDriver

        </driver-class>

        <user-name>***</user-name>

        <password>***</password>

        <min-pool-size>50</min-pool-size>

        <max-pool-size>550</max-pool-size>

        <query-timeout>60</query-timeout>

        <blocking-timeout-millis>60000</blocking-timeout-millis>

        <idle-timeout-minutes>1</idle-timeout-minutes>

        <metadata>

        <type-mapping>MS SQLSERVER2000</type-mapping>

        </metadata>

        </local-tx-datasource>

      </datasources>