Aaron, You're the author of the Minerva stuff correct? Am I missing something or is PSCacheSize not configurable from jboss.jcml? I intend to implement this if it is not already implemented in source safe. BTW, how does one submit changes to minerva source? It doesn't seem to be maintained by the jboss group anymore. One more thing. Their is an ObjectCache for PreparedStatements for each connection. This is just an idea, but IMHO,I think it may be better to be able to configure the max PreparedStatements cached for all open connections rather than setting the max per connection. So, if your db has a limit of 100 open cursors and you have set up a connection pool of 10 connections, a connection is not limited to 10 cache prepared statements, but can rather grow up to 100 cached statements using the LRU algorithm to bump out old cached statements from different connections. I'm also wondering if there is a possible bug waiting to happen in the Minerva stuff as well. Let's say your DB has a limit of 10 open cursors and 10 PreparedStatements are cached. I'm very ignorant on DB configuration, but if some piece of code creates and tries to execute on a regular Statement, won't it fail because the cached Prepared Statements are holding onto all the open cursors? This is where managing the max PreparedStatements over all connections becomes handy as well. If you are executing that same regular Statement again, and that Statement's connection has not cached any PreparedStatements, but a different connection or connections has the max cached PreparedStatements, you can run into the problem again. If it's ok, I intend to implement and test some of these above ideas. Let me know what you think. Best Regards, Bill Burke _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
