I configured two different data sources for a java application. These two sources are the same with one difference. One with xa and the other with non-xa transactions.
With the non-xa I observer the behavior of database commits after each sql-statement, even if JTA does not close the transaction (does not commit). I suspect TopLink for these. e.g. a rollback after exceptions is not possible.
With the xa transaction the database commits like expected, after JPA close the connection.
xa is for global transaction (required for save transaction over multiple resources) and non-xa if we have one resources. I use only one database, so it should be possible to provide save transaction for non-xa but i'm not able to configure it or find any useful documentation about these topic.
Questions:
- It's even possible to provide save transaction in non-xa?
- If 1=Yes. How and why is these not default?
- If 1=No. Why should someone use non-xa?
- Are they any difference I need to consider for transactions in ejb or cdi about these topic?
Thanks in advance.