Oracle JDBC Drivers & I-net

Oracle JDBC driver ile yaşanan sorunları birçoğunuz tecrübe etmiş veya duymuşsunuzdur. Her ne kadar Oracle 10g ile birlikte bu hatalar azalsa da hala ciddi sorunlar olabiliyor. Özellikle JIRA gibi platform (Database, Application Server ve Operating System) bağımsız ürünlerin JDBC driver’lardan beklentileri çok daha fazla oluyor.

JIRA dünya üzerinde 2200’den fazla müşteri tarafından kullanılıyor ve müşterilerinin çoğunluğu veritabanı olarak Oracle kullanıyor. Bu yüzden JIRA’cılar Oracle konusunda bayağı tecrübe edinmişler ve bu tecrübelerini dokümanlarına yansıtmışlar. Sonuç olarak Oracle JDBC driver yerine, 3 kat daha hızlı I-net software JDBC driver ‘i tavsiye ediyorlar. Belki lazım olur diye paylaşayım istedim:

WARNING: please make sure you get the 10.1.0.5 version of the driver. Every other version has problems:

• The 9i drivers don't support CLOBs, so are unusable.
• The 10g Release 2 JDBC driver (10.2.0.1.0) hangs with some databases.
• The 10g Release 1 JDBC driver (10.1.0.4) does not hang, but throws ArrayIndexOutOfBoundsExceptions. A second user reports that it silently fails to import workflows in Oracle 9i, and JIRA later dies with a NullPointerException.
• The latest 10.1.0.5 driver allegedly fixes the ArrayIndexOutOfBoundsException, and we have at least one report of it working without problems.

Anecdotally, these problems seem to affect 9i users more than 10g. Thus:

• If you are using Oracle 9i, we recommend you avoid Oracle's drivers altogether, and buy the I-net software JDBC driver, which is known to work without problems. Try the 10g driver at your own risk.
• If you are using Oracle 10g, download the 10.1.0.5 driver from Oracle's site.

Each of the problems listed above has been discovered at great cost to our users, and support cases have sometimes dragged for months. We thus strongly recommend avoiding Oracle if you have any choice in the matter, for the benefit of all concerned.

http://www.atlassian.com/software/jira/docs/v3.7.1/databases/oracle.html

i-net software - JDBC drivers for Oracle Server

i-net software offers a full range of JDBC drivers for Oracle Database Servers. From this product line you can pick the driver that fits your requirements best. All Oracle drivers are type 4 drivers, i.e., the drivers are completely written in Java and can be deployed on every platform.

Why should you choose an Oracle driver from i-net software?

* fast; compared with other drivers i-net drivers are up to 3 times as fast.
* small; The sizes of our drivers are between 90 KB to 200KB. By comparison, Oracle's driver is over 1 MB in size.
* very stable; Find out for yourself about the stability of other vendors' drivers - and compare!
* thread safe; This is a MUST for developers working with multiple threads!
* strictly complies with JDBC; i-net drivers have no extra API, all features were implemented complying with the standard JDBC API, therefore, it is very straightforward to generate an application accessing different DBMS without changing the code! This also makes sure i-net drivers can be easily used in third party tools.

Which driver edition should I use?

• The choice of the right JDBC driver depends on the Java version of your system.
• An overview about available JDBC features can be found in the Feature Matrix.
• If you have any questions please contact our sales team.

http://www.inetsoftware.de/products/jdbc/oracle/