Re: tomcat(7.0.56) is not releasing idle jdbc connections

[Niranjan Babu Bommu]

I tried the same config on test stacks. numidle always "10" why it is
behaving differently in prod?

<Resource name="jdbc/DS"
          auth="Container"
          type="javax.sql.DataSource"
          testWhileIdle="true"
          testOnBorrow="true"
          testOnReturn="false"
          fairQueue="false"
          validationQuery="SELECT 1"
          validationInterval="30000"
          timeBetweenEvictionRunsMillis="30000"
          maxActive="100"
          maxIdle="10"
          minIdle="10"
          maxWait="10000"
          initialSize="10"
          removeAbandonedTimeout="60"
          removeAbandoned="true"
          logAbandoned="true"
          minEvictableIdleTimeMillis="300000"
          jmxEnabled="true"

jdbcInterceptors="ConnectionState;StatementFinalizer;ResetAbandonedTimer"
          username="<user>"
          password="<password>"
          driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://<DBservername>/<schema>?useServerPrepStmts=false&amp;useOldAliasMetadataBehavior=true"/>

On Wed, May 11, 2016 at 7:35 AM, Niranjan Babu Bommu <
niranjan.bo...@gmail.com> wrote:

> Hi Mark
> I have included defined data source in this mail, do you want me to
> include complete server.xml?
>
> thanks
> Niranjan
>
> On Wed, May 11, 2016 at 7:19 AM, Mark Thomas <ma...@apache.org> wrote:
>
>> On 11/05/2016 11:58, Niranjan Babu Bommu wrote:
>> > Hi,
>> >
>> > we are migrating prod servers to tomcat, since we are doing it slowly we
>> > have found an issue in jdbc connection pool, tomcat is not releasing
>> idle
>> > jdbc connections, even we have tried setting maxIdle="10" but "NumIdle
>> 97"
>> > always. due to this threads are piling up in database.
>> >
>> > I'm including my config here, can someone please help me out, how to
>> > minimize idle jdbc connections.
>>
>> Where have you added the configuration below?
>>
>> Mark
>>
>>
>> >
>> > <Resource name="jdbc/DS"
>> >           auth="Container"
>> >           type="javax.sql.DataSource"
>> >           testWhileIdle="true"
>> >           testOnBorrow="true"
>> >           testOnReturn="false"
>> >           fairQueue="false"
>> >           validationQuery="SELECT 1"
>> >           validationInterval="30000"
>> >           timeBetweenEvictionRunsMillis="30000"
>> >           maxActive="100"
>> >           maxIdle="10"
>> >           minIdle="10"
>> >           maxWait="10000"
>> >           initialSize="10"
>> >           removeAbandonedTimeout="60"
>> >           removeAbandoned="true"
>> >           logAbandoned="true"
>> >           minEvictableIdleTimeMillis="300000"
>> >           jmxEnabled="true"
>> >
>> >
>> jdbcInterceptors="ConnectionState;StatementFinalizer;ResetAbandonedTimer"
>> >           username="<user>"
>> >           password="<password>"
>> >           driverClassName="com.mysql.jdbc.Driver"
>> >
>> >
>> url="jdbc:mysql://<DBservername>/<schema>?useServerPrepStmts=false&amp;useOldAliasMetadataBehavior=true"/>
>> >
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>
>>
>
>
> --
> *Thanks*
> *Niranjan*
> *+1 781.956.6900 <%2B1%20781.956.6900>*
>



-- 
*Thanks*
*Niranjan*
*+1 781.956.6900*