|
Size: 3929
Comment: Describe method of combining OJDBC and JayDeBeApi.
|
Size: 629
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://www.computronix.com/download/License(cxOracle).txt|BSD like]] platforms:: Unix, win32 Python versions:: 2.2 - 2.5 Oracle versions:: 8i - 11g Last release:: 5.0.2 (May 21, 2009) === 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.1 - 2.6 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]] |
Lake Charles-born Harriett is hooked on medical insurance, computing devices, operating on cars. Besides that she really loves going on a [[en.wikipedia.org/wiki/Health_insurance_in_the_United_States|vacation]] and discovering new locations for example, Cuba!<<BR>> Author bio OR About - 2<<BR>> Structural engineer Harriett enjoys medical insurance, doing yoga, volunteer. She get practically all her stimulus by visiting different cities and countries for example, Cook Islands.<<BR>> <<BR>> Here is my web page - [[http://healthinsurance689.webs.com/qqbenefits|the cultural landscape an introduction to human geography]] |
Lake Charles-born Harriett is hooked on medical insurance, computing devices, operating on cars. Besides that she really loves going on a vacation and discovering new locations for example, Cuba!
Author bio OR About - 2
Structural engineer Harriett enjoys medical insurance, doing yoga, volunteer. She get practically all her stimulus by visiting different cities and countries for example, Cook Islands.
Here is my web page - the cultural landscape an introduction to human geography