DataDirect Connect® For JDBC

DataDirect Connect® For JDBC boxshot.

Request a call back about this product

DataDirect Connect® For JDBC

Published By:  Progress DataDirect

DataDirect Connect for JDBC - Supports Oracle, SQL Server, DB2, Sybase, Informix, and MySQL.

Product Variants

For advice on this product or for a quote, please contact us or click here to request a call back.

New Features

DataDirect Connect for JDBC is the fastest and most comprehensive suite of Type 4 JDBC drivers. It is the SPECjAppServer/ECPerf performance and scalability leader, and supports advanced functionality such as automated application failover, distributed transactions, connection pooling, as well as OS authentication and SSL support for Oracle, DB2, Microsoft SQL Server, and Sybase.

DataDirect Connect for JDBC consistently supports the latest database features and is fully compliant with Java SE 6.0 and JDBC 4.0 functionality.

DataDirect Connect for JDBC offers multiple, configurable application failover options and robust security features such as operating system authentication for creating a Single Sign-On environment and SSL to protect critical data. See our Security Support Matrix for complete information on the security features of DataDirect Connect.

What's new in Release 4?

JDBC 4.0 Specification Support

All DataDirect Connect for JDBC drivers fully comply with the JDBC 4.0 specification, supporting features that greatly increase developer productivity and make for better functioning, more robust applications.

The JDBC 4.0 API specification is a significant advance in the standard, containing many important new features such as robust support for the SQL 2003 XML data type, more control over connection and statement pooling for high-end application performance and scalability, and many features that make it easier for developers to write JDBC applications, including far more efficient debugging of SQLExceptions.

DataDirect Technologies provides full support for the specification, including support for optional 4.0 capabilities. This support is described in more detail below.

The following JDBC 4.0 features are supported:
  • A Wrapper Pattern interface provides a mechanism for accessing an instance of a resource, which may have been wrapped for architectural reasons. This provides a standard means of interfacing with proprietary or vendor-specific implementations, eliminating the need to write complex code and object casting.
  • LOB creation has been simplified with the introduction of a connection interface that makes it easier to support the creation of BLOB, CLOB and NCLOB objects. LOB enhancements have also been added that provide the ability to free memory related to LOB types without having to wait for the JVM garbage collection process.
  • Statement pooling control has been enhanced to provide control over whether or not individual statements are pooled. This leads to better performance since an application can only pool statements that are likely to be re-used, minimising the potential for a frequently used statement to be removed from the pool.
  • Connection isValid ¿ DataDirect supports the ability to determine whether a connection is valid using a JDBC standard API. This functionality previously available as an optional proprietary method is a common operation performed by connection pool managers.
  • Connection Client Info ¿ DataDirect supports the ability to get and set client information using standard JDBC 4.0 APIs. This functionality previously available as proprietary APIs can be used to distinguish between connections in a pool that are typically created using the same user id and password. This information is necessary to determine which application is using a connection; it also provides the ability to identify the source of a run-away query, as well as usage statistics that can be used to adjust the priority of work. DataDirect provides the ability to set the client information through easily configurable connect options.
  • Auto Load Driver ¿ DataDirect drivers can be automatically loaded by the Java SE 6 VM. This important ease of development feature of the JDBC 4.0 specification eliminates the need to register the JDBC driver in the application.

