MYSQL JDBC DRIVER

The Most Reliable, Best Performing JDBC Driver for MySQL

Developed in partnership with MySQL AB (now part of Oracle Corporation), Progress DataDirect offers its industry-standard, 100% Type 5 JDBC drivers for MySQL Enterprise.  




  • Solves the limitations of Type 4 JDBC driversLearn more about JDBC Performance
  • Reliable, enterprise-class data connectivity for MySQL Enterprise
  • High-end performance and scalability
  • Robust Bulk Load operations

DataDirect JDBC Drivers
Click to enlarge

 

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

  • SSL data encryption
  • Password encryption

Enterprise Application Functionality

  • Application failover and load balancing
  • SQL Up-Leveling
  • Fully internationalized—Unicode, double-byte, multi-byte
  • Interoperability between databases and different versions of each database

Driver Functionality

  • Hibernate certification
  • JTA/JTS support
  • Supports InnoDB, MyISAM, and Memory (HEAP) storage engines
  • Supports deployment into any standard web or application server environment including, but not limited to, Apache's Jakarta projects (Tomcat, Turbine, Velocity, etc.), JBoss, BEA WebLogic, and IBM WebSphere Application Server
  • Auto-generated keys
  • Full Calendar Support
  • Server-side prepared statements
  • Statement pooling
  • Stored procedures
  • Streaming result sets
  • Large BLOBs and CLOBs
  • Parameter metadata for a variety of statement types
  • Batches
  • Scroll-sensitivity
  • Robust data type support such as timestamp values
  • Savepoints
  • Multiple open result sets
  • Parameter meta data
  • Testing and debugging tools

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

 

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 MySQL 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 database server, without making application code changes

Provides comprehensive database/platform coverage from one vendor

  • One vendor – for all your data connectivity needs (JDBC, ODBC, .NET) for any major database - MySQL, 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

  • 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 MySQL, such as DB2, 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

Ensures data integrity

  • SSL data encryption - secures the integrity of your data and provides password encryption

Guarantees reliability for demanding production environments

DataDirect JDBC drivers for MySQL are 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

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, fax, and an extensive knowledgebase

 

Email Print Share

Download JDBC Drivers

Spotlight - What's New

Connect for JDBC Release 4.2

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