Oracle (7.3, 8i+)

Oracle is a popular commercial relational database system.

To utilize Oracle within GNUe, you must use one of the following python drivers:

cx_Oracle SQLNet Driver

An Oracle driver from Computronix. Works with Oracle 8.1.x thru 10.x via Oracle's SQL-Net OCI interface.

Home Page: http://www.cxtools.net/

Supported Platforms:

Connection Properties

The following properties can be specified in your connections.conf file:

Examples

The following is an example of a connection.conf entry:

[myconn]
provider=cxoracle       # Use the CX Oracle adapter
service=mytnsname       # The TNS connection string of the database

Notes

  1. Requires Oracle Client Libraries.
  2. Does not recognize the TWO_TASK environment setting.
  3. Creation of new databases with "gnue-schema --createdb" does not work with this driver. Index introspection is not supported.
  4. Other than that, the driver is fully functional with no known serious problems.

DCOracle2 OCI Driver

An Oracle driver from Digital Creations (Zope). Works with Oracle 7.3, 8.x, 9i via Oracle's SQL-Net OCI interface.

The "Oracle Database Bindings for Python" are packaged with the "Zope Oracle Database Adapter". GNUe does not use the Zope Adapter, so you can safely ignore any installation instructions referring to Zope.

DCOracle is not actively maintained by its upstream developers any longer. You may wish to use the cx_Oracle driver instead.

Home Page: http://www.zope.org/Members/matt/dco2/

Supported Platforms:

Connection Properties

The following properties can be specified in your connections.conf file:

Examples

The following is an example of a connection.conf entry:

provider=oracle         # Use the DCOracle2 adapter
service=mytnsname       # The TNS connection string of the database

Notes

  1. Requires Oracle Client Libraries.
  2. Does not recognize the TWO_TASK environment setting.
  3. Creation of new databases with "gnue-schema --createdb" does not work with this driver. Index introspection is not supported
  4. Other than that, the driver is fully functional with no known serious problems.

GNUe Home

Developer Tools