Hi Sven,
I believe most JDBC drivers support a property called 'schema' that you
can add to your other jdbc properties (user, password, url, etc.).
So for each jdbc resource you'd create a separate JDBC connection pool,
each with a different value for this property.
Hope that helps,
Dies
On 28/01/2010 12:51, Sven Hafner wrote:
> Hi !
>
> 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
>
> Thanks for input
> Sven
>