MYSQL JDBC DRIVER

The Most Reliable, Best Performing MySQL JDBC Driver

DataDirect Type 5 Architecture MySQL JDBC Driver
Click to enlarge

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

Try it now – MySQL JDBC Driver download.

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

BENEFITS
FEATURES

Fast response times and exceptional scalability for business-critical software deployments	Clear performance winner - in benchmark tests comparing updates, inserts, fetches, and parameter-based processing 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	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 Oracle, SQL Server, DB2, 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 or expensive server configurations Load balancing - Works with failover to help distribute new connections so that no one server is overwhelmed with connection requests
Ensure 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.

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