You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Michael Zurke <mi...@zurke.info> on 2005/04/18 12:26:52 UTC
querying multiple databases simultaneously
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
Re: querying multiple databases simultaneously
Posted by Craig Johannsen <cj...@shaw.ca>.
Here is some interesting material about IBM's solution for this type of
problem. I think it was originally based on some technology purchased
from Simba Technologies Inc., but no longer available directly from Simba.
IBM Federated Database Technology:
http://www-106.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.html
Sybase EnterpriseConnect Data Access:
http://www.sybase.com/products/informationmanagement/enterpriseconnectdataaccess
Attunity Federate:
http://www.attunity.co.uk/Products/AttunityFederate.Asp
Virtuoso Universal Server:
http://virtuoso.openlinksw.com/main/vdbms/index.htm
DatabaseBridge:
http://www.skywaytechnology.com/Products.htm
JDBC NetServer (no heterogeneous join?):
http://www.agave.com/html/products/jdbc.htm
Connx:
http://www.connx.com/products/products.html
DataDirect SequeLink (no heterogeneous join?):
http://www.datadirect.com/products/sequelink/overview/index.ssp
Dharma Integrator:
http://dharma.com/Dharma_integrator.shtml
TRIFOX VORTEX:
http://www.trifox.com/vortex/index.html
Vista JDBC:
http://www.vistaportal.com/products/VistaJDBC.pdf
I am not endorsing any of the above solutions.
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
>
>
Re: querying multiple databases simultaneously
Posted by Brice Ruth <bd...@gmail.com>.
You could do the merging bit in a DAO, pretty easily. Well, easily would be
doing it sequentially ... parallel would be a bit more challenging.
On 4/18/05, Michael Zurke <mi...@zurke.info> wrote:
>
> yes, exactly.
>
> 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* <larry.meadors@gmail.com
> > <ma...@gmail.com>> wrote:
> >
> > Do you mean like this:
> >
> > select *
> > from someSqlServerTable
> > join someDb2Table on blah = blah
> >
> > Larry
> >
> >
> > On 4/18/05, *Michael Zurke* <mischa@zurke.info
> > <ma...@zurke.info> > 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
>
>
--
Brice Ruth
Software Engineer, Madison WI
Re: querying multiple databases simultaneously
Posted by Larry Meadors <la...@gmail.com>.
No.
What you are describing is clustering, and way beyond the scope of a tool
like iBATIS.
Many database vendors (like Oracle) provide grid-based database solutions,
that is probably your best bet.
Larry
On 4/18/05, Michael Zurke <mi...@zurke.info> wrote:
>
> yes, exactly.
>
> 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* <larry.meadors@gmail.com
> > <ma...@gmail.com>> wrote:
> >
> > Do you mean like this:
> >
> > select *
> > from someSqlServerTable
> > join someDb2Table on blah = blah
> >
> > Larry
> >
> >
> > On 4/18/05, *Michael Zurke* <mischa@zurke.info
> > <ma...@zurke.info> > 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
>
>
Re: querying multiple databases simultaneously
Posted by Michael Zurke <mi...@zurke.info>.
yes, exactly.
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* <larry.meadors@gmail.com
> <ma...@gmail.com>> wrote:
>
> Do you mean like this:
>
> select *
> from someSqlServerTable
> join someDb2Table on blah = blah
>
> Larry
>
>
> On 4/18/05, *Michael Zurke* <mischa@zurke.info
> <ma...@zurke.info> > 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
Re: querying multiple databases simultaneously
Posted by Brice Ruth <bd...@gmail.com>.
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 <la...@gmail.com> wrote:
>
> Do you mean like this:
>
> select *
> from someSqlServerTable
> join someDb2Table on blah = blah
>
> Larry
>
> On 4/18/05, Michael Zurke <mi...@zurke.info> 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
Re: querying multiple databases simultaneously
Posted by Larry Meadors <la...@gmail.com>.
Do you mean like this:
select *
from someSqlServerTable
join someDb2Table on blah = blah
Larry
On 4/18/05, Michael Zurke <mi...@zurke.info> 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
>