Skip to main content
Skip table of contents

Server-Parameter

Die folgenden Parameter können zur Konfiguration des manager-Containers verwendet werden.

Die nachfolgenden Inhalte sind nur in englischer Sprache verfügbar.

Server

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

customizing__sys_cu_error_url

string

URL that is displayed in the Problems in System Customizing message and that contains links to the corresponding documentation page in the PLANTA Online Help

customizing__enable_py_service_functions

{0,1}

ppms_license

string

Licence of PLANTA project, default is '000'

database__q1codepage

int

Code page of the system database ( 1 (Windows) to use Windows-1252, 2 (Linux) to use ISO885915 (Latin 9))

database__type

int

Type of system database

  • 2: Oracle

  • 4: MSSQL

default_language

string (f.ex.: de)

Default language for preloading

default_currency

string

Default currency for preloading (not used atm)

default_country

string

Default country for preloading (not used atm)

preload_languages

string (f.ex.: en, fr, ru)

Additional languages for preloading

customizing__dtp_customizing_mode

{0,1}

When enabled, CU metadata will always be up-to-date and no stale values will be used within the session (effectively disables all caching on DTP level). For further information, see here.

intercom__enable_compression

{0,1}

default 1; allows compressed communication with a recent and correctly configured client (see NachrichtenKompression for details)

intercom__compression_level

{0..9}

default 6; defines the compression level with 0:no compression and 9:best compression

customizing__enable_exec_python_script

{0,1}

  • default 1; allows the deactivation of the processing of client_exec()/server_exec() API calls

  • The HeadlessClient is based on this functionality; in case of deactivation, BatchJobs will no longer work!

scheduler__disable_sched_fixes

string

Using these parameters you can disable the fixes listed below.

PERIOD_CAPACITY_CALCULATION_INCLUDING_OVERLOADS

Resolves the problem that in the calculation of an individual project the free capacity of a resource was not always determined correctly which resulted in the incorrect representation of overloads. #23736 (S 39.5.28)

DURATION_REM_COUNTDOWN

Resolves the problem that the remaining load was reduced by one day in any scheduling when the Work reporting date parameter = 0 was used. Caution: This fix is already disabled by default. #7352 (39.5.14)

EFFORT_AGGREGATION_FOR_COLLECTION_TASKS

Resolves the problem that effort which was posted on summary tasks was not summarized to the project. #19450 (S 39.5.22)

DEDUCE_DESIRED_DATES_FROM_RESOURCE_ASSIGNMENTS

Implements the calculation of the requested dates based on the planned resources when the load profiles for manual distribution of effort in time intervals (PM_*) are used. #19537 (S 39.5.22)

MULTI_LEVEL_TASK_COLLECTION_RELATIONSHIP

Corrects the treatment of links in the case of multi-level summary tasks #14941  (S 39.5.17) 

WEAK_RELATIONSHIP_ERRONEOUSLY_EXITS_LOOP

Corrects the treatment of links in the case of multi-level summary tasks #14941  (S 39.5.17) 

TASK_COLLECTION_UNLOAD_DURATION1

Resolves the problem that the remaining duration and actual duration of summary tasks was set to "1" after unloading (S 39.5.17) #14659 #15240

TASK_NOT_PLANNED_LATE

Resolves the problem that tasks were not planned at the latest dates possible when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

REL_IGNORED_PARENT_TASK_NO_WED

Resolves the problems with the calculation of dates when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

REAL_RELATIONSHIP_INHERITANCE

Resolves the problems with links when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

PLAN_LATE_KEEP_ORDER_OF_CALCULATION

Resolves the problems with the calculation sequence when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

PLAN_LATE_KEEP_EARLIEST_DATES

Resolves the problems with the calculation of dates when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

FORCED_DELAY_DONT_PAINT_PREDECESSORS_RED

Resolves the problems with the visualization of delays when working with deactivated Planning early task parameter and cross-summary task links. (S 39.5.17) #15750

customizing__version

earth or venus

Select the customizing version of the planta python library

maintain__gc_keepalive_threshold_megabytes

512

