Re: federate several datasources

From: jlp (jean-louis.pasturel_at_wanadoo.fr)
Date: 12/09/04

  • Next message: hiTECH.RECRUIT: "[Job-SF, CA] Application Server Architect & Engineer" 
    Date: Thu, 09 Dec 2004 22:50:08 +0100

    Jean-Marc Vanel a écrit :
    > Hello
    >
    > I want to federate (aggregate) several physical datasources, each having
    > its JDBC driver.
    >
    > My idea is that this aggregator could be implemented as a special JDBC
    > driver or Connection, that will respond to queries from the application
    > by dispatching to the relevant tables in each physical database, and
    > construct the final rowset by assembling rowsets from each physical
    > database.
    >
    > JDBCAggregator aggregator = new JDBCAggregator();
    > aggregator.addConnection(db1);
    > aggregator.addConnection(db2);
    > ResultSet = aggregator.createStatement().executeQuery (
    > "SELECT * from db1.client as cl, db2.order as ord " +
    > "where cl.id = ord.client_id" );
    >
    > where all tables from database 1 (respectively 2) get prefix db1 (resp.
    > db2). Or possibly no prefix if there is no ambiguity.
    >
    > I'm looking for an open source project or code suggestions.
    >
    Take a look at Octopus ETL project :
    http://www.objectweb.org/
    Regards
    JLP

  • Next message: hiTECH.RECRUIT: "[Job-SF, CA] Application Server Architect & Engineer"
    Loading