|
|
|
|
|
|
|
Re: [CDO] Diagnostic/Reparation tool [message #1002194 is a reply to message #1001868] |
Fri, 18 January 2013 06:35 |
|
Am 17.01.2013 14:32, schrieb Christophe MOINE:
> Can we customize the isolation level at CDO level ?
No, I don't think so. Maybe it's part of the data source URL? I *believe* that's normally part of the configuration of
the external DB system, but I'm not an expert. And I didn't say that this is likely the cause.
> Just to be sure: if a request something like select min(cdo_idx) from tableA_ref_list where cdo_source=.... Does it
> necessarily return zero (or no row of course) ? If so, we have plenty of theses :(
I don't know what you mean here.
One thing is clear: we update the element rows and the count value in the other table within the same JDBC transaction.
With an adequate transaction isolation level other connections shouldn't ever see intermediate, inconsistent states. As
you say, most DB-based systems have plenty of these multi-table updates and wouldn't work at all if this fundamental
guarantee wasn't there.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Powered by
FUDForum. Page generated in 0.02800 seconds