Obxxxsvr.properties

From Plex-XML

Jump to: navigation, search

Obxxxsvr.properties contains properties for Plex Javaserver functions.


There are some extended properties used for Plex-XML:

  • 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'...
Image:Hint.png 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


  • Properties for LDAP user validation and user managment
    • LDAP.Basename= @LDAP-Basename@
    • LDAP.User= @LDAP-User@
    • LDAP.Password= @LDAP-Password@
    • LDAP.Host= @LDAP-Host@
    • LDAP.Port= @LDAP-Port@
Personal tools