Re: TUXEDO and Oracle

Wolfgang.Rothmayer_at_bmw.de wrote:
>
> On Fri, 14 Aug 1998 08:58:32 +0200, Haakon T Soenderland
> <haakonts_at_online.no> wrote:
>
> Hi,
>
> sorry for jumpin' in, but I thought that you have to use the
> XA-Interface from OpenGroup to be able to use TP functionality.
> Do you mean that I CAN use TP functionality simply installing the
> TUXEDO service ?

To be able to use commits that spans more than one type of database, for example DB2 and Oracle, you will need Oracles XA interface with Tuxedo. If you are not spanning different databases in one transaction you do not have to use XA. At least this is my understanding. I know for a fact that there is no problem to use (connect, select etc) an Oracle database from a Tuxedo service without using the XA-protocol.

Haakon

> >Elias wrote:
> >>
> >> My question about TUXEDO is :
> >>
> >> How could I from a client point of view access Oracle server
> >> without having the SQLNET layer installed on the client side ?.
> >
> >You'll have to create a TUXEDO service that accesses Oracle from the
> >Tuxedo Server. You can then use this service as any other Tuxedo
> >service.
> >
> >>
> >> The only layer installed on top of TCP/IP stack is the TUXEDO
> >> DLL.
> >>
> >> In fact what I'm trying to do from my NT3.51 workstation is :
> >> - first accessing a mainframe by using TUXEDO cals,
> >> - and in case of troubles with the mainframe database, I'll
> >> call Oracle database (just to pass some requests).
> >
> >You can probably make the Tuxedo service do this "automatically"
> >upon failure of the mainframe service.
> >
> >Hope this helps,
> >Haakon
> >Core Technology AS
> >Oslo, Norway
Received on Mon Aug 17 1998 - 00:00:00 CEST