I want to migrate a project to hibernate, but I´m not sure if it would work for my db layout, which I follow to explain:

I have a webapp, which connects to a master DB. The datasource to use for that masterDB is configured in a config file. That masterdb can be Oracle or Informix, also detailed in the config file.

In that masterdb, I have datasourcesnames for other connections, which may be viewed as childrendbs. This childrendb can also be Oracle or Informix.

Some of the queries have to be executed in the masterdb and all of the childrendb, and the result merged in a resultset like structure.

Is it possible to use this db layout with hibernate without introducing a high complexity in the program?

Thanks.