1 Reply Latest reply on Sep 9, 2016 6:40 AM by Panagiotis Chavariotis

    JBOSS Console Datasources didn't show usage.

    Ted Liu Newbie

      Hi,

       

      I am using JBOSS EAP6.1.1.GA.

      Recently we are getting error: No managed connections available within configured blocking timeout (30000 [ms]) .

       

      After I check the datasource pools in my JBOSS console, it doesn't show percentage in active count and max used:

       

      The normal servers show like:

       

      The issue can be solved after restart. But it's our production server, I want to know if there is any other way to solve this.  I don't think it's the max-pool problem, since as you can see in the console, there are still available pools for the servers.

       

      Our datasource config:

      <datasources>

                      <datasource jta="false" jndi-name="java:jboss/DataSource" pool-name="DataSource" enabled="true" use-ccm="false">

                          <connection-url>jdbc:sqlserver://<sqlserverurl></connection-url>

                          <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                          <driver>sqlserver</driver>

                          <security>

                              <user-name>username</user-name>

                              <password>password</password>

                          </security>

        <connection-property name="sendStringParametersAsUnicode">false</connection-property>

                          <validation>

                              <validate-on-match>false</validate-on-match>

                              <background-validation>false</background-validation>

                          </validation>

                          <statement>

                              <share-prepared-statements>false</share-prepared-statements>

                          </statement>

                      </datasource>

                      <drivers>

                          <driver name="sqlserver" module="com.microsoft">

                              <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

                          </driver>

                      </drivers>

                  </datasources>