Faktor-IPS Persistence Options

Faktor-IPS offers several options to simplify operation and handling in daily use. In today’s blog article, we will introduce you to the persistence options and hope to make your future work easier.

 

Faktor-IPS offers the possibility to configure settings for persisting contract data with JPA directly in the model. The section “PersistenceOptions” in the .ipsproject configuration file controls how names of classes and attributes are translated to table and column names, how long these names may be and how long or exact the values in the columns may be.

In order to be compatible with as many database systems as possible, the default settings of Faktor-IPS have been set to the lowest common denominator.
These restrictions are validated by Faktor-IPS as the number of characters; when using Unicode special characters, the number of bytes required in the database may be higher, depending on the database and encoding, so special characters in table and column names should be used with caution.

 

Database Table Name Column Name Scale Precision Column Size
DB2 128 32 31/79/6144 31/32/34/64 255/4046-32704, depending on page length
Informix 128 128 32 32 255 (32739 for LVARCHAR)
Oracle <= 12.1 32 32 125 38 4000
Oracle >= 12.2 128 128 125 38 32767
Faktor-IPS default 30 30 31 31 4000

 

Your Faktor Zehn-Team

Leave a Comment

Your email address will not be published. Required fields are marked *

Solve : *
26 × 1 =