400 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 

 

<Error> <Deployer> <BEA-149205> <Failed to initialize the application “LocalSvcTblDataSource” due to error 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’
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 <driver-name>, If it is oracle.jdbc.xa.client.OracleXADataSource then enable TwoPhaseCommit as shoen below

 

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

 

 

(or) 

 

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

 

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

 

3. Restart the servers

 

 

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

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan WebLogic Error: Data Source is non-transactional and so can not use XA-aware pool
Connect me
By | 2017-12-15T23:41:23+00:00 December 15th, 2017|Categories: WebLogic|Tags: , |Comments Off on WebLogic Error: Data Source is non-transactional and so can not use XA-aware pool
Like us on Facebook.
Connect!