-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Yagnesh,
On 11/17/2009 12:32 AM, Yagnesh Chawda wrote:
> Thanks Chris, That was just a typo. Thanks for pointing it out. But in real
> configuration was was not commented. It was some other config which I was
> trying and forgot to uncomment it in posting.
Ok.
> <bean id="dataSource" destroy-method="close"
> class="org.apache.commons.dbcp.BasicDataSource">
> <property name="driverClassName"
> value="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"/>
> <property name="url" value="${db.url}"/>
> <property name="username" value="${db.user}"/>
> <property name="password" value="${db.pass}"/>
> <property name="initialSize" value="40"/>
> <property name="minIdle" value="35"/>
> <property name="maxActive" value="95"/>
> <property name="maxWait" value="20000"/>
> </bean>
I find it unusual that you'd be using a DataSource as the driver class
name. Typically, for MySQL, you'd use com.mysql.jdbc.Driver as the class
name, not the MySQL-supplied DataSource as the driver class name.
Other than that, I would expect your connection pool to always have a
minimum of 35 connections sitting idle in it, even when your site was
seeing no traffic.
I wonder if the problem is that you appear to be using two data sources
instead of one data source and one JDBC driver.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAksCvlgACgkQ9CaO5/Lv0PCNRQCgwqSmsc1EUj7aCxh1hGhGjImC
7IIAnjC4PQCrSepnOuMUvAcAIAQy8Kia
=8Fl9
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
