Hi there,

I am using Hibernate with PostgreSQL 8.0 and want to achieve the following:

In my web application I want to use a different postgre schema for every new customer. I then use a different SessionFactory for every schema setting the hibernate.default_schema property. Do you think this is agood approach or is there a way to do this with one SessionFactory?

sadly hibernate's hbm2ddl (set to 'create') doesn't create the schemas automatically. as a workaround I now open a jdbc connection "by-hand" and create the schema with an SQL statement. it would just be nice to have hibernate do it. does anyone know how to accomplish this?

thx

max

Hello you can set Hibernate properites by hand. I think in the reference there is an example.
You will probably need an Factory around your standard HibernateSessionFactory providing the SchemaHibernateSessionFactory.

Have a look in the Schema generation source. It is probably a simple fix.

Regards Sebastian

thx for your help,

what i am actually doing is creating a new SessionFactory for each schema and organize the whole thing in a HashMap<String, SessionFactory>.
I wrote a method in a Singleton class that adds new SessionFactories to the HashMap.
Then I request a session from by getting the SessionFactory from the HashMap and requesting openSession() on the selected SessionFactory.

What do you think of this approach?

I think hacking the schema creation code is a bit too much for me at my current knowledge of Hibernate. If anyone else is able to it and will give a helping hand as much as I can.

Cheers

Max

another thing I just found out that relates to the topic:

if you use numbers (e.g. "123") for your schemas then hbm2ddl doesn't do anything (e.g. creating sequences or tabels).

sadly this isn't related to not creating the schema itself as mentioned above which isn't working with a alphanumerical string (e.g. "abc") as well.

just wanted to let you(whoever may read it) know.

cheers

max