Threshold value for garbage collection.
If the total memory usage of one session exceeds this value, an attempt to release memory will be undertaken, not only during the waiting period but also while the program is running. The default value is 512. For performant scheduling/replanning in large systems, a value between 1024 and 8192 is recommended.

maintain__core_dump_root_path

string

If the application crashes and a core dump is generated, it will be saved here.

From S 39.5.37: If a writeable_path is defined, it will be added to this path.

customizing__debug_python

{0,1}

Enables (1) or disables (0) the remote Python debug interface.

customizing__debug_python_host

string (e.g. localhost)

Hostname or IP address of the debugger client to which the server connects.

customizing__debug_python_port

int (e.g. 5678)

Port number used to establish the connection with the Python debugger.

exit_on_exception

{0,1}

If set to 1, the worker process will terminate immediately upon encountering a critical, unhandled exception.

maintain__system__dimension

small, medium, large

The general size of the system. This parameter sets various other parameters (parallel_sessions, hibernate__c3p0__min_size, hibernate__c3p0__timeout, hibernate__c3p0__max_size, hibernate__c3p0__numHelperThreads) to suitable pre-defined values, unless these parameters have themselves be set to a different value.

maintain__create_core_dumps

{0,1}

Enables (1) or disables (0) the generation of core dumps in case of a crash.

maintain__core_dump_tool_command

string (path or shell command)

Command used to run a tool that processes or generates the core dump.

maintain__create_heap_dumps

{0,1}

Enables (1) heap dump creation in case of critical memory-related issues.

maintain__attach_jit_debugger

{0,1}

Enables (1) automatic attachment of a just-in-time debugger when an error occurs.

maintain__jit_debugger_command

string (shell command)

Command to start the JIT debugger (e.g., gdb, vsjitdebugger, etc.).

database__max_parameters_in_statement

int (e.g. 999)

Maximum number of parameters allowed in a single SQL statement (e.g. for IN clauses).

database__max_split_statements

int (e.g. 100)

Maximum number of SQL statements a single query may be split into.

database__query_by_key_cutoff

int (e.g. 200)

If the number of keys exceeds this threshold, the query will be split or processed differently.

database__query_min_statements_for_stocking

int (e.g. 5)

Optimization will only be applied if at least this many SQL statements are involved.

client_transfer__max_dfs_in_one_message

int (e.g. 1000)

Maximum number of data fields (DFs) that can be sent in a single client-server message.

maintain__planta_pwd_hashing

{0,1}

If enabled (1), passwords will be compared using hashes only, increasing security.

Globals

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

maintain__transform_sql_literals

The internal parsing and replacement of literals can be switched off globally with this parameter

auth__methods

interactive

kerberos

any

  • interactive: the usual login message box, secure due to challenge response authentication. 

    • for a backward-compatible behavior,  auth__methods  is set to  interactive  by default.

    • As long as this value is set, there will be no changes with regard to previous versions.

  • kerberos

  • any: is composed of all implemented authentification methods)

  • or a random combination of the above listed values, separated by blank characters and/or punctuation, so that it results in a conjunction of all mentioned individual or combined methods.

ldap

openidconnect

pki

  • ldap, openidconnect, pki: authentication via a preceding software component (requires the use of PLANTA  secure)

proxy

osuser

legacy

secure

 

  • proxy: authentication via a preceding software component (requires the use of PLANTA  secure)

  • osuser: no authentication, not secure 

  • legacy: is composed of the authentication methods  osuser  and  interactive 

  • secure: is composed of the authentication methods, enabling a secure login, currently  interactive  and  kerberos

Up to S 39.5.31

config__globals

string (path)

Path to the main global.conf configuration file.

config__server

String (path)

Path to the PLANTA server configuration file (local path under Planta-server-directory);
Should not be changed by user

config__hibernate

String (path)

Path to the Hibernate configuration file (local path under Planta-server-directory);
Should not be changed by user

config__web

String (path)

Path to the Webservice configuration file (local path under Planta-server-directory);
Should not be changed by user

config__kerberos

String (path)

Path to the Kerberos configuration file (local path under Planta-server-directory);
Should not be changed by user

config__auth

String (path)

Path to the Authentification configuration file (local path under Planta-server-directory);
Should not be changed by user

config__secure

String (path)

