"Waldhoff, Rodney" wrote:
> In any event, I have a demonstrated need for a connection pooling library
> that supports (in addition to the basic configurable connection pooling, of
> course):
>
> a) PreparedStatement pooling
>
> b) a pseudo-Driver interface
>
> c) a DataSource interface
The hottest button on the Struts list seemed to be "connection
collection", and I see this implementation does do this. This means when
used on a multi-application server, it will play nice, and release
connections it is not actively using (so someone else can connection to
the DBMS instead).
I imagine it is also able to instantiate multiple pools with various
logins, so that you could create a connection pool to another DBMS, or a
pool with different access rights, et cetera.
> i. Do others find this to be a reasonable starting point?
+0 = Looks good, but I need to try and hook this up to a test
application of my own. I'd also like to try it with Morgan's JDBC
taglib. Any quickstart instructions on hooking it up to Struts?
> ii. How should this be packaged?
I'd say < org.apache.common.DBCP > for now.
> iii. What's next? If others have mods they'd like to suggest, I could
> update the JAR directly, or move it all to some Apache CVS or to SourceForge
> for the time being.
If you can coordinate any patches, let's see if we can work around
putting it in a CVS until the vote goes through, then hopefully we can
put it in our own ;-)
Let's not forget how Apache got it's name ;-)
-Ted.
