Using pureQuery in dynamic versus static mode for DB2 and Informix
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).
Before you begin
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100"/>
About this task
The Feature Pack for OSGi Applications and Java Persistence API (JPA) 2.0 introduced support for IBM Optim PureQuery Runtime 2.2.0.2 and later. The feature added for IBM Optim PureQuery Runtime 2.2.0.3, supports Informix, and DB2 applications to use pureQuery 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, pureQuery 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 documentation.