Hi, Nico,
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?
How do you communicate with the pool? I do not know anything about the
Resin interfaces, but in jboss, you use jndi to look up your datasources
by a datasource name, and have *-ds.xml files that define the
datasources (map name to driver class, host name, port, username and
other connection properties).
To get a PostgreSQL connection, you need do deploy the appropriate
definition in one of your *-ds.xml files, and then use this name when
looking up your datasource.
You do this along the lines of:
import java.sql.Connection;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class example {
public static Connection getConnection(String name) throws Exception {
InitialContext ic = new InitialContext();
DataSource dataSource = (DataSource) ic.lookup(name);
return dataSource.getConnection();
}
}
HTH,
Markus