> 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