Path to the Secure configuration file (local path under Planta-server-directory);
Should not be changed by user

config__license

String (path)

Path to the license configuration file (local path under Planta-server-directory);
Should not be changed by user

config__logback

String (path)

Defines the file to be used as logback configuration. Can, for example, be one of the following files:

  • logback.xml

  • logback_debug.xml

  • logback_console_files.xml

  • logback_console_files_debug.xml

  • logback_only_console.xml

  • logback_only_console_debug.xml

    • The only_console files can be used for logging within the container. No log files are written and the SessionType is added to each message.

config__scheduler

string (path)

Path to the scheduler configuration file. Should not be changed by user.

gui__host

host name or IP address, v4 or v6

Interface the server is listening on for client connections

gui__port

Int

Port the server is listening on for client connections

maintain__debug

Boolean

Loads a debug version of the python library when set to true - development option

maintain__silent

Boolean

Deactivates/activates some output to standard output and standard error - development option

timeout

Int

Currently without effect

maintain__performance_counting

Boolean

false by default; true enables performance counting globally

parallel_sessions

Int

Number of sessions (connections to server, aka open clients) allowed at the same time before server denies any new connection attempts.

maintain__recompile_pojos_at_startup

Boolean

If set to true, Java classes that are defined by Customizing tables will be recompiled at every Server start (recommended)

maintain__mem_limit__max_size

Int

Native memory size maximum (in MiB)

maintain__mem_limit__session

Int

Minimum free size (in MiB) for session start

maintain__mem_limit__calculation

Int

Minimum free size (in MiB) for calculation of a project

maintain__mem_limit__module

Int

Minimum free size (in MiB) for loading module data

maintain__mem_limit__alloc

int (MiB)

Memory threshold (in MiB) for native memory allocation control.

maintain__mem_limit__recalculation

Int

Minimum free size (in MiB) for start of recalculation

relational_delete_by_java

Boolean

A different way of handling the deletion of related tables
This is a beta functionality; it is recommended that you leave this at false

maintain__ld_preload_names

String

Internal names for Server
This should NOT be changed by the user

 

proto__keepalive__millis

Int (milliseconds)

If no protobuffer-message is received after this interval, the client will be closed (assumed to be stuck)

 

proto__keepalive__check

Int

If this number of protobuffer-messages fails to arrive, the client will be closed (protobuffer-error assumed)

 

writeable_path

String (path)

Directory in which the server writes files

logfile_path

String (path)

Directory in which the server writes log files. If a writeable_path is defined, it will be added in front of the path defined in logfile_path

maintain__ssl__debug

Boolean

If set to true, debug information for SSL is logged. If the server is started with yajsw, the information will be contained in wrapper.log

sessionlink

host name/ip address

Enables the ProtoInterface connection between Worker and Manager.

use_external_autonumber_service

{0,1}

Enables (1) the use of an external auto-numbering service for IDs.

external_autonumber_service

string (URL)

URL to the external auto-numbering service used when enabled.

database__persistent_db_session

{0,1}

If 1, a persistent database session is maintained across client requests.

maintain__dont_waste_my_time

{0,1}

Internal flag to skip schema validation checks (use with caution).

maintain__detached_native

{0,1}

If 1, the Manager will not automatically start a Worker on startup.

maintain__skip_event_manager

{0,1}

Internal flag to disable the Event Manager subsystem.

proto__debug

int (e.g. 0–5)

Sets the debugging level for ProtoInterface (0 = off, higher = more verbose).

maintain__jython__no_bytecode

{0,1}

If 1, Jython modules will no longer be compiled to bytecode.

maintain__jython__debug

{0,1}

Enables debug output for Jython processing.

enable_unsafe_http_requests

{0,1}

If 1, allows execution of HTTP requests considered unsafe (use with caution).

maintain__python__debug

{0,1}

Enables debug messages for Python execution.

maintain__python__pycache

string (path)

Path to the directory where Python bytecode cache is stored.

Webservice

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

webservices__prometheus__enable

Boolean

activation of prometheus interface, default false

webservices__prometheus__connection

string (e.g. 127.0.0.1:9090)

Combined Prometheus connection string in the form of IP:Port.

webservices__prometheus__port

