switching db's on the fly

From: Toby Doig <toby(at)paperjet(dot)com>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: switching db's on the fly
Date: 2002-07-03 12:12:12
Message-ID: 20020703130542.U83230-100000@plum.flirble.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

after connecting to a db under pg 7.2.x using the url, is it possible to
switch to another db hosted on the same machine without reconnecting?

i have a setup with several databases all hosted on the same server with
the same db owner etc. i've written my own pooling but then i need to pool
for each db which, given the number of db's, means i end up with a lot of
idle connections using resources.

what would be better is to be able to switch to the appropriate db
when the connection is retrieved from the pool. this then pools
connections between db's as well. i understand there's some mgmt involved
with access to the db on a switch, but i believe this is easily managed.

under mssql server you can use the USE <database> command.
Is there some equivalent or some hack possible?

toby

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Th Templ 2002-07-03 12:51:42 Problem with accentuated characters
Previous Message Toby Doig 2002-07-03 09:59:47 Re: Servlet uplad with Multipart and LO