Jiri Cincura schrieb am 15.09.2012 um 13:40 (+0200): > > … I went across bugs and found DNET-337. Read it, think about it.
http://tracker.firebirdsql.org/browse/DNET-337 > What my idea is, is to change ReadCommitted and ReadUncommitted to > have same [1] TPB and use rec_version [2]. > > [1] Because there's no "uncommitted" mode in Firebird and I think it's > better than throw an exception. > [2] Because of reasons mentioned in ticket. > > What do you think? A. ReadUncommitted Firebird doesn't do ReadUncommitted, so raising an ArgumentException when ReadUncommitted is requested would seem to make sense to me. Falling back to ReadCommitted, on the other hand, would not be what was requested. Firebird people clearly agree that Firebird doesn't do ReadUncommitted, so why try faking it? B. ReadCommitted For ReadCommitted, I found this discussion from 12/2005, which the ticket in question reads like an echo of: firebird-devel - NO_REC_VERSION http://firebird.1100200.n4.nabble.com/NO-REC-VERSION-td1109867.html Looks like they didn't change the default of isc_tpb_no_rec_version in the C API (see ApiGuide.pdf p.66) in order not to break existing code. > This will, for sure, be version 3.0 because it's huge breaking change. > As much as I don't like breaking changes, this looks like one worth > it. Of course, there will be huge screaming read exclamation point > everywhere around this version. An argument in favour of changing ReadCommitted to default to isc_tpb_rec_version would be that a couple knowledgeable people say it has usability advantages and makes more sense that way. An argument against it might be that it deviates from the C API. As for me, first time I'm even hearing about the issue, so I don't have an opinion on what's wrong or right for ReadCommitted in .NET. Here's another related and probably relevant discussion (too tired to read it now): firebird-devel - ReadCommitted isolation mode in Firebird's drivers http://firebird.1100200.n4.nabble.com/ReadCommitted-isolation-mode-in-Firebird-s-drivers-td2311647.html Michael ------------------------------------------------------------------------------ How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider