DataDirect Connect for JDBC - Supports Oracle, SQL Server, DB2, Sybase, Informix, and MySQL

View PDF

DataDirect Connect for JDBC is the fastest and most comprehensive suite of Type 4 JDBC drivers for all major databases. DataDirect 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 Operating System (OS) authentication for Microsoft SQL Server, Oracle, DB2 and Sybase. (See our Security Support Matrix for complete information on the type of security features supported for each of the major databases and how these features are supported.)

DataDirect Connect for JDBC consistently supports the latest database features and is fully compliant with Java SE 6.0 and JDBC 4.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, SQL Server, DB2, Sybase, Informix, and MySQL

DataDirect Connect for JDBC offers the same high performance and rich functionality no matter what database connectivity you need—whether for Oracle, SQL Server, DB2, Sybase, Informix, or MySQL.

  • 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, 10g, and 11g
  • New MySQL JDBC driver – DataDirect quality, reliability, and interoperability for MySQL
  • 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 SpecJAppServer benchmark, which is the industry standard for measuring application server performance and scalability.

Proven drivers with Robust JDBC 3.0 / JDBC 4.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

  • New MySQL driver – DataDirect quality, reliability, and interoperability for MySQL
  • Fully complies with JDBC 4.0 – Including robust support for the SQL 2003 XML data type, more fine-grained control over connection and statement pooling, support for validating connections and getting and setting client information, support for automatically loading the driver by the Java SE 6 VM, and many developer productivity features such as more efficient debugging of SQLExceptions.
  • JDBC 4.0 Support – Supports select JDBC 4.0 features such as validating connections, the ability to get and set client information, and support for automatically loading the driver by the Java SE 6 VM.
  • Robust JDBC 3.0 implementation – Supports important features such as Savepoints, Statement Pooling, Connection Pooling, 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).
  • Certified with Sun's J2EE Connector Architecture – Provides resource adapters as an installable option for J2EE application servers.
  • SQL Server 2005 and 2008 Features – Support for new SQL Server 2005 and 2008 data types, along with Snapshot Transaction Isolation Levels, DML with Results, and Multiple Open Result Sets support.
  • Oracle – Supports new Oracle 10g Float and Double Data types. Supports Oracle RAC with connection fail-over and load balancing. Supports Oracle 10gR2.
  • 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/Single Sign-On support for Microsoft SQL Server, Oracle, DB2 and Sybase. Includes the only true Type 4 JDBC driver to support this feature for Microsoft SQL Server. Multiple authentication choices (Kerberos, NTLM, Client and User Id/Password) provide for greater deployment functionality. (See our Security Support Matrix for more information.)
  • Support for SSL data encryption – Protects critical data transmitted between the application and the database server. (See our Security Support Matrix for more information.)
  • 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 (R1-R2), and Oracle 11g
  • Microsoft SQL Server 7, SQL Server 2000, SQL Server 2005 and SQL Server 2008
  • Informix Dynamic Server version 9.2, 9.3, 9.4, 10, and 11
  • Sybase Adaptive Server (ASE) 11.x, 12.0, 12.5, 12.5.1, 12.5.2, 12.5.3, 12.5.4 and 15
  • IBM DB2 UDB version 7.x, 8.x, 9.1, and 9.5 for Linux, Unix, Windows, and z/OS. Version 7.x and 8.1 for z/OS, and v5R1, v5R2 and v5R3 and v5R4 for AS/400.
  • MySQL Enterprise database version 5.0

Supports any Java-enabled platform that supports JDK 1.4 or higher, with some restrictions.*

*JDK 6.0 or higher required to use JDBC 4.0 features and functionality.

Ready to try DataDirect Connect for JDBC?