2022-03-05 20:03:03,374 (                         UDFManager)    INFO - AutoCommit set to true. Executing with out transaction
2022-03-05 20:03:03,389 (               PostgresUDFJarLoader)    INFO - Loading UDF jar on Postgres DB
2022-03-05 20:03:03,391 (                  ConnectionWrapper)    INFO - Attempting to load profile "install.postgres": 
2022-03-05 20:03:03,391 (                  ConnectionWrapper)    INFO - 	Type: postgres
2022-03-05 20:03:03,392 (                  ConnectionWrapper)    INFO - 	Class: org.postgresql.Driver
2022-03-05 20:03:03,392 (                  ConnectionWrapper)    INFO - 	URL: jdbc:postgresql://localhost:5433/pega85
2022-03-05 20:03:03,393 (                  ConnectionWrapper)    INFO - 	User: adminpega
2022-03-05 20:03:03,393 (                  ConnectionWrapper)    INFO - 	JDBC Properties: 
2022-03-05 20:03:03,464 (                  ConnectionWrapper)    INFO - Autocommit set to true
2022-03-05 20:03:03,474 (               PostgresUDFJarLoader)    INFO - Jar is not already loaded in schema pegarules
2022-03-05 20:03:03,482 (               PostgresUDFJarLoader) WARNING - Encountered a database problem when attempting to load jar onto PostgreSQL: ERROR: cannot use PL/Java before successfully completing its setup
  Hint: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity".
2022-03-05 20:03:03,482 (               PostgresUDFJarLoader) WARNING - 
*****************************************************************************************************

Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.

*****************************************************************************************************

I have installed sqlj into my database (using install.sql) and got this output:

WARNING:  Java virtual machine not yet loaded
DETAIL:  The specified module could not be found.

HINT:  SET pljava.libjvm_location TO the correct path to the jvm library (libjvm.so or jvm.dll, etc.)
CREATE FUNCTION

Query returned successfully in 56 msec.

I have also set my environment paths as directed, I have also copied the required files from ResourceKit into my C:\Program Files\PostgreSQL\9.6\lib folder and have set this up in my postgresql.conf file.

For reference, this is my postgresql.conf:

pljava.classpath = 'C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
work_mem = 5MB
pljava.libjvm_location = '%JRE_HOME%\\bin\\server\\jvm.dll'

I'm not sure what I could have missed or what is wrong but from the error I suspect it is something to do with sqlj