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> ******************************************************* View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843243#3843243 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843243 ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
