querying muitiple databases with a single sql statement
Hi guys, i have a project am working on, its all about querying a data from multiple databases from different vendors (i mean querying databases like mysql, hsqldb, microsoft sql, oracle, etc at the same time using one query statement). Though i have achieved this by loading each driver of the database connector sequentially and execute the query sequentially across the databases. But the project architecture is such that when i sent a query statement, it should go simultaneously to each database and retrieve the item if available in all databases involved. I came across this unityjdbc software, a mediation software but dont know how to implement it in my java source file so that to achieve my aim. I have read the unityjdbc user manual but is not clear and straight-forward. Please can anyone help me to achieve this, as in how to implement this unityjdbc driver my java application and use this unityjdbc to successful query multiple database or suggest any other way to simultaneously query thir multiple databases with a single statement. Hope my question is clear. Waiting for your response........