Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 17747 invoked from network); 18 Apr 2005 15:11:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 18 Apr 2005 15:11:46 -0000 Received: (qmail 20789 invoked by uid 500); 18 Apr 2005 15:11:39 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 20754 invoked by uid 500); 18 Apr 2005 15:11:38 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 20708 invoked by uid 99); 18 Apr 2005 15:11:37 -0000 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=HTML_50_60,HTML_MESSAGE,INFO_TLD,RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of larry.meadors@gmail.com designates 64.233.162.193 as permitted sender) Received: from zproxy.gmail.com (HELO zproxy.gmail.com) (64.233.162.193) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 18 Apr 2005 08:11:18 -0700 Received: by zproxy.gmail.com with SMTP id 16so33357nzp for ; Mon, 18 Apr 2005 08:11:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=YJ17/8VyO6dR3GY67nNOgjbqhHARIG/9XNiiD3Ld+Gmnq/8Rnx8daK7eX4TsxBF7awAFEPfNoyrSiP2jcr0HBK0Jiz1PvcBwskNlXdCo31T1HzgLiGmWIQLoSULdKp1VIQk/I4fUGGeGNj3/mlMKLZU3fKx6WMXh9FH58ARfvr0= Received: by 10.36.82.19 with SMTP id f19mr383854nzb; Mon, 18 Apr 2005 08:11:00 -0700 (PDT) Received: by 10.36.90.19 with HTTP; Mon, 18 Apr 2005 08:11:00 -0700 (PDT) Message-ID: Date: Mon, 18 Apr 2005 09:11:00 -0600 From: Larry Meadors Reply-To: lmeadors@apache.org To: ibatis-user-java@incubator.apache.org Subject: Re: querying multiple databases simultaneously In-Reply-To: <4263CB11.7000704@zurke.info> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13791_13646008.1113837060342" References: <42638B6C.6070109@zurke.info> <4263CB11.7000704@zurke.info> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_13791_13646008.1113837060342 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline No. What you are describing is clustering, and way beyond the scope of a tool= =20 like iBATIS. Many database vendors (like Oracle) provide grid-based database solutions,= =20 that is probably your best bet. Larry On 4/18/05, Michael Zurke wrote: >=20 > yes, exactly. >=20 > Brice Ruth wrote: > > I think he means more along the lines of querying multiple systems with > > the same query, and having iBATIS merge the results or return results > > from the "faster" system and discard and/or cancel the query for the > > other system(s). > > > > On 4/18/05, *Larry Meadors* > > wrote: > > > > Do you mean like this: > > > > select * > > from someSqlServerTable > > join someDb2Table on blah =3D blah > > > > Larry > > > > > > On 4/18/05, *Michael Zurke* > > wrote: > > > > hi, > > > > i wonder if ibatis supports something like querying multiple > > databases > > simultanously (i don't mean global transactions but global selects, > > i.e.). i checked the documentation and couldn't find anything so > > i guess > > i have to write some threaded query functionality by myself. i just > > wanted to crosscheck with you guys. or maybe someone knows if > > there is > > some lib i can use together with ibatis which does the job. > > > > thanx, > > mish > > > > > > > > > > > > -- > > Brice Ruth > > Software Engineer, Madison WI >=20 > ------=_Part_13791_13646008.1113837060342 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline No.

What you are describing is clustering, and way beyond the scope of a tool l= ike iBATIS.

Many database vendors (like Oracle) provide grid-based database solutions, = that is probably your best bet.

Larry


On 4/18/05, Michael Zurke <mischa@z= urke.info> wrote:
yes, exactly.

Brice Ruth wrote:
> I think he means more along = the lines of querying multiple systems with
> the same query, and hav= ing iBATIS merge the results or return results
> from the "faste= r" system and discard and/or cancel the query for the
> other system(s).
>
> On 4/18/05, *Larry Meadors* <<= a href=3D"mailto:larry.meadors@gmail.com">larry.meadors@gmail.com
&g= t; <mailto:larry.meadors@gmai= l.com >> wrote:
>
>     Do you mean lik= e this:
>
>     select *
>  = ;   from someSqlServerTable
>     join = someDb2Table on blah =3D blah
>
>     Larry=
>
>
>     On 4/18/05, *Michael Zurke= * < mischa@zurke.info
> &nb= sp;   <mailto:mischa@zurk= e.info> > wrote:
>
>     &nb= sp;   hi,
>
>      &nbs= p;  i wonder if ibatis supports something like querying multiple
>         databases
>&= nbsp;        simultanously (i don't mean= global transactions but global selects,
>    &nb= sp;    i.e.). i checked the documentation and couldn't find = anything so
>         i guess=
>         i have to write so= me threaded query functionality by myself. i just
>         wanted to crossche= ck with you guys. or maybe someone knows if
>    =      there is
>     &nbs= p;   some lib i can use together with ibatis which does the job.<= br>>
>         thanx,
&= gt;         mish
>
>
>
>
>
> --
> Brice Ruth
&= gt; Software Engineer, Madison WI


------=_Part_13791_13646008.1113837060342--