Hi,
I am very new to Hibernate (2.1.3). I have a problem. I have a database design such that some data is stored in a relational Database whereas some data is stored in XML Files.

Now i need to Query the two objects which contain the related data.
Say for ex : Product Id's in Relational Database A and Product details in
XML Format. Now my query needs data from both the data stores.

I have created a object which maps to corresponding tables in Relational Database A, it fetched the data using Hibernate API.

Now the second Object is created using my own functions from the XML data but which needs to deal with the first object created by hibernate API.

-> How do i query 2 heterogenous objects ?
-> Is there any way in Hibernate such that i can use XML Files as database
-> Is there any way of querying the objects which have differenr "Sessions" i.e. one object is being created from RDB-A whereas Other from RDB-B.


Thanks in Advance
Sanket

One possble way to handle this is via oracle database links.
I've done some projects this way, but it can be difficult to troubleshoot query tuning at times.
Of course you can manually handle the situation using multiple data sources, using 2 sessions. Of course you have to break it up into multiple queries to each system seperately if you are joining them.


--James

The way I model this is that the DB has some reference in it that points to files.



No, not in a general sense.



You would define 2 different factory configurations that point to the different DBs. I do not know a way to query across both sessions simultaneously.


Sherman