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

Dan.

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

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".

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.