[Zope] Problems with long strings in RDBMS
Thu, 20 Jun 2002 21:27:54 +0200
Antonio Carrasco writes:
> I=B4m having problems trying to add strings greater than about 150 cha=
> These strings make the database cursor to crash.
> I have mysql with ODBC with ZODBCDA under W98.
> I=B4m sure it is a ZODBCDA problem...
Maybe, you use ZmxODBCDA, although you need to pay a bit for it...
ZODBCDA has several known issues:
* it is single thread and freezes Zope while doing database operations
(someone forgot to release Python's interpreter lock)
* it uses an old way to pass query results (via a file rather than
in memory structures). This triggers a small bug in Zope's
handling of query results. The result does not have
a "dictionaries" method.
Furthermore, a colleague reported problems with the transfer of
large data that disappeared when he switched to ZmxODBC. I cannot
be more precise on this, as I was only partly involved.