Hi Alexander I didn't read all the thread but you can use too java to conenct without links. If you want one example I can get you one. On Mon, 14 Mar 2005 20:54:44 +0100, Alexander Gorbachev <gorbyx@xxxxxxxxx> wrote: > Hi all, > > We are facing the problem with design of a new application. > Historically, we have been successful in pursuing our rules that DB > links are not acceptable in our environment. Until now, we've managed > to follow this rule and stay "link-free". > > Developers of a new project reqire DB links. The problem is that > project deadlines are very pressing and we might be forced to comply > with their requirements for distributed transactions on the database > tier. I don't think that there will be any TP monitor in use so > probably no help from this side. > > I have briefly reviewed Oracle documentation and found that there are > some OCI functions for implementation of distributed transactions. As > far as I understand it's possible to apply them on OCI client side (to > be precise, I couldn't find that it's not possible so I assumed) so > that a binary can open two sessions and commit globally. > > I would be very interesting if someone could share any experince with > that. White papers, feasibility, complexity, problems, etc. > > To define the problem again: > --------------------- > We need a way to connect from application tier to two (or more) > databases and perform global transaction with two-phase commit. > --------------------- > > Thanks in advance! > > -- > Best regards, > Alex Gorbachev > -- > //www.freelists.org/webpage/oracle-l > -- Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 8 years of experience in Oracle 7,8i,9i,10g and developer 6i -- //www.freelists.org/webpage/oracle-l