File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Oracle10g implicit caching with jdbc - cache only grows? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle10g implicit caching with jdbc - cache only grows?" Watch "Oracle10g implicit caching with jdbc - cache only grows?" New topic
Author

Oracle10g implicit caching with jdbc - cache only grows?

Yuriy Zilbergleyt
Ranch Hand

Joined: Dec 13, 2004
Posts: 429
Hi,

Does the implicit cache of Oracle's 10g drivers (using ojdbc14.jar) ever release unused connections? For example, we set the MinLimit property in the OracleDataSource to 15 and the MaxLimit to 40. Already opened connections get reused as expected, and when they're not enough new ones are opened. However, once the load on the application dies down, the number of connections never decreases back down to the MinLimit. If 40 connections are opened, all 40 remain until the application shuts down. Are we supposed to call the OracleConnectionCacheManager.purgeCache() method to free up unused connections at regular intervals? That doesn't seem right....

Thank you,
Yuriy
[ June 25, 2007: Message edited by: Yuriy Zilbergleyt ]
 
wood burning stoves
 
subject: Oracle10g implicit caching with jdbc - cache only grows?
 
Similar Threads
Does ojdbc14.jar compatible with oracle9i
ojdbc14.jar connection pool cache issue
How to open a connection pool to a database?
Help with OracleConnectionCacheImpl
Query regarditng Connection Pooling