Re: one single transaction , several databases' connections

On Tue, 31 Jul 2007 07:29:05 -0000, "YeTsun@xxxxxxxxx"
<YeTsun@xxxxxxxxx> wrote, quoted or indirectly quoted someone who said
:

Can one single transaction contain connections to several different
database?

If you do it with separate connections to each database, each
connection knows nothing about the others. You need a tool that makes
several distributed databases look like one to your app.

This is the sort of thing you use EJB and JTA for. See
http://mindprod.com/jgloss/ejb.html
http://mindprod.com/jgloss/jta.html

You might see what comes up when you google on "JDBC connection
pooling".
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com
.

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)