Subject Re: [firebird-support] Re: What is the proper transaction level
Author Pavel Menshchikov
Hello Colin,

c> To avoid "gap" problems with OIT/OAT etc I've just changed my
c> application to use read-only read-committed transactions everywhere.
c> Updates to data are done via read-write transactions. This is achieved
c> using the FibPlus components, where a query (TpFibDataset) can have a
c> read transaction AND an update transaction.

c> I'm also suffering with "blob not found" errors, and many of my
c> queries retrieve blobs.

c> So I have to change back to not using read-only?

You should check how you use FIB+ components regarding BLOBs - FIB+
has an ability to cache BLOBs locally, or write BLOBs separately from
"regular" fields (if regular fields were written succesfully). But
it's off-topic here - ask about your problems and solutions at
devrace.com.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com