Re: Is there a schema parameter for the jdbc URL ?

Thanks
I came across the same old post (which goes back as far as 2002..)
I use the search_path feature as well.

Scenario A:
2 web applications using the same EJB (which has a fix user to access
the DB) want to access same db instance but different schema,
like 2 customer use 2 instances of same webapp sharing DB (split in 2
schema)
(using different jndi/jdbc names could access different schema)

Scenario B:
for a major DB migration could keep the old tables online in schema 1
and migrate data into schema 2. could easily fall back if migration
fails (just by pointing jndi names forth and back)

Sven

Maciek Sakrejda wrote:
> 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.com <http://www.truviso.com>
>
>
> On Fri, Jan 29, 2010 at 6:40 PM, Sven Hafner <sven.hafner@gmx.de
> <mailto: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
>     <mailto:pgsql-jdbc@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-jdbc
>
>