On Sun, 18 Mar 2001, Bill Burke wrote:
> 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.
The factory is configurable, so the only change you'd need to make
is to add an appropriate method to the MBean that instantiates the
factory. The source code for the MBean is maintained in JBoss.
Aaron
> 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
