Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Use transaction with add/update and delete?

 
C Shinde
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why do we use transaction if we want to add a simple record to a DB using an ORM?



What does starting transaction give us in this case?
 
James Sutherland
Ranch Hand
Posts: 553
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All database access is always done in a transaction, that is kind of the point of a database.

The benefits of transactions is that life in a multi-user system would be pretty difficult without them.
 
xsunil kumar
Ranch Hand
Posts: 143
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maintaining transation is required only if you are using application managed transation. If you are using container managed transation, then there is no need to opening transation and comitting it.

I think you are creating entity manager by using entity manager factory. If you are creating entity manager by using entity manager factory, then this is a example of application managed transation and you need to maintain transation other wise your data will not reflect to the database.
Container managed entity manager is not supported in Java SE env. you need to use Java EE env. otherwise in Java SE , you can use container managed entity manager with help of Spring. By using Spring dependency injection.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic