Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pool setting

 
Kapil Ojha
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic