Differences between revisions 12 and 42 (spanning 30 versions)

Oracle

URL: http://www.oracle.com/index.html
FAQ: http://www.orafaq.com/
Wiki: http://www.orawiki.com/
Wikipedia: http://en.wikipedia.org/wiki/Oracle_database
license: commercial/proprietary; free for development from Oracle Technology Network; Oracle XE is free for production and development (and an excellent option all-around)
platforms: Unix, Linux, win32, win64

Pros

Reputation for being capable of handling large scale databases
Typically the database system others compare themselves to

Cons

Usually requires bloated Oracle client installation on any machine that the app will run on
Frequently the subject of migration discussions (to alternatives), usually for reasons of cost

DB API 2.0 Drivers

cx_Oracle

URL: http://cx-oracle.sourceforge.net/
licence: BSD like
platforms: Unix, win32
Python versions: 2.5 - 3.2
Oracle versions: 10i - 11g
Last release: 5.1 (March 19, 2011)

DCOracle2

URL: http://www.zope.org/Members/matt/dco2
licence: ZPL
platforms: Unix, win32
Python versions
Last release: 1.3beta (Feb 10, 2003)

DCOracle2 targets Oracle 8i and up.

There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained.

mxODBC

URL: http://www.egenix.com/products/python/mxODBC/
Licence: eGenix Commercial License
Platforms: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions: 2.4 - 2.7

mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the Oracle Instant Client.

pyodbc

URL: http://code.google.com/p/pyodbc
License: MIT
Platforms: Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
Python versions: 2.4 - 2.6

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.

OJDBC and JayDeBeApi

URL: http://pypi.python.org/pypi/JayDeBeApi
licence: LGPL
platforms: Any (requires Java)
Python versions: Tested on CPython 2.6.6 and Jython 2.5.2
Oracle versions: Any supported by Oracle's JDBC drivers (currently 8.1.7 to 11.2.0.2.0)
Last release: 0.1 (2010-08-16)

No InstantClient required. Download an Oracle JDBC driver (the filename will be something like ojdbc6.jar) from the Oracle website, and set the classpath to include the driver. Note that if not running under Jython, JPype is required. Use code like the following:

   1 environ['JAVA_HOME'] = '/usr/lib/jvm/java-6-openjdk/jre'
   2 jpype.startJVM(jpype.getDefaultJVMPath(), '-Djava.class.path=ojdbc6.jar')
   3 conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver', 'jdbc:oracle:thin:user/pass@server:1521:dbname')

Supported Python Applications

Zope
an Oracle (DCOracle and DCOracle2) driver exists for PyDO (Python Data Objects)

Web Links

Oracle Forum

Oracle Wiki's: English German

Oracle Documentation: 10g 9i 8i 7

-  ⇤ ← Revision 12 as of 2005-03-29 17:31:03 → 
  Size: 2332
  Editor: host202
  Comment: Fix embarassing previous interpretation "masthead" (IMHO a poor generic header)
+   ← Revision 42 as of 2014-03-20 17:50:23 → ⇥
  Size: 3917
  Editor: MarcAndreLemburg
  Comment: Undo vandalism
-Deletions are marked like this.
+Additions are marked like this.
 Line 2:
