Your votes power DZone. Login and vote now.
By bloid
via adam-bien.com
Published: Jun 30 2008 / 05:38
You know such an application? :-). I hear from time time statements like: "This is just a report - so I don't need transactions - I'm only reading the data". In this particular case you would access the database without a defined transaction and especially isolation - so you will basically see a snapshot of the database (especially uncommitted changes).
Comments
Motion Control replied ago:
Highly misleading suggestions.
abien replied ago:
You are right - but these are actually anti-suggestions :-).
,
vpetreski replied ago:
http://blog.javasvet.net/najgor/2008/06/20/supports-propagation-is-used-by-wimps/
jk49991 replied ago:
This is an awful article. He plunges off the deep end with "I hear from time time statements like: "This is just a report - so I don't need transactions - I'm only reading the data". In this particular case you would access the database without a defined transaction and especially isolation - so you will basically see a snapshot of the database (especially uncommitted changes).". Not sure what database he's talking about but in Oracle that would break any sort of consistency so it's not going to happen. In Oracle you'd only see committed transactions as it should be. So why do I need transactions for read-only reports again?
abien replied ago:
If you don't have transactions configured in your application - you have to rely on the defaults in the database - especially on the configured isolation level.
This is not an article - just an excerpt from a short post :-).
Voters For This Link (6)
Voters Against This Link (3)