3.5.4.6. DB2 Properties

The db2 dictionary understands the following additional properties:

  • AppendExtendedExceptionText: If false, OpenJPA will not call back to the database to get extended exception text.

  • SupportsRowNum: If true, OpenJPA will use ROWNUM facility for range based queries that set an offset and/or limit via setFirstResult() and setMaxResult() query methods. This property must be set to true alongwith SupportsSelectStartIndex and SupportsSelectEndIndex. By default, SupportsRowNum is set to false. It is appropriate to set SupportsRowNum to true only when DB2 version being used is 9.7 or later.