Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Connection pool setting Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pool setting" Watch "Connection pool setting" New topic
Author

Connection pool setting

Kapil Ojha
Greenhorn

Joined: May 12, 2013
Posts: 1
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

Joined: Apr 22, 2009
Posts: 54
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.


Dharmendra Gahlot
SCJP-5.0 87%,SCWCD-5.0 92%
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection pool setting