Nn - WAIT for nn seconds for the lock to be released. Possible values: -1 - WAIT until the lock is released.Ġ - DO NOT WAIT, end the operation, and return with error. The default value is 0 (do not wait for the lock). Process for accessing a locked row or table. This will set database LOCK MODE WAIT at connection levelĪpplication can use this property to override the default server This will set database isolation level at connection level Possible values: 0 - Default timeout to the database (which could mean no timeout) This will set timeout for operations on connections (connection, ?closing?, we're not sure).
Possible values: 0 - Turn off connection pooling This will set connection pooling timeout. Then configure the port number in the /etc/services file: sqlexec 9088/tcpĭjango’s settings.py uses the following to connect to an Informix database: You may alternatively use a symbolic name in that line in place of the port number, typically sqlexec and Server connection in the following format: onsoctcp You will also need to add an entry within your sqlhosts file for each remote/local Informix You should specify your database locale, e.g. $INFORIMIXDIR/lib:$INFORMIXDIR/lib/cli:$IMFORMIXDIR/lib/esql DB_LOCALE In case of Database locale information mismatch.
The following environment variables should exist: INFORMIXDIR The path to the Informix client install directory INFORMIXSERVER The name of the Informix service to which we need to connect INFORMIXSQLHOSTS The path to the sqlhosts file that the Informix driver should use LD_LIBRARY_PATH The path(s) to the various Informix library files: Usually It may unintentionally catch other index creation errors where the index Manually the current implementation here just attempts to catch the error on indexĬreation. Informix automatically creates indexes on foreign keys, but Django attempts to do that.
A database driver for Django to connect to an Informix database via pyodbc.