|
Size: 2236
Comment: Updated Python versions for cx_Oracle from the given URL, added Oracle versions
|
Size: 2339
Comment: converted to 1.6 markup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| [[TableOfContents]] | |
| Line 4: | Line 3: |
| == Masthead == | = Oracle = |
| Line 6: | Line 5: |
| URL:: http://www.oracle.com/ip/deploy/database/oracle9i/ | URL:: http://www.oracle.com/index.html |
| Line 8: | Line 7: |
| licence:: commercial (free development versions available on http://technet.oracle.com/) platforms:: Unix, win32 |
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 == * 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 20: | Line 33: |
| ==== Extensions to DB API ==== ==== Comments ==== |
|
| Line 26: | Line 35: |
| URL:: http://www.computronix.com/utilities.shtml licence:: [http://www.computronix.com/download/License(cxOracle).txt BSD like] |
URL:: http://cx-oracle.sourceforge.net/ licence:: [[http://www.computronix.com/download/License(cxOracle).txt|BSD like]] |
| Line 29: | Line 38: |
| Python versions:: 2.2 - 2.4 Oracle versions:: 8i - 10g |
Python versions:: 2.2 - 2.5 Oracle versions:: 8i - 11g |
| Line 32: | Line 41: |
| ==== Extensions to DB API ==== | === mxODBC === |
| Line 34: | Line 43: |
| ==== Comments ==== | 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.5 |
| Line 36: | Line 48: |
| While trying to install the cx_Oracle Python utility, I encounter the following error: | 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 Instance Client]]. |
| Line 38: | Line 50: |
| sh-2.05b# python setup.py build running build running build_ext building 'cx_Oracle' extension 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" cx_Oracle.c:10: xa.h: No such file or directory 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 77: | Line 54: |
| * ["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 80: | Line 57: |
| == Pros == | == Web Links == |
| Line 82: | Line 59: |
| == 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]] |
Oracle
- URL
- FAQ
- Wiki
- Wikipedia
- 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
- 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
DCOracle2
- URL
- licence
- ZPL
- platforms
- Unix, win32
- Python versions
cx_Oracle
- URL
- licence
- platforms
- Unix, win32
- Python versions
- 2.2 - 2.5
- Oracle versions
- 8i - 11g
mxODBC
- URL
- Licence
- eGenix Commercial License
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
- Python versions
- 2.1 - 2.5
mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the Oracle Instance Client.
Supported Python Applications