Int

port number the web server listens on; required parameter (prometheus is implicitely deactivated when no port is configured)

webservices__prometheus__interface

host name/ip address

interface the web server is bound to; localhost by default

webservices__prometheus__entrypoint

string (e.g. /metrics)

URL path for the Prometheus metrics endpoint.

webservices__monitoring__enable

Boolean

activation of monitoring interface, default false

webservices__monitoring__port

Int

port number the web server listens on; required parameter (monitoring is implicitely deactivated when no port is configured)

webservices__monitoring__interface

host name/ip address

interface the web server is bound to; localhost by default

webservices__services__enable

Boolean

Enables the legacy web services module (deprecated; use generic_service__enable instead).

webservices__services__port

Int

Port number used for the legacy web services (deprecated).

webservices__services__interface

string (IP or hostname)

Interface binding for legacy services (deprecated).

webservices__services_doc__enable

Boolean

activation of web services documentation, false by default

webservices__services_doc__port

Int

port number the web server listens on; required parameter (web services documentation is implicitly deactivated when no port is configured)

webservices__services_doc__hostname

string (hostname)

Hostname under which the service documentation will be accessible.

webservices__generic_service__enable

Boolean

activation of web service documentation, false by default

webservices__generic_service__port

Int

port number of the PLANTA link web services listens on; required parameter (web services are implicitely deactivated when no port is configured)

webservices__generic_service__interface

host name/ip address

interface the web server is bound to; localhost by default

webservices__ssl_swagger_enable

Boolean

Deprecated

webservices__ssl_generic_enable

Boolean

enable SSL for PLANTA link web services, false by default

webservices__ssl_services_docs_enable

Boolean

enable SSL for web services documentation, false by default

webservices__ssl_keystore_password

String

password for the JavaKeystore

webservices__ssl_keystore

Path

path to the Java Keystore

webservices__cross_origin_filter_all

Boolean

Cross Site Scripting Filter which needs to be enabled, true by default

webservices__apikey_auth_filter_swagger

Boolean

Deprecated

webservices__apikey_auth_filter_generic

Boolean

ApiKey authentication for PLANTA pulse web services, true by default

Needs to be set to false if the Authentication parameter on a specific web interface is to be used instead

webservices__saml_auth_filter_pulse

Boolean

SAML authentication for all web services, true by default

webservices__server_status__enable

Boolean

Enables the Health Endpoint

webservices__server_status__connection

string (e.g. 127.0.0.1:9090)

Configures the connection for the Health Endpoint in the form of IP:Port.

webservices__server_status__port

Int

Port on which the server status interface is listening.

webservices__server_status__interface

String (IP or hostname)

Interface to which the server status interface binds.

webservices__server_status__entrypoint

String

Configures the entrypoint for the Health Endpoint

webservices__security_headers__common__std

string (header definition)

Standard security headers to include in all responses.

webservices__security_headers__common__additional

String

Additional custom headers added to all responses (non-SSL).

webservices__security_headers__ssl__std

String

Standard headers for SSL-enabled connections.

webservices__security_headers__ssl__additional

String

Additional SSL-specific headers to include in responses.

Scheduler

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

scheduler__enabled

{0,1}

Enables or disables the scheduling post processing, which controls the critical path and longest critical path calculation and new python API functions for cycle check

scheduler__host

localhost

Hostname used by the Java part of the scheduler to establish connections.

scheduler__port

integer (valid TCP port number)

Port number used by the Java part of the scheduler to establish connections.

scheduler__lcp_float_independent

{0,1}

If enabled, float (slack) is ignored when determining the Longest Critical Path. By default (per CPM definition), float is considered.

scheduler__lcp_determine_all

{0,1}

Determines whether all Longest Critical Paths are calculated or only the single longest one.

scheduler__lp_bucket_enabled

{0,1}

Enables or disables the bucketing method for structured Longest Path calculation.

scheduler__lp_bucket_determine_all

{0,1}

Determines whether the Longest Path is calculated across all projects or only within the selected project.

Secure

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

secure__stream__default_protocol

{planta_plain, planta_ssl}

Connect with or without TLS encryption

secure__stream__defaults_enforced

{true / false}

