Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0004664 [Resin] minor always 07-08-11 15:05 10-07-11 11:55
Reporter rickHigh View Status public  
Assigned To ferg
Priority normal Resolution fixed  
Status closed   Product Version
Summary 0004664: Add minium database connection pool size to handle bursts for bursty applications
Description Notes sent to customer:

Regarding your question around Oracle pooling and connections and your comments about how long it takes to create an Oracle connection and the burst nature of your application, we decided to add a minimum pool size feature. Current our DB pool has a max connection pool size, but not a minimum connection pool size. This will be in release 4.0.20 or 4.0.21.

Currently, we create a connection if it does not exist when you call dataSource.getConnection(), and again you seemed concerned that this is an expensive operation and it might be happening too often.


Until we add the minimum pool feature, note that the connection stays around until it times out based on max-idle-time. If you feel that the system is creating connection too often to Oracle and you want to reuse connections from burst to burst, just set the max-idle-time to a much higher value (24 hours) as it defaults to 30 seconds (you also want to bump up max-pool-time and max-active-time to be several factors of max-idle-time, i.e., 48 hours and 72 hours).

Since the connection is going to be around a lot longer, you may want to setup a ping on it so you can verify it stays alive. [^]
Additional Information
Attached Files

- Relationships

- Notes
10-07-11 11:55


- Issue History
Date Modified Username Field Change
07-08-11 15:05 rickHigh New Issue
09-01-11 11:51 ferg Project Quercus => Resin
10-07-11 11:55 ferg Note Added: 0005551
10-07-11 11:55 ferg Assigned To  => ferg
10-07-11 11:55 ferg Status new => closed
10-07-11 11:55 ferg Resolution open => fixed
10-07-11 11:55 ferg Fixed in Version  => 4.0.24

Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker