Monday, August 29, 2005 08:37 AM
I've encountered a similar situation sometime back. If you look at the situation closely, it boils down to retrieving a set of objects from a collection that match a particular criteria, in other words you want to query a collection. There are atleast 3 possible solutions:
1. Use JoSQL api: This api allows you to query collection of objects using an SQL like syntax. It is neat and elegant.
Read more on this from http://josql.sourceforge.net/
2. Use JXPAth API: This allows you to query a collection using an XPath like syntax. If you are very confortable with XPath, then employ this.
3. Use Functors from the common collections: This is a sort of "Closures" implementation in java. Very neat and maintainable.
I also suggest not to convert the dataset into XML, parse/query it and add performance bottlenecks to ur application.
Friday, August 26, 2005 09:35 AM
We just had a presentation from Data Direct, and they mentioned they are working on an implementation of "XQJ" which does just what you describe, provide a unified XML DOM view, with XML QUERY capability, of data which behind the scenes may come from multiple relational databases and XML sources.