Last Resource Commit optimization for JDBC
There is one caveat with Last Resource Commit. There is a small chance that a transaction ends up with inconsistent results across participating resources if BTM crashes while a transaction is in-flight. The chance is small but it exists so be careful when using that feature. This is in no way a limitation of BTM but of the concept itself.
Please note that if you only intend to run transactions against a single database using Last Resource Commit this scenario is 100% safe, otherwise not.