Обсуждение: Is there a schema parameter for the jdbc URL ?

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

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

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
>
>