Skip site navigation (1) Skip section navigation (2)

Re: mysql/posgresql pooling

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Nico <nicohmail-postgresql(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: mysql/posgresql pooling
Date: 2005-05-03 17:43:39
Message-ID: 4277B84B.1040301@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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....


In response to

pgsql-jdbc by date

Next:From: sunil sunsunwalDate: 2005-05-04 06:22:26
Subject: Connectivity of postgreSQL database to a JSP page
Previous:From: Markus SchaberDate: 2005-05-03 17:13:50
Subject: Re: mysql/posgresql pooling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group