Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Postgres and PL/Java

843859Sep 12 2008 — edited Jan 20 2015

Hi, 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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2008

Added on Sep 12 2008

#database-connectivity-discussions

2 comments

198 views