Bill Burke wrote: > 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. > Sorry, I'm stupid.....I just read that maximum open cursors apply to each connection rather than for all connections. I told you I was ignorant about DB configuration :-) Bill _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
