The properties apply to JDBC connections, not the pool. You need to set the properties on the pool directly, i.e. connectionPool.setXxx
Phil On 1/22/08, Rob Wilson <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
