Problems with long strings in RDBMS
I´m having problems trying to add strings greater than about 150 chars. These strings make the database cursor to crash. I have mysql with ODBC with ZODBCDA under W98. I´m sure it is a ZODBCDA problem, because of I tried to connect with Access2000 and the row with the long string is inserted and I can read it. I tried to hack the code, but I think the problem is in a binary file of the ZODBCDA distribution. Someone experiment something like this?. is it better if i post the traceback? I have searched on Zope.org but it´s nothing about this. ------ Antonio Carrasco
Antonio Carrasco writes:
I´m having problems trying to add strings greater than about 150 chars. These strings make the database cursor to crash.
I have mysql with ODBC with ZODBCDA under W98.
I´m 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. Dieter
participants (2)
-
Antonio Carrasco -
Dieter Maurer