DB2 and Oracle with servlet help

Discussions

Web tier: servlets, JSP, Web frameworks: DB2 and Oracle with servlet help

  1. DB2 and Oracle with servlet help (1 messages)

    I have a application where one module is developed with Oracle database and other module is developed with DB2 database. I have to create a tool which will compare common entries in tables of the 2 databases.

    How can I compare the entries in tables of the databases? I have to achieve the result using servlets.

    Please guide me.

    A prompt response will be highly appreciated.

    Thanks in Advance!

    --DD
  2. Let SQL Take the Strain[ Go to top ]

    To tell the truth the simplest way to do this is to use a product that will let you Join across the two databases and then use a select ... from oracletable INTERSECT select ... from db2table.
    The way I know of doing this would involve using a database link from Oracle to DB2 via the relevant transparent gateway (see http://www.oracle.com/technology/products/gateways/index.html) . This is all from the Oracle driving direction, although you could always to the same thing in reverse from DB2 I suspect