1 2 Previous Next 17 Replies Latest reply on Sep 4, 2008 5:41 AM by dnolte

    No ManagedConnections available within configured blocking t

    udayn

      Hi,
      We are using jboss 4.0.3 server.
      Oracle 9I is the DB.
      The app server was working fine , but from last month it has started going down. The server is shutting down after evrey 5-6 days because of following error.
      org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))

      There is no regular pattern for occurence of these errors. After 3-4 such failuers the server goes down. We have tried following modifications in oracle-ds.xml
      1) Incresing the min and max connection Pool Size for data source.
      <min-pool-size>50</min-pool-size>
      <max-pool-size>75</max-pool-size>

      2) Reduce idle time out from 20 to 10
      <idle-timeout-minutes>10</idle-timeout-minutes>

      3) Incresing the <blocking timeout from default 30000 <blocking-timeout-millis>50000</blocking-timeout-millis>

      What we have not tried is
      1) Incraesing the therad pool size in server.xml? Will that help??

      2) Adding minSpareThreads and maxSpareThreads paramtere? Will that help??

      Has anyone face the similar problem?
      Is there any other configaration parameter which we are missing??
      Is there any specific reason for this problem??

        1 2 Previous Next