We have the following scenarios in our application.
1. We are having many application updates to orace database which requires local transaction management.
2. One transactions requires interacting with messaging system,which has to run in global transactions.
Is it better to configure 2 datasource one with Non-XA driver for handling local transactions and other with XA driver for handling Global Transactions or can i use one datasource configured as XA driver and use the same for local transactions.In this scenario ,will there be any performance degradation in the applications.