Question
Credit Agricole Assurances
FR
Last activity: 28 Oct 2018 12:35 EDT
Warning - SQLJ schema
Hello
We have a lot of warning when creating a SQLJ schema
CREATE SCHEMA
GRANT
psql:/apps/sources/pljava-REL1_5_STABLE/src/sql/install.sql:15: WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend
psql:/apps/sources/pljava-REL1_5_STABLE/src/sql/install.sql:15: WARNING: Unable to load class org/postgresql/pljava/internal/Backend using CLASSPATH '-Djava.class.path=/opt/rh/rh-postgresql96/root/usr/share/pgsql/pljava/pljava.jar'
psql:/apps/sources/pljava-REL1_5_STABLE/src/sql/install.sql:15: WARNING: failed to load initial PL/Java classes
HINT: The most common reason is that "pljava.classpath" needs to be set, naming the proper "pljava.jar" file.
Environment Details
OS => RedHat 7.4
Database => Postgresql 9.6
Application Server => Apache Tomcat 8.5
Media => Pega Platform 7.4
Java => JDK 1.8.0_152
British Telecom
IN
Hi ,
Have you done below steps properly?
- Navigate to the postgresql.conf file in {PostgreSQL Directory Path}\9.1\data. Make the following changes/additions:
- [alter] dynamic_library_path = '$libdir;{PostgreSQL Directory Path}\\9.1\\share\\pljava'
- [alter] custom_variable_classes = 'pljava'
- [add] pljava.classpath = '{PostgreSQL Directory Path}\\9.1\\share\\pljava\\pljava.jar'
- Add the following JRE directories to your Windows PATH System Environment Variable (Postgres Service requires access to these directories)
- [pre-Java 1.6] C:\Program Files\Java\jre5\bin;C:\Program Files\Java\jre5\bin\client; (jre5 can be any Java Version 5-)
- [post-Java 1.6] C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\server; (jre6 can be any Java Version 6+)
- RESTART THE POSTGRES SERVICE (no postgresql.conf changes can occur without restarting the service.