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(dot)hafner(at)gmx(dot)de
> <mailto:sven(dot)hafner(at)gmx(dot)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(at)postgresql(dot)org
> <mailto:pgsql-jdbc(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>