I'm re-posting my ds
<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&useOldAliasMetadataBehavior=true"/>
On Wed, May 11, 2016 at 10:16 AM, Niranjan Babu Bommu <
[email protected]> wrote:
> 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&useOldAliasMetadataBehavior=true"/>
>
> On Wed, May 11, 2016 at 7:35 AM, Niranjan Babu Bommu <
> [email protected]> 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 <[email protected]> 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&useOldAliasMetadataBehavior=true"/>
>>> >
>>> >
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>>>
>>
>>
>> --
>> *Thanks*
>> *Niranjan*
>> *+1 781.956.6900 <%2B1%20781.956.6900>*
>>
>
>
>
> --
> *Thanks*
> *Niranjan*
> *+1 781.956.6900 <%2B1%20781.956.6900>*
>
--
*Thanks*
*Niranjan*
*+1 781.956.6900*
