On Wednesday, January 22, 2003, at 08:44 AM, Jim Bate wrote:

> In Oracle, one is able to start/commit transactions within stored
> procedures. That would be my guess as to the meaning of 'Embedded
> Transactions'

I talked briefly with the Compiere author some time ago and your guess
agrees with my somewhat faint recollection of what he said.

david jencks

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