Re: Query with tables from 2 different databases in Java

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Loredana Curugiu <loredana(dot)curugiu(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Query with tables from 2 different databases in Java
Date: 2007-06-07 14:13:54
Message-ID: 1181225634.31471.387.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-novice

On Thu, 2007-06-07 at 17:08 +0300, Loredana Curugiu wrote:
> Hi,
>
> I need a query to use tables from 2 different databases and
> that query to be executed from a .java file. What do you recommand?
>
> Thanks in advance!
>
>
> Regards,
> Loredana
>

Move the data to a single database, or else perform the query manually
by pulling back the matching results from each database individually and
then stitching them together.

-- Mark Lewis

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tomeh, Husam 2007-06-07 14:21:09 Re: [NOVICE] Query with tables from 2 different databases in Java
Previous Message Loredana Curugiu 2007-06-07 14:08:49 Query with tables from 2 different databases in Java

Browse pgsql-novice by date

  From Date Subject
Next Message Tomeh, Husam 2007-06-07 14:21:09 Re: [NOVICE] Query with tables from 2 different databases in Java
Previous Message Loredana Curugiu 2007-06-07 14:08:49 Query with tables from 2 different databases in Java