If defaults are not enforced, a client can specify a protocol, host, and port via the route attribute.

secure__ssl__protocol

TLSv1.2

Protocol for Planta backend SSL connection.

secure__ssl__keystore__file

config/keystore.jks

Keystore file in jks format. Must contain the client certificates for the servlet. Used for ssl backend connection.

secure__ssl__keystore__password

Password to access keystore

secure__ssl__truststore__file

config/truststore.jks

Truststore file in jks format. Must contain the public keys of the trust chain up to the CA that issued the certificates in keystore.jks

secure__ssl__truststore__password

Password to access truststore

secure__servlet__enforce_request_vector

{false / true}

Default settings for the SSL/TLS enabled connector

secure__servlet__transport_scheme

{http / https}

If set to https, an SSL connection is used.

secure__servlet__entrypoint

String

Makes entrypoint for planta secure configurable. 

This setting must match that of the ClientAdapter (secure_server_endpoint parameter).

Default: \PlantaServerAdapter\

secure__servlet__connection

String : Integer

Combines interface and port, separated by a ':', e.g. your_interface:your_port

secure__reverse_proxy__auth

{true / false}

To allow login using either LDAP or OIDC, this has to be set to true.

secure__reverse_proxy__user_format

plain

The format of the user header. At the moment the header is transmitted plain.

secure__reverse_proxy__user_header

{X-Authenticated-User / X-Forwarded-User}

X-Authenticated-User is used for LDAP method and X-Forwarded-User is used for OIDC as header attribute for the user name.
If it is left blank, neither LDAP nor OIDC is activated as login method.

secure__reverse_proxy__user_token

X-Forwarded-Access-Token

Is used for OIDC as header attribute for the user token.

This parameter is only required if additional claims are to be read from OIDC.

secure__session__min_wait

Integer

Defines how long a polling request may wait. Longer intervals reduce overhead, shorter intervals reduce the time until connection failure will be noticed.

secure__session__max_wait

Integer

A potential reverse proxy requires a read timeout >= max_wait in order to avoid 504 gateway timeout errors on the client adapter side.

secure__session__default_wait

Integer

secure__a__session__keepalive

Integer

Should be the same value for both keepalive and the client

secure__session__max_inactivity

Integer

Defines how long a session remains alive in the absence of web requests.

secure__service__ldap_enabled

{true / false}

Enables ldap service to synchronize user of a directory service

secure__service__ldap_useSSL

{true / false}

Enables ssl usage of the ldap service 

config__ldap

path to LDAP configuration file

secure__oidc__clientId

String

This parameter is only required if additional claims are to be read from OIDC.

secure__oidc__url_issuer

URl

This parameter is only required if additional claims are to be read from OIDC.

secure__oidc__url_jwkset

URl

This parameter is only required if additional claims are to be read from OIDC.

planta__server__secure__oidc__user_authent_by_token

true / false

Enables the authentication method via jwt token

S 39.0.0

planta__server__secure__oidc__token_user_attribute

String

Defines the attribute that will be adopted as a user. Possible attributes: name, preferred_username or email

S 39.0.0

secure__enabled

true / false

Indicates whether the secure module is enabled, based on license.

secure__stream__allowed_protocols

{planta_plain, planta_ssl} (list)

Allowed stream protocols for secure communication with the backend.

secure__stream__default_host

IP / hostname

Default host for secure backend connection.

secure__stream__default_port

Integer

Default port for secure backend connection.

secure__ssl__enabled

true / false

Enables SSL usage for secure backend connection.

secure__servlet__connection__host

String

Host part extracted from servlet__connection. Internal use.

secure__servlet__connection__port

Integer

Port part extracted from servlet__connection. Internal use.

secure__session__min_polling

Integer

Minimum interval between two requests.

secure__session__max_requests

Integer

Maximum number of parallel requests per session.

secure__xml__validate_schema

true / false

Validates transmitted XML against schema (XSD).

secure__auth_method__ldap

true / false

Enables LDAP as authentication method.

secure__auth_method__oidc

true / false

Enables OIDC as authentication method.

secure__auth_method__ldap_useSSL

true / false

Enables SSL for LDAP authentication method.

