Some Oracle implementations write a considerable amount of the database code
within stored procedures. The concept of stored procedure is more than
Interbase's concept, it is really a run unit that may not be tied to an
application and with most standard lannguage constructs. In 9i, they can be
in Java (I think). There is really no start transaction but one is started
implicitly if it is not already running in a transaction context. The
commit or rollback applies globally to the transaction context in which it
is running. In my (limited) exposure, the 'embedded transactions' were used
for performance in running long 'batch-type' jobs.

----- Original Message -----
From: "Jim Bate" <bate@...>
To: <IB-Architect@yahoogroups.com>
Sent: Wednesday, January 22, 2003 8:44 AM
Subject: Re: [IB-Architect] Re: Embedded Transactions


> In Oracle, one is able to start/commit transactions within stored
> procedures. That would be my guess as to the meaning of 'Embedded
> Transactions'
> ----- Original Message -----
> From: <rrokytskyy@...>
> To: <IB-Architect@yahoogroups.com>
> Sent: Wednesday, January 22, 2003 6:49 AM
> Subject: [IB-Architect] Re: Embedded Transactions
>
>
> > > They have tried to switch to PostgreSQL, but as Compiere
> > > uses 'Embedded Transactions' feature of Oracle, they had
> > > to abandon the conversion.
> > >
> > > http://www.compiere.org/technology/independence.html
> > >
> > > Could someone shed some light on what this Embedded
> > > Transactions' magic bullet is, and if Firebird has it, or if
> > > there are plans.
> >
> > Hard to say. I made some googling and found that the concept
> > of "embedded transaction" seems to be Compiere's "invention".
> > Unfortunatelly they do not disclose this concept (patent pending?).
> > People seem to agree that most likely they mean "nested
> > transactions". As far as I know nested transactions are not in the
> > feature list for the Firebird 1.5 and Firebird 2.0.
> >
> > Also some facts: EJB 1.1 and EJB 2.0 do not support nested
> > transactions for CMP. In JTA 1.0.1 XAResource does not support nested
> > transaction. In JCA 1.0 you can have either local or XA transactions
> > (therefore nested transactions are not supported). JDBC up to 3.0 do
> > not have nested transactions.
> >
> > My gues would be that they mean "savepoints". That's completely
> > different issue - Firebird 1.5 will have savpoints, JayBird 1.5 will
> > have savepoints.
> >
> > So, main question here is "what is 'embedded transaction'"? You can
> > also ask David Jencks, he's JBoss team member and JayBird project
> > leader.
> >
> > Best regards,
> > Roman Rokytskyy
> >
> >
> > To unsubscribe from this group, send an email to:
> > IB-Architect-unsubscribe@onelist.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>