I have applied all solution from multiple other forum answers, however none of these has worked to setup PLJAVA for postgress
C:\Users\1xx> java -classpath "D:\1xx\DB\lib\postgresql_drv.jar;D:\1xx\DB\lib\deploy.jar" org.postgresql.pljava
.deploy.Deployer -install -database postgres -user postgres -pass manager
org.postgresql.util.PSQLException: ERROR: could not load library "D:/1xx/DB/lib/pljava.dll": The specified procedure
could not be found.
Please provide the complete stack trace as you are not able to fix the issue with the above mentioned pdn link
ERROR: could not load library "C:/Program Files/PostgreSQL/9.3/lib/pljava.dll": The specified procedure could not be found.
[WARNING ] CREATE TRUSTED LANGUAGE java HANDLER sqlj.java_call_handler
ERROR: function sqlj.java_call_handler() does not exist
[WARNING ] CREATE FUNCTION sqlj.javau_call_handler()
RETURNS language_handler AS 'pljava'
If your stack trace is simalar to above most possibly this has to work with the above link.
Any way please share the stack trace.
Posted: 6 years ago
Posted: 31 Jan 2017 11:21 EST
Bhushan Patil (BHUSHANPATIL)