[Zope] Problems with long strings in RDBMS

Dieter Maurer dieter@handshake.de
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.