secure__service__ldap_convert_endianness

true / false

Converts UUID object endianness to match LDAP requirements.

S 39.0.0

Ldap

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

ldap__enabled

true / false

Enables LDAP integration on the server side.

ldap__service__url

ldaps://your.ldap.url:port

Url for DirectoryService, preceded by the protocol and ending with the port

ldap__service__base

ou=user,DC=ldap,DC=url

The base to start in the DirectoryService

ldap__service__userDn

maxservice@yourldap.url

A service user for the DirectoryService to have access to it

ldap__service__password

mysecretpassphrase

The password for the service user

ldap__service__java__naming__ldap__attributes__binary

Map

A list of properties that are passed on to LDAP.

The listed attributes for the  java.naming.ldap.attributes.binary  key are read as binary values.

If there is more than one attribute, they must be separated by spaces, e.g.:

<map>

  <entry key="java.naming.ldap.attributes.binary" value="objectGUID"/>

</map>

In the case of the environment variable, only a String must be assigned, e.g. 'objectGUID'

ldap__attributes__ldapUserFilter

String

A hardcoded filter to narrow down the search area

These are the recommended PLANTA groups to assign users to roles from the DirectoryService. Each of these groups references a role in PLANTA project:

  • PLANTAProject_Administrator

  • PLANTAProject_Employee

  • PLANTAProject_ProjectManager

  • PLANTAProject_MultiProjectManager

  • PLANTAProject_DepartmentManager

  • PLANTAProject_PortfolioManager

  • PLANTAProject_PMAdministrator

ldap__attributes__ldapSearchScope

{SUBTREE / OBJECT / ONELEVEL}

The search scope for searches

ldap__attributes__plantaUserData

Map

A list of all LDAP attributes that are written into the DB when a user logs in or by a query_user_data.

They are listed as key - value pairs.

The key that is flagged with login is used to authenticate the user.

The key that is flagged with uuid is converted into an UUID String and serves to log the user in.

The key that is flagged with base64 is converted into an Base64 enncoded String.

Since S39.1.0 it is possible to read binary attributes and encode them base64.

Up to S39.1.0, only text attributes are allowed, except for the objectGUID which is converted into a UUID String.

For example:

<map>

  <entry key="userPrincipalName" value="login"/>

  <entry key="mail" value=""/>

  <entry key="sAMAccountName" value=""/>

  <entry key="sn" value=""/>

  <entry key="objectGUID" value="uuid"/>

</map>

In the case of the environment variable a Array of Strings has to be assigned, e.g. {'userPrincipalName=login','mail=','sAMAccountName=','distinguishedName=','objectGUID=uuid'}

Hibernate

Parameters (with 
namespace "planta__server__" as prefix)

 Possible values

 Description

Available from

hibernate__dialect

de.planta.server.hibernate.dialect.Oracle10gDialect
de.planta.server.hibernate.dialect.SQLServerDialect

Configures Oracle or MSSQL sql dialect

hibernate__connection__driver_class

oracle.jdbc.driver.OracleDriver
com.microsoft.sqlserver.jdbc.SQLServerDriver

Configures the JDBC driver

hibernate__connection__url

URL with SID: jdbc:oracle:thin:@$db.server:$db.oracle.port:$db.name
URL with service names: jdbc:oracle:thin:@//db_hostname:port/service_name

DB connection URL - configured via installer

hibernate__connection__username

USER_123

Username used for connecting to the DB

hibernate__connection__password

gE_he1M

Password used for connecting to the DB

hibernate__default_schema

Applies to oracle users only, in the context of sql server, the term database schema has an entirely different meaning. 
Required if the oracle user name deviates from the schema name to be used.

hibernate__jdbc__fetch_size

32 - 8192
recommended: 512

Number of lines that will be transfered for reading

hibernate__jdbc__batch_size

8 - 64
recommended: 32

Number of lines that will be transfered for writing

hibernate__connection__provider_class

Class name (e.g. org.hibernate.connection.C3P0ConnectionProvider)

Class that provides the database connection.

hibernate__connection__pool_size

Integer

Max number of connections in the pool.

hibernate__c3p0__min_size

Integer

Minimum number of connections in the c3p0 pool.

