connect to two different databases and fetch data from both

[GoogleCodeExporter]

HI All,

i have requirement where there are two systems running. one is live system and 
another one is archival system, where i need to provide an enquiry to the user 
which will fetch data from both the systems based on the inputs given. 

like if the user tries to get the history of a particular customer information 
based on from and to dates, i need to first check in one of the system whether 
i have data completely in that system or it is shared in both the systems.

Example: user gave input of customer number and from date as 01-Feb-2015 and to 
date as 01-Mar-2014 and last archival date is on 01-Jan-2015 then i need to 
fetch data from 01-Mar-2014 to 01-Jan-2015 from archival database and from 
01-Jan-2015 to 01-Feb-2015 from Live system.

can anyone help me how to resolve this. as i have table-structure and table 
names are same in both database

Original issue reported on code.google.com by thrivikr...@gmail.com on 7 Apr 2015 at 11:05

[GoogleCodeExporter]

This project has moved to a different location a long time ago. 
Support page is here: http://javalite.io/support

Please, post this question to Google Group, not here

Original comment by i...@expresspigeon.com on 7 Apr 2015 at 4:43

[GoogleCodeExporter]

thanks, i will do 

Original comment by thrivikr...@gmail.com on 8 Apr 2015 at 10:38