I am using 3 different data sources for my application and I am struggling to find a clean way to populate the model objects in my DAOs. For example, in my application, I have a CourseDAO with the method:
public Course getCourse(String courseId)
The Course object has some attributes that come from one data source, and some that come from another. It is also composed of objects, like Section, that are also populated from multiple data sources.
I'm extending JdbcDaoSupport with my CourseDAO. The first questions is, is there a preferred way to work with multiple data sources using JdbcDaoSupport? I'm just creating dataSourceX and dataSourceY. Second, any suggestions for using multiple data sources in a MappingSqlQuery?