ODBC, JDBC and ADO.Net Extensive Testing

DataDirect Technologies' ODBC, JDBC and ADO.NET data connectivity components are rigorously tested under production conditions using our proprietary in-house testing suites, which have evolved over 17 years to include millions of test cases, multiple connection modes and every known bug fix.

Our testing framework features:

  • Industry's largest testing suites for ODBC, JDBC, and ADO.NET
  • Millions of test cases ensure reliability on all supported database and platform versions
  • All major client operating systems, including Windows, Sun Solaris, HP-UX, IBM AIX, and Linux
  • Multiple hardware chipset architectures including Intel Itanium, and AMD/Intel x64
  • All major database versions, including six versions of Oracle and DB2 on Windows, Linux, UNIX, AS/400 and z/OS
  • Over 50 CPUs on UNIX, Windows, Linux, AS/400, including a mainframe
  • Multiple connection modes
  • Constant regression testing to guarantee every fix is included in every product version
  • Testing for J2EE CTS and all supported JDKs

The diagram below illustrates our extensive testing framework.

Read about DataDirects extensive testing of ODBC and other platforms
Click Graphic for a full-sized image

To read more about how DataDirect tests its data connectivity products, use the following links for more information.

Largest, Most Mature ODBC Testing Suite includes Millions of Test Cases

Our ODBC testing application, the DataDirect ODBC Verification Suite (OVS), is the largest, most mature ODBC testing infrastructure in existence. The OVS is designed to ensure quality and reliability, verify the latest ODBC specifications, and test against all supported database versions and operating systems.

  • "We have benefited a great deal from the superior performance and flexibility inherent in DataDirect Connect for ODBC. With DataDirect, data connectivity is never a risk in our project plans."
  • Mike Burkes
  • Manager
  • Data Access Services
  • Toyota Motor Sales

The OVS includes:

  • 17,000 tasks run against every permutation of supported database and platform version, resulting in millions of test cases being run
  • Over 200,000 lines and more than 240 modules of portable C code
  • Testing for ODBC compliance

This extensive testing ensures your target database and platform version have been thoroughly tested for quality and functionality, so you don't have to wait until it's time to go into production to find out whether your deployment environment will work.

Comprehensive JDBC Testing Includes All JDKs, Multiple Connection Modes, and Java Application Servers

Our JDBC Verification Suite (JVS) provides the same extensive testing coverage of supported database versions as the OVS, while also testing our JDBC drivers for:

  • Compliance with all supported JDKs
  • Compliance with Sun Microsystems' J2EE CTS (Compatibility Test Suite)
  • Multiple connection modes: pooled, URL, data source and resource adapter, run against all different versions of the Java runtime
  • Integration with customer-supplied applications
  • Compatibility with Java application servers

ADO.NET Data Providers Tested Against All Databases and the Microsoft LTM

As with our ODBC and JDBC drivers, DataDirect Technologies is committed to providing you with the fastest and most functional ADO.NET data providers. Our ADO.NET Verification Suite (ADOVS) provides the same extensive coverage, testing all supported Windows platforms and database versions. We also test ADO.NET conformance using the Microsoft LTM (Local Test Manager). This comprehensive testing ensures that you can develop the most robust .NET solution.

Performance and Scalability Your Customers Demand

To test for performance, our experienced staff uses a wide variety of tests written to exercise the driver, not the network or the database, so driver execution is isolated and measured. Performance tests include:

  • Every area of functionality in which a user is expecting high performance such as inserts, updates, deletes and selects
  • Simple queries to amplify execution of the driver as much as possible, not the database engine
  • Very high volume and batch transactions using an array of parameters for 100 statements at a time
  • Data type conversion and parameter testing
  • Every major database such as DB2, Oracle, and Microsoft SQL Server
  • More than 100 hours or four days for each driver
  • Every product release and most product patches

To test for scalability, we start with one thread and increase the thread count until either the client-side hardware or the server-side hardware reaches saturation. We are always striving to improve over our previous product release, and look for factors such as:

  • Good response time
  • Efficient uses of network traffic
  • Disk I/O usage
  • Efficient use of memory

All these factors are taken into account to maximize the efficiency of the driver for every product release.

A Long Track-Record of Providing Fast and Worry-Free Data Connectivity

DataDirect Technologies' data connectivity products are tested more extensively and proven in more production environments than any other alternative available anywhere. Using DataDirect for your data connectivity middleware will not only make your critical systems and software products more stable, but even help them run faster.

Download Today

Try DataDirect products in your application or software product today. Or call 1-800-876-3101 to speak with an account representative.