The following 4.0 Optional Features are supported:
  • JDBC 4.0 now supports the SQLXML data type and provides Java XML bindings. This eliminates the need to use either JDBC driver extensions to transfer data to or from the database or use the CLOB interface, which is limited in nature to a string representation of the XML. Since the SQLXML data type is now a 'first-class citizen' to JDBC, developers can use standard DOM, SAX, StAX results and streams in order to process the data.
  • The SQLException capability has been enhanced to provide finer grained control for managing SQL exceptions. The exceptions returned by the driver are now more specific, eliminating code that was necessary to determine the higher-level reason for the error. The SQLException can now be checked vs. checking numerous different SQLStates. The exception handling now distinguishes between transient (might succeed if retried) or not transient (won't succeed if retried), so that errors that are 'expected' or not can be processed more efficiently.
  • Along with SQLXML support, DataDirect now supports several data types and standard bindings for nationalised character sets, including NCHAR, NVARCHAR, NLONGVARCHAR and NCLOB. Native support for these data types allows the driver and the developer to work with the explicit data type, which results in better efficiency at run-time between driver and the server.
  • All new JDBC 4.0 Types are able to be set and retrieved from all objects in a standards-based manner and are fully supported across all statement and resultSet object types.
  • New JDBC 4.0 methods were added to make coding easier by making the interfaces support more type conversions in the driver, removing the complexity of these conversions from the application.
  • Support for the JDBC 4.0 Statement Event Listener.

Application Failover Support

To ensure continuous, uninterrupted access to data, DataDirect Connect for JDBC provides the following three levels of failover protection, listed from basic to more comprehensive:
  • Connection failover provides failover protection for new connections only. The driver fails over new connections to an alternate, or backup, database server if the primary database server is unavailable, for example, because of a hardware failure or traffic overload. If a connection to the database is lost, or dropped, the driver does not fail over the connection. This failover method is the default.
  • Extended connection failover provides failover protection for new connections and lost database connections. If a connection to the database is lost, the driver fails over the connection to an alternate server, preserving the state of the connection at the time it was lost, but not any work in progress.
  • Select failover provides failover protection for new connections and lost database connections. In addition, it provides protection for Select statements that have work in progress. If a connection to the database is lost, the driver fails over the connection to an alternate server, preserving the state of the connection at the time it was lost and preserving the state of any work being performed by Select statements.

DB2-Specific Features
  • Support for DB2 v9.5.
  • Support for the IBM Workload Manager (WLM) has been enhanced so that developers can specify performance goals and assign business importance to JDBC processing. For instance, if you want to ensure that 70% of the transactions using the DataDirect Connect for JDBC driver complete within one second, you would use WLM to configure a rule to do so. WLM keeps track of the work running on the system and configures system resources in order to satisfy this goal. DataDirect's support for this feature has been implemented using connection options so that this capability can be leveraged without making code changes. WLM support has also been integrated into the DataDirect Performance Wizard for easy configuration.
  • SSL support (introduced for other databases in version 3.7) has been expanded to include support for DB2, including DB2 v9.1 support for Linux, Windows and UNIX, DB2 v9 for z/OS, and AS/400 v5r3, v5r4 and v6r1.
  • XMLSchema support allows validation of XML data that is inserted into the database by leveraging the XMLSchema defined in the database.
  • XQuery Update Expressions support the new syntax for updating XML documents via XQuery expressions.
  • Database Compression support allows the compression capability supported by the database engine to be leveraged with DataDirect Connect for JDBC. The compression capability saves space on the database server and provides optimal performance.

Oracle-Specific Features
  • Support for Oracle 11g.
  • Table and Tablespace Compression support allows the compression capability supported by the database engine to be leveraged with DataDirect Connect for JDBC. The compression capability saves space on the database server and provides optimal performance.
  • Transparent Data Encryption / Tablespace Encryption support allows developers to leverage the encryption capability provided by Oracle. Any interaction that takes place with data that is encrypted on the Oracle server by the DataDirect Connect for JDBC driver will work seamlessly.
  • Server side result set caching support allows applications that use DataDirect Connect for JDBC to leverage caching capability provided by Oracle, which provides superior performance and scalability. If you use other drivers, each SQL statement needs to be modified in order to leverage the caching capability. DataDirect automatically inserts the hint syntax necessary to enable caching, thereby eliminating the need to make code changes. Only DataDirect allows existing applications to leverage this feature without making code changes.
  • New performance tuning connection options for Oracle: initialColumnBufferSize, SDUSize, and stringParamsMustMatchCharColumns. (Available with Service Pack 1).

SQL Server-Specific Features
  • Support for SQL Server 2008 (Available with Service Pack 1.)
  • Support for the following new SQL Server 2008 data types: Date, Time, Datetime2, DatetimeOffset (support for these data types is available with Service Pack 1)

MySQL-Specific Features
  • Support for data encryption over the network to MySQL databases via SSL (Available with Service Pack 1)

Additional features available in Service Pack 1
  • Support for SQL Server 2008 including new data types
  • Additional Oracle performance tuning options
  • Support for data encryption over the network to MySQL via SSL

Licensing Options for DataDirect Technologies Products
DataDirect Technologies offers two types of licensing options for this product: Workstation, and Server licenses. If you are unsure as to which type of license you require, please contact DataDirect Technologies and we will help you determine the appropriate license type. In addition to ensuring that you are licensed properly based on your deployment, the server driver offers functionality critical for success in high performance server-based applications. This additional functionality, such as connection pooling and distributed transactions, is not available in our Authorized User and Workstation products.

Authorized User Basis. If the Product is licensed on an Authorized User basis, the Product may be used on a single computing machine which may be accessed by the number of Authorized Users specified in the Order Letter. An Authorized User is a single individual who has been designated to use the Product. In no event shall the number of persons authorized to have access to the Product exceed the number of Authorized Users identified in the Order Letter. The right to use the Product is not based on concurrent users, but instead on an actual ¿Authorized User¿ basis. User must, upon request by DataDirect, identify each Authorized User who will have access to the Product and provide that information to DataDirect.

Workstation Basis. If the Product is licensed on a Workstation basis, each Workstation using or accessing the Product must be licensed. A license must be purchased for each Workstation using or accessing the Product. A ¿Workstation¿ shall be defined as a computer that is operated, either attended or via remote access, by one person at a time, and cannot be used by more than one person, directly or indirectly, simultaneously. In no event shall the number of workstations utilizing or accessing the Product exceed the number of Workstations identified in the Order Letter.

Server Basis. If the Product is licensed on a Server basis, then a license fee must be paid for the maximum number of processors (¿CPUs¿) utilized by the Server whether or not such access is simultaneous or consecutive. Servers utilizing dual core processing (or multiple core processing) or other multi-processor technology shall have each core processor count as one (1) CPU. The Product may only be used by server-based applications running on that server accessed by other computers and may not be installed via file sharing on a local area network file system. A ¿Server¿ shall be defined as a logical computer with one or more CPUs on which the Product resides, along with the applications utilizing the Product, and which can be accessed by other computers. The term ¿Server¿ includes, but is not limited to, web servers, batch servers and application servers.

SupportLink is mandatory on all supported versions and must be included on all quotations. See the section on SupportLink for the definition of supported versions.

SupportLink offers unlimited over-the-phone access to SupportLink Live experts, and SupportLink Online, a members-only global service network which provides online case reporting, downloadable product fixes and upgrades, diagnostic tools and utilities, and the industry's largest data connectivity knowledgebase.

DataDirect Technologies' SupportLink provides you with a whole year of support by phone, email and web. It also provides you with product releases to help with bug fixes and minor enhancements.

SupportLink Live
DataDirect's toll-free support service providing access to SupportLink experts Monday through Friday, 2 AM EST to 8 PM EST, excluding holidays, and 24 hour emergency beeper service.

SupportLink Online
SupportLink subscribers have unlimited access to a password-protected global online service network for automated case reporting, knowledgbase, product updates, lifecycle information, documentation, and service packs.

Product Updates
SupportLink subscribers, upon request, receive all new releases of licensed product(s) in the quantity covered by their contract.

Reinstatement Fees
Customers whose annual SupportLink has been expired for more than 30 days will be charged a reinstatement fee equal to 20% of their total maintenance bill. In addition they will be charged for maintenance services extending back to the date of expiration.
Shopping Basket
    0 Item(s)

    View and amend your basket
    ISV Royalty Licensing