This week's giveaway is in the Java/Jakarta EE forum.
We're giving away four copies of Java EE 8 High Performance and have Romain Manni-Bucau on-line!
See welcome thread
Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

weblogic datasource defaultAutocommit Not working  RSS feed

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.

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!