Zope Sybase DA Changes

The DC Sybase DA provides access to Sybase Databases from Zope.

Zope Sybase DA 2.00b2

Bugs Fixed

Memory leak fixed. (2.00b1 leaked about 500 bytes/request)

Zope Sybase DA 2.00b1

Features Added

The Zope Sybase DA provides the features of previous sybase database adapters and:

• Fully multi-threaded
• Support for Zope sub-transactions
• Trailing spaces are stripped from strings on retrieval
• The user interface for adding and editing database connections now uses separate fields for server, user, password, and database information. It is no longer necessary to use an arcane connection string.
• Connections now have a "Transactional" option to control whether transactions are used. (Sybase consumes resources for transactions even when select statements are used, so pure-read requests should use non-transactional connections.)
• Long integer fixed-decimal numbers are supported. Numeric columns with zero scale and precision greater than nine are retrieved as Python long integers.

Notes on data type conversions:

• Sybase Money types and numeric types for which scale is non-zero are retrieved as Python floats. This could lead to a loss of precision.
• Image and text columns are truncated at 64K.

Futures

The following features are under consideration for the future:

• Full support for Sybase text and image columns. Currently, text and image columns are truncated at 64K.
• Drop-in Sybase stored procedures.
• Perhaps provide dedicated data types for numeric (ie fixed decimal) and monetary data.