DataDirect Connect for JDBC - Supports Oracle, SQL Server, DB2, Sybase, Informix, and MySQL
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 Operating System (OS) authentication for Microsoft SQL Server, Oracle, DB2 and Sybase. Connect for JDBC consistently supports the latest database features and is fully compliant with Java SE 6.0, Java EE 5, JDBC 3.0, and select JDBC 4.0 functionality. 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 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
- 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 Features – Support for MAX data types, XML data type, Snapshot transaction isolation levels, DML with Results, and Multiple Open Result Sets.
- 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.
- Support for SSL data encryption – Protects critical data transmitted between the application and the database server
- 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, and SQL Server 2005
- 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 and 9.1 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 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 OS Authentication for SQL Server/Oracle/DB2/Sybase. J2SE 1.4 is also required for JSR-114 Rowset support.
