Hello,

I was wondering if it is possible to span a sub-classed object across multiple data sources, i.e.:

abstract class Shape {
protected color;

...

}

class Circle extends Shape {
private int radius;

...
}

And have the shape data come from one data source, and circle data from another. Obviously for this example it would make little sense, however I can assure you in the “real life” problem domain there are defendable motivations for doing this :) (e.g. data management/security).

My travels on the forums indicate the answer is no as of Jan 2004. Is this still the case (as I read much has changed in v3)? If so, how is everyone dealing with these situations? Re-thinking the OO architecture of the app? Any clever tricks?

Thanks in Advance,

Richard Wareing

I think you would have to configure two SessionFactories which would make it impossible to access both entities transparently in one transaction, though you may have some luck combining the two physical data sources into one logical JDBC data source using something like C-JDBC or HA-JDBC.