New or updated for this feature pack


Configuring JDBC providers to use IBM Optim pureQuery Runtime to access Informix

Use this task to configure the application data source Java Database Connectivity (JDBC) provider to use IBM Optim pureQuery Runtime to access Informix® in a Java EE environment.

Before you begin

New or updated for this feature pack The Feature Pack for OSGi Applications and JPA 2.0 introduces support for Apache OpenJPA 2.0.

About this task

PureQuery provides heterogeneous batching which performs better than homogeneous batching in JDBC. Applications benefit from heterogeneous batching if updates in a transaction involve many entity types and those entities do not have DB-generated keys. To use pureQuery the JDBC driver must specify the db2jcc.jar file (pureQuery does not work with the Informix legacy JDBC driver, ifxjdbc.jar file) and in the persistence.xml file that is included in the application Java archive (JAR) file must specify the following:
<property name="pdqProperties" value="dynamic"/>
Important:
  • The JDBC provider configuration must include the JAR file for the IBM Optim pureQuery Runtime environment. This JAR file is in addition to the JDBC driver JAR file. For more information, see the documentation about installing IBM Optim pureQuery Runtime.
  • If this is an XA data source, define a new custom property on the data source where property_name = downgradeHoldCursorsUnderXa and boolean value = true.

Procedure

  1. Update the application data source JDBC provider configuration to include the IBM Optim pureQuery Runtime JAR file. Either define an new JDBC provider or modify an existing provider to include the following JAR files. For more information, see the documentation about JDBC provider settings and installing IBM Optim pureQuery Runtime.
    • pdq.jar
    • pdqmgmt.jar
    • db2jcc.jar
  2. Ensure that the persistence.xml file included in the application JAR file defines the following property:
    <property name="pdqProperties" value="dynamic"/>

    See the topic, Using IBM Optim pureQuery Runtime in dynamic mode, for more information.

What to do next

If you want to reconfigure the data source for JDBC, remove the pdq.jar, pdqmgmt.jar, and db2jcc.jar files from the class path and replace these files with the JDBC driver, ifxjdbc.jar file.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Jun 12, 2013 3:32:32 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=v700osgijpa&product=was-nd-mp&topic=tejb_configpdqinformix
File name: tejb_configpdqinformix.html