-[[TableOfContents]]
-Line 4:
+Line 3:
-== Masthead ==
+= Oracle =
-Line 6:
+Line 5:
-''The first link below is dead, and it's not clear to me what the intended target should be.''
  URL:: http://www.oracle.com/ip/deploy/database/oracle9i/
  FAQ:: http://www.orafaq.com/
  licence:: commercial (free development versions available on http://technet.oracle.com/)
  platforms:: Unix, win32
+  URL::  http://www.oracle.com/index.html
  FAQ::  http://www.orafaq.com/
  Wiki::  http://www.orawiki.com/
  Wikipedia:: http://en.wikipedia.org/wiki/Oracle_database
  license:: commercial/proprietary; free for development from [[http://www.oracle.com/technology//index.html|Oracle Technology Network]]; [[http://www.oracle.com/technology/software/products/database/xe/index.html|Oracle XE]] is free for production and development (and an excellent option all-around)
  platforms:: Unix, Linux, win32, win64

== Pros ==

 * Reputation for being capable of handling large scale databases
 * Typically the database system others compare themselves to

== Cons ==

 * Usually requires bloated Oracle client installation on any machine that the app will run on
 * Frequently the subject of migration discussions (to alternatives), usually for reasons of cost

----
-Line 13:
+Line 25:
+=== cx_Oracle ===

  URL:: http://cx-oracle.sourceforge.net/
  licence:: [[http://cx-oracle.sourceforge.net/LICENSE.txt|BSD like]]
  platforms:: Unix, win32
  Python versions:: 2.5 - 3.2
  Oracle versions:: 10i - 11g
  Last release:: 5.1 (March 19, 2011)
-Line 20:
+Line 41:
+  Last release:: 1.3beta (Feb 10, 2003)
-Line 21:
+Line 43:
-==== Extensions to DB API ====
+DCOracle2 targets Oracle 8i and up.
-Line 23:
+Line 45:
-==== Comments ====
+There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained.
-Line 25:
+Line 47:
-=== cx_Oracle ===
-Line 27:
+Line 48:
-  URL:: http://www.computronix.com/utilities.shtml
  licence:: [http://www.computronix.com/download/License(cxOracle).txt BSD like]
  platforms:: Unix, win32
  Python versions:: 2.2 - 2.4
  Oracle versions:: 8i - 10g
+=== mxODBC ===
-Line 33:
+Line 50:
-==== Extensions to DB API ====
+  URL:: http://www.egenix.com/products/python/mxODBC/
  Licence:: eGenix Commercial License
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
  Python versions:: 2.4 - 2.7
-Line 35:
+Line 55:
-==== Comments ====
+mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|Oracle Instant Client]].
-Line 37:
+Line 57:
-While trying to install the cx_Oracle Python utility, I encounter the following error:
+=== pyodbc ===
-Line 39:
+Line 59:
+  URL:: http://code.google.com/p/pyodbc
  License:: MIT
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
  Python versions:: 2.4 - 2.6
-Line 41:
+Line 64:
-sh-2.05b# python setup.py build
+Actively maintained Open Source project.
-Line 43:
+Line 66:
-running build
+Precompiled binaries are available for Windows.  Red``Hat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.
-Line 45:
+Line 68:
-running build_ext
+=== OJDBC and JayDeBeApi ===
-Line 47:
+Line 70:
-building 'cx_Oracle' extension
+  URL:: http://pypi.python.org/pypi/JayDeBeApi
  licence:: LGPL
  platforms:: Any (requires Java)
  Python versions:: Tested on CPython 2.6.6 and Jython 2.5.2
  Oracle versions:: Any supported by Oracle's JDBC drivers (currently 8.1.7 to 11.2.0.2.0)
  Last release:: 0.1 (2010-08-16)
-Line 49:
+Line 77:
-gcc -pthread -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -I/devtools/oracle/product/8.1.5/rdbms/demo -I/devtools/oracle/product/8.1.5/rdbms/public -I/devtools/oracle/product/8.1.5/network/public -I/usr/local/python2.4/include/python2.4 -c cx_Oracle.c -o build/temp.linux-i686-2.4/cx_Oracle.o -DBUILD_TIME="January 21, 2005 11:19:47"
+No InstantClient required. Download an Oracle JDBC driver (the filename will be something like ojdbc6.jar) from the [[http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html|Oracle website]], and set the classpath to include the driver. Note that if not running under Jython, JPype is required. Use code like the following:
-Line 51:
+Line 79:
-cx_Oracle.c:10: xa.h: No such file or directory
+{{{#!python
environ['JAVA_HOME'] = '/usr/lib/jvm/java-6-openjdk/jre'
jpype.startJVM(jpype.getDefaultJVMPath(), '-Djava.class.path=ojdbc6.jar')
conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver', 'jdbc:oracle:thin:user/pass@server:1521:dbname')
}}}
-Line 53:
+Line 85:
-error: command 'gcc' failed with exit status 1

 

Where can I find the xa.h file?  The only package I could find online that provides any such file is a cd i/o library, and that doesn’t seem right.

I am running a 2.4 linux kernel, trying to install cx_Oracle-4.0.1 on top of Python 2.4.

I have tried the beta package which should be more 2.4 compatible, but still no luck.  Any help is appreciated.  Thanks!

== Other Drivers ==

=== driver name ===

  URL:: 
  licence::
  platforms::
  Python versions::

==== Programming Model ====

==== Comments ====
+----
-Line 78:
+Line 89:
- * ["Zope"]
 * an Oracle (DCOracle and DCOracle2) driver exists for ["PyDO"] (Python Data Objects)
+ * [[Zope]]
 * an Oracle (DCOracle and DCOracle2) driver exists for [[PyDO]] (Python Data Objects)
-Line 81:
+Line 92:
-== Pros ==
+== Web Links ==
-Line 83:
+Line 94:
-== Cons ==
 * Requires bloated Oracle client installation on any machine that the app will run on
+[[http://www.orafaq.com/forum|Oracle Forum]]

Oracle Wiki's: [[http://www.orafaq.com/wiki|English]] [[http://www.oracle-10g.de/oracle-wiki|German]]

Oracle Documentation: [[http://www.oracle-doku.de/oracle_10g_documentation/index.htm|10g]] [[http://www.oracle-doku.de/oracle_9i_documentation/index.htm|9i]] [[http://www.oracle-doku.de/oracle_8i_documentation/index.htm|8i]] [[http://www.oracle-doku.de/oracle_7_documentation/index.htm|7]]

Page

User