hibernate__c3p0__max_size

Integer

Maximum number of connections in the c3p0 pool.

hibernate__c3p0__timeout

Seconds

Time after which idle connections are closed.

hibernate__c3p0__maxIdleTimeExcessConnections

Seconds

Timeout for excess idle connections.

hibernate__c3p0__max_statements

Integer

Global number of cached prepared statements.

hibernate__c3p0__maxStatementsPerConnection

Integer

Max cached statements per connection.

hibernate__c3p0__numHelperThreads

Integer

Background threads for pool management.

hibernate__c3p0__checkoutTimeout

Milliseconds

Max wait time to get a connection.

hibernate__connection__autoReconnect

true, false

Enables reconnect if DB connection is lost.

hibernate__connection__autoReconnectForPools

true, false

Enables reconnect for connection pools.

hibernate__c3p0__acquireRetryAttempts

Integer

Number of retry attempts on failure.

hibernate__c3p0__acquireRetryDelay

Milliseconds

Delay between retries.

hibernate__c3p0__breakAfterAcquireFailure

true, false

Stop retrying after first failure.

hibernate__c3p0__preferredTestQuery

SQL query (e.g. SELECT 1)

Used to validate a connection.

hibernate__transaction__coordinator_class

e.g. jdbc

Defines transaction coordinator.

hibernate__current_session_context_class

e.g. thread

Specifies the session context handling.

hibernate__format_sql

true, false

Formats SQL for readability.

hibernate__connection__isolation

e.g. 2 (READ_COMMITTED)

DB transaction isolation level.

hibernate__connection__handling_mode

e.g. DELAYED_ACQUISITION_AND_RELEASE_AFTER_TRANSACTION

Controls how connections/transactions are handled.

hibernate__integration__envers__enabled

true, false

Enables Hibernate Envers for auditing.

hibernate__listeners__envers__autoRegister

true, false

Auto-registers Envers listeners.

hibernate__org__hibernate__envers__audit_table_suffix

e.g. _AUD

Suffix for audit tables.

hibernate__org__hibernate__envers__store_data_at_delete

true, false

Store deleted data in audit tables.

hibernate__javax__persistence__validation__mode

AUTO, NONE, etc.

Defines validation mode for JPA.

hibernate__synonyms

true, false

Enables DB synonyms support.

hibernate__spring__jpa__properties__hibernate__jdbc__lob__non_contextual_creation

true, false

Enables non-contextual LOB creation.

hibernate__temp__use_jdbc_metadata_defaults

true, false

Use JDBC metadata for temp tables.

hibernate__splitMaxDIsPerSwitch

Integer

Max number of data items per switch.

hibernate__contextInfo_Enable

true, false

Enables DB context info transfer.

hibernate__use_nationalized_character_data

true, false

Uses NVARCHAR and similar types.

hibernate__connection__useUnicode

true, false

Enables Unicode in DB connection.

39.0.2

hibernate__connection__CharSet

e.g. UTF-8

Charset for DB connection.

39.0.2.

hibernate__connection__characterEncoding

e.g. UTF-8

Encoding for DB communication.

39.0.2

hibernate__connection__encrypt

true, false

Enables Connection Encryption

39.1.0

hibernate__connection__trustServerCertificate

true, false

Enables to Trust Server Certificates without validation

Should only be used for testpurposes

39.1.0

hibernate__connection__trustStore

Truststore file in jks format. Must contain the public keys of the trust chain up to the CA that issued the certificates in keystore.jks

39.1.0

hibernate__connection__trustStorePassword

Password to access truststore

39.1.0

 Connection testing

Values

Description

hibernate__c3p0__testConnectionOnCheckout

false

Tests a connection before it is used

hibernate__c3p0__testConnectionOnCheckin

false

Tests a connection after it was used

hibernate__c3p0__idleConnectionTestPeriod

300

Period after which an idle connection is tested

Java VM

The following parameters do not belong to the PLANTA namespace and are not executed by the server, but by the Java VM.

Parameter

 Possible values

 Description

Available from

JAVA_INIT

String

Default:-Xms256m

defines the memory size

JAVA_MAX

String

Default:-Xmx768m

defines the maximum memory size

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.