Hello, I have this scenary:

I'm developing an application for a wear store, they have the articles divided in sesasons, so there is a table for the articles of summer of 2008, winter 2008 and so on.

There are one table for each season and years, i.e. S08_ARTICLES, W08_ARTICLES, S09_ARTICLES...

When the user login in the application selects wich sseason want to use, so all the seasons must be available, and can be two users using the application and each one with one diferent season.

I like to use it with Hibernate, I have a class Article mapped to S08_ARTICLES, but my DAO use handcoded SQL for set the table name.

Is it possible to map this tables to the same class and that the DAO use the correct table depending on the season selected by the user? the season is stored in session, so I could pass it to the DAO methods.

Many thanks in advance and sorry for my poor english.

Hope next chapter will help you.
http://www.hibernate.org/hib_docs/refer ... tance.html

Yes, it is possible to map the same class to multiple tables. There is an example in the Hibernate documentation: http://www.hibernate.org/hib_docs/v3/re ... entityname

In your case you would map something like this:




In your code you need to use the entity-name:s instead of the class name when loading articles.

Eg.

session.get("S08Article", id)

instead of

session.get(Article.class, id)

Thanks nordborg. That's just what I was looking for.