3.5.4.2. FirebirdDictionary Properties

The firebird dictionary understands the following additional properties:

  • FirebirdVersion: The database version OpenJPA connects to. This property affects the SQL statements executed by OpenJPA. Available values are: 15, 20 and 21 - they indicate Firebird versions 1.5, 2.0 and 2.1 respectively. If not set, the value will be auto-detected.

  • IndexedVarcharMaxSizeFB15: Firebird 1.5 imposes tight limits on index size. In particular, an indexed VARCHAR column size cannot exceed 252. When schema is created, OpenJPA will use this property to reduce the size of indexed VARCHAR columns. Defaults to 252 but you might want to decrease this value if multi-column indexes are used. If the Firebird version is 2.0 or later or schema creation is not used, this property does not matter.

  • RangeSyntax: Firebird 2.0 and later support two ways of handling queries that select a range of data: "FIRST <p> SKIP <q>" and "ROWS <m> TO <n>". Earlier versions support only "FIRST <p> SKIP <q>" syntax. This property determines the syntax to be used. Available values are: "firstskip" and "rows". Defaults to using "ROWS <m> TO <n>" if the Firebird version is 2.0 or later, and "FIRST <p> SKIP <q>" otherwise.