PL / JAVA Category Parameters

This document describes the relevant parameters of the PL/JAVA category in system configuration parameters.

Notes!
To ensure the stability and security of the system, please be sure to manually modify the relevant parameters**.

pljava_classpath

A colon (:)-delimited list containing the jar files or directories that contain the jar files required by the PL/Java function.

The full path to the jar file or directory must be specified, but the path to the jar file in the $GPHOME/lib/postgresql/java directory can be omitted. The jar file must be installed in the same location on all YMatrix hosts and can be read by the mxadmin user.
The pljava_classpath parameter is used to assemble the PL/Java classpath at the beginning of each user session. The jar file added after the session starts cannot be used for the session.
If the full path to the jar file is specified in pljava_classpath, it is added to the PL/Java classpath.
When specifying a directory, any jar files contained in that directory are added to the PL/Java classpath.
Search does not drop into the subdirectories of the specified directory.
If the name of the jar file is contained in pljava_classpath without a path, the jar file must be in the $GPHOME/lib/postgresql/java directory.
Note: If you want to search for many directories or have a large number of jar files, performance will be affected.
If pljava_classpath_insecure is false, then setting the pljava_classpath parameter requires superuser permission.
Setting the classpath in SQL code will fail when a user without superuser permission executes the code.

| Data Type | Default | Set Category | | --- | --- | | string | | master; session; reload; superuser |

pljava_classpath_insecure

Controls whether the server configuration parameter pljava_classpath can be set by users without YMatrix database superuser permissions.

If true, pljava_classpath can be set by a regular user. Otherwise, pljava_classpath can only be set by the database superuser.

Notes!
Enabling this parameter allows non-administrator database users to run unauthorized Java methods, exposing security risks.

| Data Type | Default | Set Category | | --- | --- | | boolean | false | master; session; restart; superuser |

pljava_release_lingering_savepoints

If the value true is the value true, the delayed savepoint used in the PL/Java function will be released when the function exits. If false, the save point will be rolled back.

| Data Type | Default | Set Category | | --- | --- | | boolean | false | master; system; restart; superuser |

pljava_statement_cache_size

Sets the size (KB) of the JRE MRU (recently used) cache for the prepared statement.

| Data Type | Default Value | Value Range | Set Classification | | --- | --- | --- | | int | 0 | 0 ~ 512 | master; system; restart; superuser |

pljava_vmoptions

Defines the startup options for the Java VM.

| Data Type | Default | Set Category | | --- | --- | | string | | master; system; reload; superuser |