Re: mysql/posgresql pooling

Nico wrote:
> Hi, I run a servlet that runs on a Resin 3.0.2-webserver with MySQL and
> PostgreSQL database server.
> Operating system is Red Hat Enterprise Linux ES release 3 (Taroon Update 4).
> Resin uses its own pooling mechanism. I can make normal connections through
> both MySQL and PostgreSQL. However, when I try to get a connection from a
> pool, only MySQL connections are returned. How do I tell my servlet it needs
> a PostgreSQL connection instead of MySQL?

I dunno anything about that stuff specifically, but any time you're pooling
resources, and you have different sorts of resources, it makes sense to have
different pools. In this case, it would be one pool for each database, so you
query the specific pool holding the class of resource you want....