users@glassfish.java.net

How to address specific PostgreSQL Schema in Glassfish ?

From: Sven Hafner <sven.hafner_at_gmx.de>
Date: Thu, 28 Jan 2010 09:51:22 +0800

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