• Post Reply Bookmark Topic Watch Topic
  • New Topic

weblogic datasource defaultAutocommit Not working  RSS feed

xsunil kumar
Ranch Hand
Posts: 147
  • 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.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!