Differences between revisions 38 and 39
Revision 38 as of 2013-08-11 12:30:17
Size: 3917
Comment:
Revision 39 as of 2013-09-03 05:49:08
Size: 260
Editor: 66
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
#pragma section-numbers off

= 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 [[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

----

== DB API 2.0 Drivers ==

=== 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)

=== 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 [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|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. Red``Hat 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 [[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:

{{{#!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')
}}}

----

== Supported Python Applications ==

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

== Web Links ==

[[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]]
My name: Bret Aiken<<BR>>
My age: 34<<BR>>
Country: Germany<<BR>>
Home town: Mittweida <<BR>>
ZIP: 9642<<BR>>
Address: Kantstra�e 62<<BR>>
<<BR>>
Review my blog; [[http://lecliqueboutique.wordpress.com/wp-admin/customize.php|online outlet shopping]]

My name: Bret Aiken
My age: 34
Country: Germany
Home town: Mittweida
ZIP: 9642
Address: Kantstra�e 62

Review my blog; online outlet shopping

Oracle (last edited 2017-08-07 18:24:13 by MaximilianFuxjaeger)

Unable to edit the page? See the FrontPage for instructions.