Обсуждение: Switching database inside current connection

Поиск
Список
Период
Сортировка

Switching database inside current connection

От
Jeff Madison
Дата:
I have to search multiple, identical databases on a server and am
currently having to create a DataSource for each database on the server
and then get a connection.  How would I create a DataSource for the
server and then modify the connnection to "switch" databases.  I would
like to just re-use the same connection for obvious reasons.

I'm running server version 7.3 and the coinciding JDBC driver version.

Jeff


Re: Switching database inside current connection

От
Kris Jurka
Дата:

On Wed, 27 Sep 2006, Jeff Madison wrote:

> I have to search multiple, identical databases on a server and am currently
> having to create a DataSource for each database on the server and then get a
> connection.  How would I create a DataSource for the server and then modify
> the connnection to "switch" databases.  I would like to just re-use the same
> connection for obvious reasons.

This is not possible with postgresql.  You can only use the database you
initially connected to.  To access parts of other database you can use
contrib/dblink, but for your purposes I think multiple connections are
required.

Kris Jurka

Re: Switching database inside current connection

От
Scott Marlowe
Дата:
On Wed, 2006-09-27 at 23:17, Jeff Madison wrote:
> I have to search multiple, identical databases on a server and am
> currently having to create a DataSource for each database on the server
> and then get a connection.  How would I create a DataSource for the
> server and then modify the connnection to "switch" databases.  I would
> like to just re-use the same connection for obvious reasons.
>
> I'm running server version 7.3 and the coinciding JDBC driver version.

If you can move away from individual databases to multiple schemas in
one database, then your problem would be solved.  Schema support was
initially added in 7.3, but the tools needed for examining schemas and
such were not quite done all the way back then.  Upgrading to 7.4 at
least makes dealing with schemas a little easier, and if you're
upgrading to 7.4, might as well go all the way and get 8.1.4.  7.3 is on
the very tail end of what's considered "supported".