aspose file tools*
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 JavaScript Promises Essentials this week 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%
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pool setting