Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
Switching database inside current connection
- From: Jeff Madison <jeff(at)madisonfam(dot)net>
- To: pgsql-jdbc(at)postgresql(dot)org
- Subject: Switching database inside current connection
- Date: Wed, 27 Sep 2006 22:17:18 -0600
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
- Follow-Ups:
- Re: Switching database inside current connection
- From: Scott Marlowe
- Re: Switching database inside current connection
- From: Kris Jurka
- Re: Switching database inside current connection
- Prev by Date: Re: Storing and retreiving infinity timestamp values from
- Next by Date: Re: Switching database inside current connection
- Previous by thread: Storing and retreiving infinity timestamp values from postgres database
- Next by thread: Re: Switching database inside current connection
- Indexes: