Using IBM Optim pureQuery Runtime is another way for Java Persistence API (JPA) to access a DB2® and Informix® databases. IBM Optim pureQuery Runtime supports static Structured Query Language (SQL).
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100"/>
The Feature Pack for OSGi Applications and Java Persistence API (JPA) 2.0 introduces support for IBM Optim pureQuery Runtime 2.2.0.2 and later. The new feature added for IBM Optim pureQuery Runtime 2.2.0.3, supports Informix, and DB2 applications to use IBM Optim pureQuery Runtime in DYNAMIC mode.
This is achieved by setting up pdqProperties on the data source in the Java Enterprise Edition (Java EE) environment. Or, setting pdqProperties on the connection URL in the Java Standard Edition (Java SE) environment.
If pdqProperties is not defined, IBM Optim pureQuery Runtime runs in compatible mode, which means that the pdqxml file is packaged in the application Java archive (JAR) files.
There are several topics that reference pdqProperties in the IBM® Integrated Data Management information center.
In this information ...Related tasks
| IBM Redbooks, demos, education, and more(Index) |