N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

IBM DB2 JDBC DRIVER

The Most Reliable, Best Performing IBM DB2 JDBC Driver

DataDirect Type 5 Architecture DB2 JDBC Driver
Click to enlarge

The Progress DataDirect Type 5 DB2 JDBC driver delivers the best performance and scalability for Java applications connecting to IBM DB2. DataDirect Connect for JDBC provides the benefits of Type 5 features across all DB2 versions and platforms.

Try it now – DB2 JDBC Driver download.

  • Solves the limitations of Type 4 DB2 JDBC drivers
  • Supports simultaneous connections to all supported versions of DB2 from one Type 5 JDBC driver
  • Consistently leads the industry in performance and scalability in SPECjAppServer/ECPerf industry benchmarks
  • Provides robust JDBC 3.0 / JDBC 4.0 feature set
  • Offers high-performance Bulk Load capabilities
  • Supports advanced DB2 9.7 features



Improves the performance and scalability of your Java applications
  • Clear performance winner - in benchmark tests comparing updates, inserts, fetches, and parameter-based processing
  • High-performance Bulk Load - enables loading large amounts of data into DB2 very quickly, without requiring application code changes or additional bulk load tools
  • Easy-to-use tuning options - Control the amount of data returned across the network on single roundtrips from the DB2 server, without making application code changes
Provides comprehensive database/platform coverage from one vendor
  • One DB2 JDBC driver - regardless of database version or platform
  • One vendor – for all your data connectivity needs (JDBC, ODBC, .NET) for any major database—SQL Server, Oracle, DB2, Sybase, and more, while offering extensive platform support
Makes it easy and cost effective to support multiple databases and database versions
  • One DB2 JDBC driver - for simultaneous connections to all DB2 database versions and platforms, including Windows, UNIX, Linux, iSeries (AS/400), and z/OS (OS/390), significantly reducing the costs of deploying and testing applications against multiple versions of DB2
  • Interoperability features - A common architecture across drivers and robust interoperability features such as SQL up-leveling greatly simplify the task of supporting other databases in addition to DB2, such as Oracle, SQL Server, Sybase, and more
Delivers simple, easy-to-use high availability for any application
  • Application failover – Automatically and transparently redirects requests to an alternate database server if the primary server is unavailable because of a hardware failure or traffic overload, without requiring changes to application code
  • Load balancing - Works with failover to help distribute new connections so that no one server is overwhelmed with connection requests
Enables single sign-on and end-to-end data encryption
  • SSL data encryption - secures the integrity of your data and provides client/server authentication
  • Operating system authentication via Kerberos - allows you to include database access in a Single Sign-On environment
Guarantees reliability for demanding production environments

DataDirect's DB2 JDBC driver is quality tested and certified with:

  • Sun’s Compatibility Test Suite (CTS)
  • DataDirect’s JDBC Verification Suite - the largest, most mature JDBC testing infrastructure, which tests all JDKs, multiple connection modes, and Java application servers
  • Hibernate Certification Test Kit - guarantees the highest level of compatibility, performance, scalability, and reliability when using DataDirect JDBC drivers with Hibernate
Ensures 100% specification compliance and robust functionality
  • JDBC 3.0 / JDBC 4.0 full compliance – supports key functionality, such as validating connections, getting and setting client information, and automatically loading the driver by the Java SE 6 VM
  • Robust functionality - Bulk Load, Multiple Open ResultSets, Statement Pooling, Freeze/Unfreeze Statement Pool, Connection Pooling and Management, Load Balancing, and Failover
  • Robust data type support – timestamp values, Savepoints, and resource clean up
Reduces total cost of ownership through superior technical support
  • Award-winning technical support - Focused on database connectivity, our 24x7 support can help you resolve data connectivity issues quickly; includes phone, web, email, forum, and an extensive knowledgebase

 

Performance

  • SPECjAppServer/ECPerf performance benchmark leader
  • Multiple connection tuning options and easy driver tuning
  • Bulk load operations
  • Pooling and managing connections
  • Statement pooling
  • Freeze/Unfreeze pooled statements
  • Data conversion
  • Socket management
  • Network wire management
  • Batching and throughput optimization

Security

  • OS authentication (aka Single Sign-On) via Kerberos
  • SSL data encryption

Enterprise Application Functionality

DB2 v9.7 on Linux, UNIX, and Windows Feature Support

  • 256-bit AES encryption
  • Currently Committed Transaction Isolation
  • Statement Concentrator
  • Inline LOBs
  • Oracle compatibility data types
  • New Functions and SQL syntax

Specification Compliance / Support

  • Java SE 6.0
  • JDBC 3.0
  • JDBC 4.0
  • J2EE Certified for 1.4, 1.3, 1.2 Compatibility Test Suites (CTS)
  • Certified with J2EE Connector Architecture (resource adapters)
  • Supports any Java-enabled platform that supports JDK 1.4 or higher*

*Java SE 6 or higher required to use JDBC 4.0 functionality

Additional DB2 JDBC Driver Functionality

 

Email Print Share

Download JDBC Drivers

Spotlight - What's New

Coming Soon - SQL Server PDW Support

Connect for JDBC Release 5.0.1

Bulk Load Support

Free Webinar

These Go to 11: Are Type 5 JDBC Drivers More Than Type 4+1?

Spotlight - Platform Support

Hibernate

JBoss

WebSphere