- How/why/when did the project get started ?
- Why would I need a transaction manager ?
- Why using BTM and not insert another TM here ?
- Why is BTM 1.2 refusing to start when configured with Oracle while 1.1 works fine ?
- Is there a way to avoid granting execute privilege on sys.dbms_system to be able to use Oracle ?
How/why/when did the project get started ?
The BTM project started early 2005. Back in time I needed a XA capable transaction manager at many different occasions but couldn't find any satisfying all my needs: standalone, stable, actively maintained, production usable, open source. Unfortunately there were only two choices: JOTM and Tyrex which both were unusable for production as they lacked recovery (and more).
So I started working on BTM in my spare time until JBoss acquired Arjuna's product and released it as open source at the end of 2005. I thought that would be the end of my project but their product's usability was far from satisfying at the time so I just went on coding BTM.
By mid-2006, I finally had something usable that I thought was worth showing the world. It took another six month and eleven releases (archived here: http://www.bitronix.be/Btm/Download) before I considered BTM was up to my needs. During that period, a small but faithful community of users appeared and encouraged me to continue working on BTM. Thanks for that, guys !
About the same story as for Arjuna repeated at the end of 2006 when Atomikos released their impressive product as open source. But BTM already had a community and some users were already planning to go to production with BTM and waited for version 1.0 to be released.
Just before version 1.0, BTM migrated from a all-on-my-own-pc-and-my-website development environment to CodeHaus. This helped a lot making the project way more open to the community as well as providing me with free access to very much needed tools. Thanks for that, guys !
Why would I need a transaction manager ?
If you either use two databases (or more) in your application or you use both a database and JMS then you need a transaction manager. Some people will argue that you can do without one even if you fall in on of those two cases. They are true: it is possible to have a transaction span two resources (like JMS and JDBC) by writing so-called idempotent methods manipulating these resources and some simple error recovery logic.
The fact is that it is harder to write idempotent methods (when it is possible at all) and you also have to write some recovery logic to handle crash cases. It is more or less easy to write code that makes sure the information gets registered at least once. Idempotent methods make sure that in case they got called twice (because of a retrial after a crash) data will be safe anyway.
Why would you have to accept those constraints when you can get free of them ? And why would you have to be careful about low-level logic in your code when you can delegate it to an component specialized in this task ?
Would you write your own web framework or your own ORM nowadays ? Neither would I. It is the transaction manager's job to make sure consistency is kept across multiple resources, not yours.
Why using BTM and not insert another TM here ?
In short: because it is complete and easy to use.
BTM has been tailored to support only the most common scenarios: XA with JDBC and / or JMS. It's internal logic is kept as simple as possible to only support them. On the other hand, great care has been taken to make those scenarios working as best and as easily as possible. BTM also fully supports crash recovery thanks to its disk logger.
You might need more than what BTM proposes, like JCA Connectors support or JTS. In that case you should look at other available products.
Why is BTM 1.2 refusing to start when configured with Oracle while 1.1 works fine ?
BTM tries to recover all resources during startup. If it fails on one of them, it will refuse to start and throw this exception:
Oracle resources can only be recovered when the configured user has these privileges:
There was a bug in version 1.1 that allowed BTM to start up even when a resource could not be recovered (BTM-2). This bug has been fixed in version 1.2.
Is there a way to avoid granting execute privilege on sys.dbms_system to be able to use Oracle ?
Yes. Oracle 11g release 1 does not require this privilege anymore. It seems that Oracle also has a patch to backport this functionality to previous versions of the database (bug 5945463). Details about which versions can be fixed by this patch hasn't been disclosed and it is also not possible to freely download it, you have to contact Oracle support to get your hands on it.