wood burning stoves 2.0*
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
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
 
Similar Threads
fail over in jdc URL
Problem with database connection pooling resin+mysqlw
Jboss connection pool not releasing the connection from pool
Resin DB-pooling + authentication. HELP!
How to configure connection autocommit=false?