Atomikos Forum

Hello,

I'm using 2 atomikos non-xa datasources in a Spring/JTA/Jpa standalone application with 2 sql server backend databases. I don't want to activate the XA support of sql server but I would to use the 2PC capability. I have done some tests. When a transaction fails, the 2 databases are rolled back even in nested transactions. Is there any threat in this case?

Thank you for your answers.

It works as long as there is no crash of your application. Not for production use:-)

Thank for your answer. But if I don't need recovery after fail, can'I use non-XA datasource in production environment?

You can, as long as you don't ask us to support your configuration :-)

You will get warnings in the logs though. You can hide those somewhat by setting the datasource as 'readOnly' (cf its properties).

HTH