Geoff wrote:
>Doesn't that limit you to a single ConnectionPool? What if you want
>multiple pools for different databases?
I have some code that builds on a rewrite of DBPool to give multiple named
pools to different databases. With the code, one uses a configuration file
to specify DB pools, connection strings, and default pools. Then, if you
want say a connection from the Oracle pool, you'd ask for it by doing conn
= GlobalPool.getConnection('<pool name>') where GlobalPool is an instance
of a class called MultiDBPool. Each pool within the global pool can be to
the same or different DB, using same or different DB modules and connection
strings.
I also rewrote DBPool a bit to properly implement the "State" pattern
(separation of implementation from public interface). I wasn't happy about
the mingling of interface and implementation in DBPool since it made it
harder than necssary to add new methods, etc.
I'd be happy to post it somewhere for possible inclusion into Webware. Is
anybody interested?
...Edmund.
_______________________________________________________________
Have big pipes? SourceForge.net is looking for download mirrors. We supply
the hardware. You get the recognition. Email Us: [EMAIL PROTECTED]
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss
