Return-Path: Delivered-To: apmail-jakarta-struts-user-archive@www.apache.org Received: (qmail 79883 invoked from network); 10 Mar 2004 05:53:03 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 10 Mar 2004 05:53:03 -0000 Received: (qmail 77009 invoked by uid 500); 10 Mar 2004 05:52:26 -0000 Delivered-To: apmail-jakarta-struts-user-archive@jakarta.apache.org Received: (qmail 76818 invoked by uid 500); 10 Mar 2004 05:52:25 -0000 Mailing-List: contact struts-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Struts Users Mailing List" Reply-To: "Struts Users Mailing List" Delivered-To: mailing list struts-user@jakarta.apache.org Received: (qmail 76803 invoked from network); 10 Mar 2004 05:52:25 -0000 Received: from unknown (HELO hotmail.com) (64.4.46.111) by daedalus.apache.org with SMTP; 10 Mar 2004 05:52:25 -0000 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 9 Mar 2004 21:52:36 -0800 Received: from 61.11.17.107 by bay9-dav7.bay9.hotmail.com with DAV; Wed, 10 Mar 2004 05:52:35 +0000 X-Originating-IP: [61.11.17.107] X-Originating-Email: [verifyurcontact@hotmail.com] X-Sender: verifyurcontact@hotmail.com From: "Verify" To: "Struts Users Mailing List" Subject: Multiple databases in 1 Query Date: Fri, 6 Feb 2004 11:30:37 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0039_01C3ECA4.A4C06610" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Message-ID: X-OriginalArrivalTime: 10 Mar 2004 05:52:36.0175 (UTC) FILETIME=[E382DDF0:01C40663] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0039_01C3ECA4.A4C06610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable In my struts application I need two databases. I have used DBCP and = defined the datasources. I am able to use both the databases. But I want to execute some query which will require tables from both the = databases.(Union). Is it possible? If so how can I do it. I kno that this is more of a database concept issue than a Struts issue, = but please help me. Any comments and suggestions are welcome. Thanks in advance for paying attention to my problem. Regards, Nilesh. ------=_NextPart_000_0039_01C3ECA4.A4C06610--