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
