Hello everyone;

We are currently developing applications using Hibernate3. We have an old application written on Java, which will be developed from scratch.

This application provides some financial portal features for users. If a user sign-on, application creates a new schema on database side for storing all information about this user data's. In old way (with JDBC), all this stuff is done manually with queries, but it's really horrible to read that code, so we want to use Hibernate for database abstraction.

I have read that i can load Hibernate configuration's on SessionFactory on-the-fly. But my question is "Can I create schema's on-the-fly".

Case Example:
A users log-on to the system, creates a portal, and then i will create the appropriate schema for this user dynamiclly. I have searched for this kind of operation at Google, but no results.

Thanks in advance for your response;

Sing.

Configuration class have methods called : generateDropSchemaScript, generateSchemaCreationScript and generateSchemaUpdateScript

They give ddl revelant to configuration files that you gave to the configuration class. If you want to be more low level you can also use hibernate objects for Table, Column, Keys, ... we use them in our application to generate update scripts.