I'm using tomcat 7, in a spring mvc application. The properties is in my
spring-context.xml file.
<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost/mydb"/>
<property name="username" value="testuser"/>
<property name="password" value="abc"/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
<property name="testOnBorrow" value="true" />
<property name="validationQuery" value="SELECT 1" />
</bean>
On Fri, Apr 6, 2012 at 2:09 PM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Daniel,
>
> On 4/4/12 8:46 AM, Daniel Mikusa wrote:
> > ----- Original Message -----
> >> My db connections seem to be lost after an extended period of
> >> inactivity (for a web application). And the only way to get the
> >> connections to work again is to restart tomcat.
> >>
> >> My tomcat.jdbc.pool.Datasource settings have:
> >>
> >> <property name="maxActive" value="100"/> <property name="maxIdle"
> >> value="30"/> <property name="maxWait" value="1000"/> <property
> >> name="defaultAutoCommit" value="true"/> <property
> >> name="removeAbandoned" value="true"/> <property
> >> name="removeAbandonedTimeout" value="60"/>
> >
> > You probably want to add testOnBorrow="true" and
> > "validationQuery=SELECT 1" (or some other valid query for your
> > DB).
>
> +1
>
> > See the following link for an explanation of those properties.
> >
> > https://commons.apache.org/dbcp/configuration.html
>
> - -1
>
> This is the wrong documentation for tomcat-pool. You're looking for
> http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
>
> On the other hand, there was no mention of a Tomcat version, what type
> of pool is actually being used (I inferred tomcat-pool from the
> subject line as well as the use of "tomcat.jdbc.pool.DataSource") and
> the use of <property> elements seems antiquated, so I must admit I'm a
> little confused.
>
> - -chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
> Comment: GPGTools - http://gpgtools.org
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAk9/MWAACgkQ9CaO5/Lv0PCcOgCeJcRA6Oq2KcVSDE6vIAmQ+5Ji
> lJUAoL4QiLp1oZSBVkiaFYTrJTlK6Gkv
> =wFzD
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
>
