15 total views, 0 views today

WebLogic Error: Data Source is non-transactional and so can not use XA-aware pool

Received the following error while starting the Admin Service in Oracle Weblogic server 

weblogic.application.ModuleException: weblogic.common.ResourceException: weblogic.common.ResourceException: DataSource ‘LocalSvcTblDataSource’ can not be created. It is non-transactional and so can not use XA-aware pool ‘LocalSvcTblDataSource’
at weblogic.jdbc.module.JDBCModule.prepare

SOlution: 

• Go to DOMAIN_HOME\config\jdbc folder and open the XML that is failing; 

• Check the , If it is oracle.jdbc.xa.client.OracleXADataSource then enable TwoPhaseCommit as shoen below

(or) 

Change the driver to Oracle.jdbc.OracleDriver ash shown below(Non-XA)

3. Restart the servers