DataDirect Connect for JDBC - Oracle JDBC Driver, SQL Server JDBC Driver, DB2 JDBC Driver, Informix JDBC Driver, and More

DataDirect Connect for JDBC is the fastest and most comprehensive suite of Type 4 JDBC drivers for all major databases. Connect for JDBC is the SPECjAppServer/ECPerf performance and scalability leader, and supports advanced functionality such as distributed transactions, connection pooling, updating BLOB/CLOB data types, and Windows authentication for Microsoft SQL Server and Oracle. Connect for JDBC consistently supports the latest database features and is fully compliant with J2SE 5.0 and JDBC 3.0. Using DataDirect Connect for JDBC, developers can easily build database-independent applications - a common architecture across all major databases makes it easy to switch databases or upgrade to new versions of an existing database.

Only comprehensive set of JDBC drivers for all major databases: Oracle JDBC Driver - SQL Server JDBC Driver - DB2 JDBC Driver - Informix JDBC Driver - Sybase JDBC Driver
DataDirect Connect for JDBC offers the same high performance and rich functionality no matter what database connectivity you need—whether for Oracle JDBC, DB2 JDBC, SQL Server JDBC, Sybase JDBC, or Informix JDBC.

Full JTA (Java Transaction Architecture) support across all databases
One DB2 JDBC driver supports DB2 on all available backend platforms—Windows, Unix, Linux, OS/390, z/OS, and iSeries (AS/400)
One Oracle JDBC driver supports Oracle 8i, 9i, and 10g
Current with all the latest releases of the databases and supports older releases
Our common architecture enables database-independent application development, reducing development effort and allowing developers to complete projects far more quickly.

Performance and scalability leader
DataDirect Connect for JDBC is the best performing suite of JDBC drivers using the SpecJAppServer2002 benchmark, which is the industry standard for measuring application server performance and scalability.

Proven drivers with robust JDBC 3.0 implementation
Supports performance-oriented and enterprise functionality such as distributed transactions, savepoints, connection pooling, statement pooling, multiple open result sets and parameter metadata
J2EE Compatibility Test Suite (CTS) certified and tested with the largest JDBC test suite in the industry
Includes a full SDK with tools for testing and debugging JDBC applications
Features
Robust JDBC 3.0 implementation – Supports important features such as Savepoints, Statement Pooling, Connection Pooling configuration options, CLOB/BLOB updates, ParameterMetaData, new DatabaseMetaData methods, Multiple Open Result Sets and retrieval of auto-generated keys.
Performance Tuning Wizard automatically optimizes the driver based on application characteristics.
J2EE Certified for the 1.4, 1.3 and 1.2 Compatibility Test Suites (CTS) for DB2, Informix, Oracle, SQL Server, and Sybase.
Certified with Sun’s J2EE Connector Architecture - Provides resource adapters as an installable option for J2EE application servers.
Oracle – Supports new Oracle 10g Float and Double Data types. Supports Oracle RAC with connection fail-over and load balancing.
Connection fail-over support and load balancing for all databases.
Developer productivity tools – SDK includes DataDirect Test for JDBC for debugging applications; and DataDirect Spy for JDBC, a utility for tracing JDBC calls in running programs.
OS Authentication support for Microsoft SQL Server and Oracle. Includes the only true Type 4 JDBC driver to support this feature for Microsoft SQL Server. Multiple implementation choices (Type 2 and Type 4) provide for greater deployment flexibility.
Support for distributed transactions across all major databases - JTA/JTS (Java Transaction Architecture/Java Transaction Services) support for Oracle, SQL Server, Informix, Sybase, and DB2.
Fully internationalized - Unicode, double-byte, and multi-byte support.
Databases Supported
Oracle 8i (8.1.6 and 8.1.7), Oracle 9i (R1-R2), Oracle 10g
Microsoft SQL Server 7; 2000 (including SP1, SP2 and SP3); 2000 Enterprise Edition (64 bit); and 2000 Desktop Engine (MSDE 2000)
Informix Dynamic Server 9.2, 9.3, 9.4, and 10
Sybase Adaptive Server 11.5 and higher; Sybase Adaptive Server Enterprise 12.0, 12.5, 12.5.1, 12.5.2, and 12.5.3
IBM DB2 UDB 7.x and 8.x for Windows, Unix, Linux and Linux/s390; IBM DB2 UDB 6.x, 7.x, and v8.1 for OS/390 and z/OS; and IBM DB2 UDB V4R5, V5R1, V5R2, and V5R3 for iSeries (AS/400)
Supports any Java enabled platform that supports J2SE 1.3 or higher, with some restrictions.*

*J2SE 1.3.1 or higher is required to use the resource adapters.

J2SE1.4 or higher is required to use JDBC 3.0 functionality and Windows Authentication for SQL Server/Oracle.

Progress Products and Services

Progress Software Corporation delivers products and services through its operating units:

Progress OpenEdge Division

The Progress OpenEdge Division offers a complete platform for developing and deploying business applications. Through its standards-based, service-oriented architecture OpenEdge allows the development of business applications that can be deployed and managed over a wide range of computing platforms and across the Internet. OpenEdge offers a unified environment including development tools, application servers, flexible integration options, its market leading embedded Progress database, and systems management tools.

DataDirect Technologies

DataDirect Technologies is the leading provider of components for connecting software to data. Products from DataDirect use industry standard interfaces such as ODBC, JDBC and, ADO.NET to ensure consistent behavior and performance across diverse environments such as J2EE, .NET, Web and client/server. DataDirect also offers an XML development tool, Stylus Studio, and has been instrumental in the development of the XQuery standard for querying and processing XML data.

Sonic Software

Our Sonic Software subsidiary is the inventor and leading provider of the Enterprise Service Bus (ESB), the standards-based foundation for building a Service Oriented Architecture, or SOA. Sonic products provide reliable, manageable and cost-effective distributed infrastructure to integrate applications and orchestrate business processes across the extended enterprise.
Read more about Sonic Software

Our Progress Real Time Division provides event stream processing, data management, data access, and synchronization products to enable the real-time enterprise. Our products monitor and analyze real-time event stream data for applications such as algorithmic trading and RFID; accelerate the performance of existing databases through sophisticated caching; manage and process complex data in the industry’s leading object database; and support occasionally connected or mobile users requiring real-time access to enterprise applications.