Win a copy of hapi.js in Action this week in the HTML, CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

weblogic datasource defaultAutocommit Not working

 
xsunil kumar
Ranch Hand
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am using weblogic 12c version and have created a data source in weblogic console. It is non XA data source. In connection pool properties setting i have provided defaultAutoCommit = false.

In the application i am using EJB transactions with toplink. Problem is that in one transaction, there are 5 insert statements and when i view database report, we found that there are 5 commit happens for one transaction which is not the desired behaviour. Using EJB transaction management, there should be one commit for all 5 transactions.

On further verification, we found that when toplink executes insert statement, weblogic is committing it. Because of this one 5 commit is happening. even if after providing defaultAutoCommit = false in connection pool properties, it is behaving the same.

Please provide your valuable suggestions.

Regards,
Sunil
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!