+

Search Tips   |   Advanced Search

Extensions to data access APIs


If a single data access API does not provide a complete solution for the applications, use WAS extensions to achieve interoperability between both the JCA and JDBC APIs.

Applications that draw from diverse and complex resource management configurations might require use of both the Java EE Connector Architecture (JCA) API and the JDBC API. However, in some cases the JDBC model does not completely integrate with the JCA (even though full integration is a foundation of the JCA specification). These inconsistencies can limit data access options for an application that uses both APIs. WAS provides API extensions to resolve the compatibility issues.

For example:

Without the benefit of an extension, applications using both APIs cannot modify the properties of a shareable connection after making the connection request, if other handles exist for that connection. (If no other handles are associated with the connection, then the connection properties can be altered.) This limitation stems from an incompatibility between the connection-configuration policies of the APIs:

The Connector Architecture (JCA) spec supports relaying to the resource adapter the specific properties settings at the time you request the connection (using the getConnection() method) by passing in a ConnectionSpec object. The ConnectionSpec object contains the necessary connection properties used to get a connection. After you obtain a connection from this environment, the application does not need to alter the properties. The JDBC programming model, however, does not have the same interface to specify the connection properties. Instead, it gets the connection first, then sets the properties on the connection.

WAS provides the following extensions to fill in such gaps between the JDBC and JCA specifications:





Subtopics


Example: Using IBM® extended APIs for database connections
Example: Using IBM extended APIs to share connections between CMP beans and BMP beans

 

Related concepts


Relational resource adapters and JCA

 

Related information

http://www.ibm.com/support/docview.wss?rs=180&uid=swg27006921