[Zope-DB] Incomplete, unreliable results sets on Zope 2.6.3

[Dieter Maurer]

David Woods wrote at 2004-2-20 14:06 -0600:
> ... partial results; Zope 2.3.2 works fine, Zope 2.6.3 not ...
>Since the move to the new server, though, we've had sporadic problems with
>getting incomplete data from the queries.  For example, a query that should
>get a list 65 students for a particular course from the database might get
>all 65, but it might get 8 or 1 or 17 or 62 instead.  Zope acts like it's
>just gotten all the data it should have and just carries on.

There was no significant change in this areas between Zope 2.3 and
Zope 2.6.

At your place, I would drop ZODBCA in favour of "ZmxODBCDA" (commercial,
but reasonably priced) and see whether the problem disappears.
There are several issues known for ZODBCDA (although nothing like
you observed...)

-- 
Dieter