I didn't see this topic covered in the documentation so I don't think its possible, but I thought I would ask anyway before telling my customer its not possible.

Is it possible to construct hbm files sucha that you can map an Object, Car for instance, to two different schemas with two different CAR tables so that when a user queries for Car he gets back a collection of Car objects populated from both schemas.

That's all I need to know.

THanks,

Mike

Is this what you are looking for


if you want to construct the query from two table what would be the id . I dont understand . Or is that each subtype of car is mapped to a different table in which case you can use joined-subclass type of mapping

I saw that documentation, but that seemed to be a situation where my two tables would be in the same database. If I had two database servers with two schemas and each had a CAR table and for arguement sake had the exact same structure would I be able to query for "car model" and hibernate would be able to connect to two different datbases and bring back records from both tables to populate my objects. This is a weird use case, but my customer wants me to build a drag and drop hibernate mapping tool that will allow him to map an object in one object model to more than one datasource. I don't think this is possible but I'm not sure.

Thanks,

Mike

It's not a Hibernate solution, but perhaps you could use Spring's HibernateTemplate. You could have a different HibernateTemplate for each database and include the mapping file in the config for each template.