Same table different schemas

oneway · **Joined:** Sun Sep 14, 2003 10:54 am **Posts:** 36

Hi,

Have the same table (same name, structure, etc) that is located in different PostgreSql schemas. E.g.:

Code:

schema1.CUSTOMER
schema2.CUSTOMER

Currently, the HB mapping of Customer.class is points to schema1. At runtime I'd like somehow to change against which schema the action is run. Any ideas?

Thanks

emmanuel · **Posted:** Sat Mar 06, 2004 12:17 pm

hibernate.default_schema
and
http://www.hibernate.org/171.html

joa23 · **Joined:** Tue Mar 09, 2004 9:17 am **Posts:** 12

emmanuel wrote:

hibernate.default_schema
and
http://www.hibernate.org/171.html

Thanks I allready had seen this, since i have multiple schemas in my oracle where my tables are distributed i cant use the default_schema solution. So i'm really need to know the java api to set the schema.

The 171.html page do not give any details about the api and i found no matching method in the javadoc as well.

Stefan

emmanuel · **Posted:** Mon Mar 29, 2004 7:36 am

There is no API except the one that can provide the configuration (Properties, DOM etc...)