Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

PL/Java Configuration Parameters

This document describes the configuration parameters in the PL/Java category.

Note!
To ensure system stability and security, manually modifying these parameters should be done with caution.

pljava_classpath

A colon-separated (:) list of JAR files or directories containing the JAR files required by PL/Java functions.

  • Full paths must be specified for JAR files or directories, except for JAR files located in the $GPHOME/lib/postgresql/java directory, whose paths can be omitted.
    JAR files must be installed at the same location on all YMatrix hosts and must be readable by the mxadmin user.
  • The pljava_classpath parameter is used to assemble the PL/Java classpath at the beginning of each user session.
    JAR files added after session startup are not available in that session.
  • If a full path to a JAR file is specified in pljava_classpath, it will be added to the PL/Java classpath.
  • When a directory is specified, all JAR files within that directory are added to the PL/Java classpath.
  • Subdirectories of the specified directory are not searched.
  • If a JAR file name is listed in pljava_classpath without a path, the JAR file must reside under the $GPHOME/lib/postgresql/java directory.
  • Note: Performance may degrade if many directories are searched or if there are a large number of JAR files.
  • If pljava_classpath_insecure is set to false, setting the pljava_classpath parameter requires superuser privileges.
  • When non-superusers execute code, attempts to set the classpath within SQL code will fail.
Data Type Default Value Setting Classification
string master; session; reload; superuser

pljava_classpath_insecure

Controls whether the server configuration parameter pljava_classpath can be set by users who do not have YMatrix database superuser privileges.

  • If set to true, pljava_classpath can be set by regular users. Otherwise, pljava_classpath can only be set by a database superuser.

Note!
Enabling this parameter allows non-administrative database users to run unauthorized Java methods, introducing potential security risks.

Data Type Default Value Setting Classification
boolean false master; session; restart; superuser

pljava_release_lingering_savepoints

If set to true, lingering savepoints used in PL/Java functions are released when the function exits.
If set to false, the savepoints are rolled back instead.

Data Type Default Value Setting Classification
boolean false master; system; restart; superuser

pljava_statement_cache_size

Sets the size (in KB) of the JRE MRU (most recently used) cache for prepared statements.

Data Type Default Value Valid Range Setting Classification
int 0 0 ~ 512 master; system; restart; superuser

pljava_vmoptions

Defines startup options for the Java VM.

Data Type Default Value Setting Classification
string master; system; reload; superuser
← Previous
Replication Parameters
Next →
Version and Platform Compatibility Parameters