7.9.2 Installing PL/Java on Windows

Table of Contents Previous Next


7 Advanced Server Supporting Components : 7.9 PL/Java : 7.9.2 Installing PL/Java on Windows

1.
Edit the postgresql.conf file and add (or modify) the following settings:
pljava.classpath = 'path_to_EDBAS\lib\pljava.jar'
pljava.libjvm_location = 'path_to_libjvm.so'
Where path_to_EDBAS specifies the location of the Advanced Server installation. For example, the following is the configuration setting for a default installation:
3.
Modify the PATH setting used by the server, adding the following two entries:
%JRE_HOME%\bin;%JRE_HOME%\bin\client
Where JRE_HOME specifies the installation directory of your Java runtime environment. If you have a Java development kit, substitute the location of $JDK_HOME/jre for JRE_HOME.
4.
Use the Postgres CREATE EXTENSION command to install PL/Java. To run the installation script, use the psql or pgAdmin client to connect to the database in which you wish to install PL/Java and invoke the following command:

7 Advanced Server Supporting Components : 7.9 PL/Java : 7.9.2 Installing PL/Java on Windows

Table of Contents Previous Next