Connection pool setting

[Kapil Ojha]

Hi

I am using resin with jdk 1.6.

My concern is. my application using 10 to 15 connection but we are connection count as around 60.

Can you please help me why connection count is going high, do i need to change the connection pool setting for this or anything else. Below is current setting which we are using in resin.conf file.

<database>
<jndi-name>jdbc/mpaynig</jndi-name>
<driver>
<type>oracle.jdbc.pool.OracleConnectionPoolDataSource</type>
<url>jdbc:oracle:thin:@XXX.XXX.X.XXX:dummy</url>
<user>dummy</user>
<password>dummy</password>
</driver>
<prepared-statement-cache-size>8</prepared-statement-cache-size>
<max-connections>350</max-connections>
<max-idle-time>60s</max-idle-time>
<max-active-time>600s</max-active-time>
</database>

[dharmendra gahlot]

hi,

Go to JDK bin folder and launch jconsole.exe from there. You can associate your java application with jconsole and
analyse the current threads for connection uses. May be a problem of forgetting close connection in application code.
You can use checkstyle plugin in eclipse for checking code for this.