Mule 4 | XA | Local Transactions | Bitronix Transaction Manager

👌👌👌

Hi Vishwas
have a question.
when i was doing the example by using mySQL, the data was still being committed and was not rolling back even after the failure.
i have same settings as what you mentioned...just instead of H2 i am using mySQL.

Hello Vishwas,
How can we increase bitronix transaction manager timeout value on local. I am not able to locate wrapper.conf
Thank you.

Premium content - as usual

Hi Sir! How do we manage transactions inside a For each loop? If we are doing DB inserts in iterations using a for each and if any of the iteration fails we may need to roll back the previous iterations too. Shall we use the try block inside for each ? can u help please ?

Little differemt - for a Trancation is some application to lock the whole H2 table even for reading . Not sure if same applies to OLTP DBs like Oracle and SQL Server which cater to hundreds of transactions per second per table . Going by its name , "READ COMMITED" should not lock the whole table but only the affected/inserted row ? (Naming conventions specific to Mule and/or H2) ?

In XA transaction of h2 and HSQL , why would Bitronix TM invoke a recovery (or even retry )thread which is not the standard Transaction behavior . if one of the DB is down , the other successfull upsert should be rolled back automatically/implicitly . Is this is a feature provided only by Bitronix/Mule ? --Nandan Kaushik

Corporate Like presentation almost . One question - Thread from pool "Cpu-lite " running the Listener gets replaced by another thread from same pool for response ? If yes , why ?
1st thread has to transfer context info like source socket etc to the new thread ( albeit from same pool , an extra overhead unless there is some outweighing advantage like unblocking the 1st thread ) ? --Nandan Kaushik

Thank you!

How to include Anypoint MQ publish/consume as part of XA transcation?

Vishwas, your explanation is awsome, could you please add a video on C4E setup.

Thanks.... Very helpful

Wow just amazing !!

Really helpful video. But I have some doubt regarding this transaction please let me know if we can connect in Linked in or somewhere?

Hi @Vishwas thanks for the video.
We have a requirement where we are receiving large data records from SAP, so at first we need to do a truncate on a table and run a batch job to put those SAP data records in batches to the table.
I was going through your videos and could understand the tx management but as batch job is itself an asynchronous scope, how to make sure that if batch job has errors then my TRUNCATE should also rollback

This video is very useful my friend. Thanks a lot for sharing your knowledge.

wish website allows us to give multiple likes to all your videos. You provide very deep and crystal clear explanation in all your teachings. Thank you once again .

Great Explanation and in-depth analysis with clear presentation. Thank you Vishwas. If possible can you do some videos on Advanced concepts on commonly used connectors. Even I have subscribed after watching this video.

Very Deep and great tutorials to understand Internals . Thank you.

Thanks!! for the great Video Vishwas..quick questions..might be foolish...
1) In XA/Local transaction what is the best "Transaction Isolation" level we should set in real world implementation so that other consumers of the DB are not blocked in terms of reading the committed and rights records from the DB? Since Reading Uncommitted is the one which is not going to block the table but I am not so sure if consumers might get the records which in not committed yet and our flow is still not completed, since there could be the scenario in which our flow haven't completed successfully and one of the consume might read the uncommitted record in that fraction of time which is not at all good.I hope I am able to explain it properly.Appreciate your response :) ...
2) Also which transaction Action has been taken for the DB connectors ..is it Indifferent (Default) "doesn't

Very informative video.

One question who allocate the bitronix recovery thread? Is it part of any mule thread pool?

Great job. Well done

Can you please post one domain based project deployment in cloudhub?

Hello Vishwas,
Very good explanation 5 🌟 rating

Very informative and a good demo.... eventually I had to subscribe to Ur channel😊 I would request a video on JWT validation and constructing a valid JWT token through mule

Deep explanations about the topic transaction implementation.
Thank you so much for quick response