Hi Chris,
Thanks for reply. I had tried using "com.mysql.jdbc.Driver" as well
earlier. But no luck :(
Christopher Schultz-2 wrote:
>
> -----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: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
>
--
View this message in context:
http://old.nabble.com/Tomcat-DBCP-Connection-Pooling-to-MySQL-limited-number-of-connection-issue-in-Spring2.5-%2B-Hibernate3-%2B-commons-DBCP1.2-tp26372475p26392261.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
