7.9 PL/Java

Table of Contents Previous Next



1.
Edit the postgresql.conf file, located under the data directory of your Advanced Server installation, and add (or modify) the following settings:
pljava.classpath = 'path_to_pljava.jar'
pljava.libjvm_location = 'path_to_libjvm.so'
Where path_to_pljava_jar specifies the location of the pljava.jar file and path_to_libjvm.so specifies the location of the libjvm.so file.
3.
You can use the CREATE EXTENSION command to install PL/Java. To install the PL/Java extension, login to the database in which you want to install PL/Java with the psql or pgAdmin client, and invoke the following command:
The edb-psql client displays two rows indicating that java and javau (Java Untrusted) have been installed in the database (see Figure 7.2):


Table of Contents Previous Next