Postgres and PL/Java
843859Sep 12 2008 — edited Jan 20 2015Hi, I want to use java functions in postgres. I installed pl/java, but when I run some function I get this ERROR: Failed to create Java VM.
What can be wrong?
This I wrote to postgresql.conf
#---------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#---------------------------------------------------------------------------
dynamic_library_path ='$libdir;C:\\Program files\\PostgreSQL\\8.2\\share\\pljava'
custom_variable_classes = 'pljava' # list of custom variable class names
pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.2\\share\\pljava\\pljava.jar'
pljava.statement_cache_size = 10
pljava.release_lingering_savepoints = true
pljava.vmoptions = '-Xmx64M'
pljava.debug = false
I also change path setting in System environment setting. It is described at http://wiki.tada.se/display/pljava/Windows+Installation