Obxxxsvr.properties

From Plex-XML

Obxxxsvr.properties contains properties for Plex Javaserver functions. Since Plex 6.1 you don't need the "xxx" in the name.

There are some extended properties used for Plex-XML:

Environment.Default.ForUpdate=true or for a special connection Environment.Default.DBCon.FooConnection.ForUpdate=true
- When set to true a Fetch For Update will be used in UpdateRow functions in Jave. Be sure that your JDBC handler supports this and watch out for additional configuration options like they could be used for the jtopen driver for iSeries (JDBC#JTOpen_IBM_Toolbox_for_i5_.2F_AS400)

SecurityServer.System=*THIS
- DB and Server location of the Plex-XML Security and Format-Fields functions.

FromQualifier-<Groupnmodell-Name>=<schemaname>.
- Could be used for different SQL schema (/400 libraries) name that should be used in dynamic SQL-Statements. Each group modell can have it's own schema name.
- Entry is required for each group modell otherwise there will get a SQL-Error
- Example: FromQualifier-SECXML=MYLIB. --> select a.field1, a.field2 from MYLIB.MyTable a where...
- Example: FromQualifier-SECXML= --> select a.field1, a.field2 from MyTable a where...

SearchUpper=Yes
- All char search fields will be used case-insensitive. This setting may cause performance problems on some DB because they can't use indices with UPPER().
- Be aware that the AS/400 or System i (a least until V5R4M0) will switch to the old CQE-Optimizer if you use the upper() function.
- Example: select ... where UPPER(a.field1)='XXX'...

Hint: The Fulltext-Search feature that could be customized in the formats will always search with UPPER

de.allabout.db.name=mssql
- DB-Type for the usage of fetch first n / top n / limit n records in FindBrowse select statements
- Valid values are mssql, mysql, db2

de.allabout.xml.sessioncheck=true|false|cache
- Session validation turned on/off for the whole application.
- 'cache' should be used. All session checks and counters are done in cache and will be periodically (see System Parameter) to DB.

de.allabout.xml.securitycheck=true|false
- Function level security validation turned on/off for the whole application.

de.allabout.xml.translation=
- Usage of a special dictionary for function translations
- de.allabout.xml.translation= for normal all about Lookup table from security
- de.allabout.xml.translation=TOTable for ACTI