Hello,
We have an unique situation. We have adentical tables under diffrent schemas. We have a schema for each customer. When a message arrives from a customer, depending on the messge origin (customer) we store the message in the appropriate table in the appropriate schema belonging to the customer.

I tried the following:
Configuration cfg = this.sessionFactoryBean.getConfiguration();
PersistentClass pc = cfg.getClassMapping("com.vibes.aggregator.service.routing.model.MtShortMessage");

Table table = pc.getTable();
table.setSchema("client_11");

getHibernateTemplate().merge (mtShortMessage);

But, every time I do this the data gets saved in the original schma.

Any help would be appreciated!


Thanks
Matt

you have to recreate the SessionFactory for those changes to be take effect. You can't change it on the fly.

Might wanna use 2 session factories, one for each schema, and just pick and choose as needed.

Hi Chris,
I need something more dynamic than this. I am looking for something equivalnt to,

For customer_1
select * from customer_1.messages

For Customer_1
select * from customer_2.messages

Where customer_1 and customer_2 are postgress schemas and messages being idenitical tables in two different schemas.

In our system the customer base is very dynamic!

Any help will be appreciated!

Thanks
Matt