Hibernate version: 1.2.0.3001

Name and version of the database you are using:
10g Enterprise Edition Release 10.2.0.1.0

Hi,

I have an Order class (a hierarchy of subclasses) and a corresponding hbm FILE that describes the mapping for this class (and related subclasses).

I have an archive db and I trasnfer the orders that are closed every month in the corresponding monthly archive table ORDER_YYYYMM.
ORDER_YYYYMM tables have exactly the same structure as the original ORDER table.
These archive records are no longer modified (= readonly/immutable)

Now I want to reuse the Order class and hbm when loading archive Order entities.

Lets say I know I will load Orders for 200707. Is there any way to notify NHibernate to load data from ORDER_200707 instead from ORDER table.

Working with archive tables with the same structure as the original one is a common scenario, so I suppose that any solution exists.


Thanks in advance

Hi,

Still no one has answered on my post?

I already use nHibernate 2.0.1 and still looking forward this funtionality.