Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.05

Name and version of the database you are using: Postgres 7.4.3

I am trying to create a union mapping for a legacy database that contains order information.

The legacy database contains order data in one table and order history in another table. The data in these tables is identical. The problem is that if an order is half shipped the order could be in both tables. Therefor, to get complete current, and historical order information you have to do a union on the two tables.

That would be fine except the column names are different for the two tables. For the current order table the id column is named something like s_id, and for the history table the id colum is name h_id.

Could someone tell me if it is possible to do a union mapping with the id columns being different names? I only need to read the database. I don't need to persist the objects back to the database. Thanks in advance.

I do not think that H is very useful for helping you. I think iBatis SQLMaps could do better job. It will do exactly what you want
http://ibatis.apache.org/