0 Replies Latest reply on Jul 26, 2004 6:07 AM by Prasad Kavuri

    Unable to get the connection from pool and server hangup ...

    Prasad Kavuri Newbie

      Dear all,

      We are using mysql database on Linux. We are intermittently getting a problem that is 'Unable to get the connction from Pool'. Whenever the application trying to get a connection from pool the following message appearing and server hangup. The only thing is we have to restart the server. If any one already faced this problem then please help us. Thanks in advance.

      2004-07-26 14:15:36,802 TRACE [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Getting connection from pool [InUse/Available/Max]: [2/8/1000]

      And our DS configuration is :

      *******************************************************
      <local-tx-datasource>
      <jndi-name>EtudDS</jndi-name>

      <connection-url>jdbc:mysql://localhost:3306/etud</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>hisham</user-name>
      mlsbMLSB

      <!-- pooling enhancement -->
      <blocking-timeout-millis>5000</blocking-timeout-millis>
      <idle-timeout-minutes>1</idle-timeout-minutes>
      <min-pool-size>10</min-pool-size>
      <max-pool-size>1000</max-pool-size>

      <!-- MySQL specific enhancement -->
      <connection-property name="autoReconnect">true</connection-property>
      <connection-property name="autoReconnectForPools">true</connection-property>
      <connection-property name="useNewIO">true</connection-property>

      <!-- cache properties -->
      <connection-property name="cachePrepStmts">true</connection-property>
      <connection-property name="prepStmtCacheSize">100</connection-property>
      <connection-property name="prepStmtCacheSqlLimit">500</connection-property>

      <connection-property name="cacheCallableStmts">true</connection-property>
      <connection-property name="callableStmtCacheSize">300</connection-property>

      <connection-property name="cacheResultSetMetadata">true</connection-property>
      <connection-property name="metaDataCacheSize">200</connection-property>

      <!-- logging for slow queries -->
      <connection-property name="logSlowQueries">true</connection-property>
      <connection-property name="explainSlowQueries">true</connection-property>

      </local-tx-datasource>

      *******************************************************