WebSphere - Oracle Data Connectivity

You use WebSphere as your optimum application server and Oracle as your optimum database engine. Why hinder this investment by using the sub-optimal Oracle Thin JDBC driver, which is known to cause application and performance failures?

These risks, as well as the advantages of using the DataDirect Oracle JDBC driver, are detailed below.

DataDirect Oracle JDBC Driver

Oracle Thin JDBC Driver

Application Risk
DataDirect’s production-proven reliability poses no risk to your WebSphere application.

Using Oracle’s JDBC driver with WebSphere routinely causes memory, thread, and connection issues that have resulted in application failures. These problems are often not experienced until production time due to increased load, greatly exacerbating risk.

Performance
DataDirect is the proven performance and scalability leader based on SPECjAppServer benchmarks.

Average performance with severe limitations for some query conditions.

Advanced Features
DataDirect provides robust functionality, including application failover, industry-standard security features, and full support for JDBC 4.0, all available with Type 4 connectivity. You can leverage most of the DataDirect features without making source code changes.

The Oracle driver is feature incomplete. And some features are only supported with a non-Type 4 driver, requiring deployment of the Oracle native client. Other features are implemented using a proprietary, non-standard approach which limits development flexibility.

JDBC Certification
The DataDirect JDBC driver routinely passes the JavaEE CTS (Certification Test Suite) in addition to DataDirect’s unrivaled JDBC Verification Suite, which ensures high-quality data connectivity.

The Oracle driver fails the JavaEE CTS. Nor are Oracle’s internal testing suites as extensive as DataDirect’s JDBC Verification Suite. This lack of certification and extensive testing can negatively impact the reliability of your application.

Technical Support
DataDirect and IBM have a long history of supporting DataDirect’s Oracle JDBC driver within the WebSphere environment.

You’re likely to encounter difficulties resolving an issue that involves the combination of competitors IBM and Oracle.