Product Documentation

V11.5 Update Guide

Previous Topic

Next Topic

SQL support for Python V3.x

Notes:

  1. The FairCom pyctree interface (the Python DB API 2.0-compliant driver) is compatible with Python versions 2.6 and 3.x.
  2. Support for the following data types has not been implemented: BINARY, VARBINARY, LONGVARBINARY, LONGVARCHAR and UNICODE fields.
  3. The following features do not conform to the PEP 249 standard:
    • Auto Commit - The autocommit read/write property of the Connection class allows the programmer to turn on/off the autocommit capability.
    • Query Timeout - The querytimeout read/write attribute of the Cursor class can be set to 0 (default) to indicate no timeout or to a positive value to specify a query timeout in seconds.
  4. The provided c-treeACE SQL libraries are linked with OpenSSL support. Due to the link order of the libraries, some platforms may require specific run-time library pre-load instructions. For example, on some Linux distros:

export LD_LIBRARY_PATH=../../../lib/sql.python/

LD_PRELOAD=/usr/lib/libssl.so python PY_tutorial2.py

Best practice dictates LD_PRELOAD should only specify full paths to your libssl.so library, which may reside in different locations on different Unix/Linux distros.

TOCIndex