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/
>
>