There's no way to do this just in the URL. There's been patches submitted to add this[1], but there have been some objections. I don't quite understand what you are trying to do, but if you have access to the connection after it's created and before it's used, you can execute "set search_path" for the session.
[1]: Most recent I found is discussed here:
http://archives.postgresql.org/pgsql-jdbc/2008-07/msg00012.php---
Maciek Sakrejda | Software Engineer | Truviso
1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3501 F
www.truviso.comOn Fri, Jan 29, 2010 at 6:40 PM, Sven Hafner
<sven.hafner@gmx.de> wrote:
Hi !
Asked the same question previously in the Glassfish forum, but I dont get it to work. Not sure if it is a GF or postgres jdbc issue/feature.
Can I use the schema in the jdbc URL ?
My GF mailing-list question for reference:
I create a connection pool and connection pointing to a PostgreSQL DB.
Is there a way to point to a specific schema inside the DB (like a schema parameter) ? I need to avoid a schema annotation inside the EJB code, so I can point several instances of the same application (but different PU pointing to different jndi jdbc resource)
to different schemes in the same postgres instance.
Glassfish V3 and PostgreSQL 8.4
postgresql-8.4-701.jdbc3.jar
Thanks for input
Sven
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc