Hello all,

Is it possible to map multiple tables using one class.
All the tables are having identical structure.(same columns and keys)
Only one will be present while starting the program for first time.
Others are need to be added runtime.

If possible,plz let me know how???

Thanks & Regards
Jijo Vincent

Yes, you can create several mapping files.
Then, you can create session factories mencioning the other mapping files.
Ex:
SessionFactory sessions = new Configuration()
.configure("/hibernate-config/configuration1.cfg.xml")
.buildSessionFactory();

--
If this works, rate me!

Hi,
I ve see another message in the forum talking about aliases.

take a look to Working with "entity-name"

regards.

Why do you have to create tables dynamically in fact? Is it really necessary?

Thank you for the reply.

It is a real-time application.
500 records(even more) may be entered into the table in every minute.
It will be difficult to retrieve data from the table when it is too large(say 10 million records).
So i am trying to create the table at the start of every month.

if u have any other idea plz let me know that.

Thanks & regards
Jijo Vincent

Hi,
So you use one table in which your real time results are stored and another tables in which you archive results month per month.
We have quite the same problem with statistics of use of our Knowledge mgt tool. Each year we copy (manually) data stored in the table STATS in STATS_YEARN.

I advise you not to mix actual data treatment with archived data.
Create a mapping to you actual data table, build a view in your database (that you can create dynamically, depending on the willing data (for example, if user want to see evolution from march05 to june05 or that follows the evolution of archive) and create a specific mapping of this view. The structure (columns) and the name of the dynamic view have to be immutable.


Test this proposition to see performances, try as more as possible to optimize you query (index, ...), maybe it would be easier than to map a lot of tables to 1 object.

Regards.

Thanks..

I think i am irritating u a bit...i don't mind.

is it possible to create view,index etc using hibernate for all databases it support..?

my application is not limited to a particular database(type).

Rgrds
Jijo Vincent

No you don't irritating me, I've made the choice to post an answer.

I don't know if it is possible to create a view thru Hibernate.
I think HQL is only a LMD (french abbr for Data Manipulation Language)
but by using SQL standards for Data Definition (CREATE, ALTER, etc...)
no matter the type of the database (except for MSACCESS ;-)}).
You use the connection given by your hibernate session and you work with the good old JDBC Connection to launch your queries of Data Def.

To be Tested