one single transaction , several databases' connections

[YeTsun]

Can one single transaction contain connections to several different
database?

 

[Daniel Dyer]

Can one single transaction contain connections to several different
database?

You need distributed transactions. Search for JTA and "XA transactions".

Dan.

 

[Roedy Green]

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]

For some reason Telus is rejecting posts that contain blank lines or a
mention of whom I am replying to. So I have been forced for now to
scrunch up the messages. I will sign up again with Forte Agent
newsserver, but that will take a while.