An update... It actually looks like I'm getting the default values for the properties - the only properties that were used were the username and password.
Do I need to prefix the property names with anything? I'm not using JNDI / datasource, I'm using the PoolingDriver version (with GenericObjectPool, ConnectionFactory and PoolableConnectionFactory). Any help will be appreciated. Rob. -----Original Message----- From: Rob Wilson [mailto:[EMAIL PROTECTED] Sent: 22 January 2008 17:00 To: Jakarta Commons Users List Subject: RE: A way to determine pool size / Logging? Thanks for the quick reply, oddly I'm not getting the 'maxActive' value I was expecting. Doing connectionPool.getMaxActive() is returning 8 (the default), yet I have initialized it as follows... connectionPool = new GenericObjectPool(null); Properties properties = new Properties(); properties.put("user", JDBC_USER); properties.put("password", JDBC_PASSWORD); // The initial number of connections that are created when the pool is started. properties.put("initialSize", "5"); /** * The maximum number of active connections that can be allocated from this pool * at the same time, or non-positive for no limit. */ properties.put("maxActive", "15"); Any suggestions? Cheers, Rob. -----Original Message----- From: Fabrice MORIN [mailto:[EMAIL PROTECTED] Sent: 22 January 2008 16:33 To: 'Jakarta Commons Users List' Subject: RE: A way to determine pool size / Logging? You can call the methods from the DataSource class : getMaxActive() getNumActive() getNumIdle() and log the results (integer values)... FM -----Message d'origine----- De : Rob Wilson [mailto:[EMAIL PROTECTED] Envoyé : mardi 22 janvier 2008 16:40 À : Rob Wilson; [email protected] Objet : RE: A way to determine pool size / Logging? Hi all, Does DBCP log out any pool size information? If not, how can I determine how many connections are idle / active - maybe even determining how old each one is? Thanks, Rob. This message is confidential and is intended only for the named individual. If you are not the intended recipient of this message, please notify the sender immediately and delete this message from your system. The sender does not accept liability for any errors or omissions in the content of this message arising from e-mail transmission which cannot be guaranteed to be secure or error free. The contents of this message do not constitute a commitment by Best Execution. The unauthorised use, disclosure, distribution and/or copying of this e-mail or any information it contains is prohibited All messages are certified to have been scanned for viruses, using McAffee Active VirusScan. Best Execution Dowding House Coach and Horses Passage Royal Tunbridge Wells Kent TN2 5NP Tel: 01892 547 666 Web: www.Bestexecution.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This message is confidential and is intended only for the named individual. If you are not the intended recipient of this message, please notify the sender immediately and delete this message from your system. The sender does not accept liability for any errors or omissions in the content of this message arising from e-mail transmission which cannot be guaranteed to be secure or error free. The contents of this message do not constitute a commitment by Best Execution. The unauthorised use, disclosure, distribution and/or copying of this e-mail or any information it contains is prohibited All messages are certified to have been scanned for viruses, using McAffee Active VirusScan. Best Execution Dowding House Coach and Horses Passage Royal Tunbridge Wells Kent TN2 5NP Tel: 01892 547 666 Web: www.Bestexecution.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This message is confidential and is intended only for the named individual. If you are not the intended recipient of this message, please notify the sender immediately and delete this message from your system. The sender does not accept liability for any errors or omissions in the content of this message arising from e-mail transmission which cannot be guaranteed to be secure or error free. The contents of this message do not constitute a commitment by Best Execution. The unauthorised use, disclosure, distribution and/or copying of this e-mail or any information it contains is prohibited All messages are certified to have been scanned for viruses, using McAffee Active VirusScan. Best Execution Dowding House Coach and Horses Passage Royal Tunbridge Wells Kent TN2 5NP Tel: 01892 547 666 Web: www.Bestexecution.co.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
