[Pljava-dev] language "java" does not exist

From: tdavis at hydroblaster(dot)com (Terrance Davis)
To:
Subject: [Pljava-dev] language "java" does not exist
Date: 2005-05-19 22:49:11
Message-ID: 200505192249.j4JMn0EJ027471@bigmac.hydroblaster.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

I'm trying to deploy pljava with postgres 8.0 on Windows XP and failing. The
command I use is:

java org.postgresql.pljava.deploy.Deployer -install -host localhost
-database testdb -user postgres -password mypass

I receive this error:

java.sql.SQLException: ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error

at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:1471)

at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1256)

at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:389)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:314)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:306)

at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)

at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)

In the postgress log, it gives me this error:

2005-05-19 16:37:17 ERROR: language "java" does not exist

2005-05-19 16:37:31 ERROR: could not load library "C:/Program
Files/PostgreSQL/8.0/pljava/libpljava.dll": dynamic load error

2005-05-19 16:37:31 LOG: could not receive data from client: No connection
could be made because the target machine actively refused it.

2005-05-19 16:37:31 LOG: unexpected EOF on client connection

Below is my conf file (w/comments removed):

custom_variable_classes = 'pljava'

pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.0\\pljava\\pljava.jar'

listen_addresses = '*' # what IP interface(s) to listen on;

# defaults to localhost, '*' = any

port = 5432

max_connections = 100

shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each

log_destination = 'stderr' # Valid values are combinations of stderr,

# syslog and eventlog, depending on

# platform.

redirect_stderr = true # Enable capturing of stderr into log files.

log_min_messages = info

lc_messages = 'C' # locale for system error message strings

lc_monetary = 'C' # locale for monetary formatting

lc_numeric = 'C' # locale for number formatting

lc_time = 'C' # locale for time formatting

dynamic_library_path = '$libdir;C:\\Program Files\\PostgreSQL\\8.0\\pljava'

I am using Java 5 sdk.

I could use any suggestions.

Terrance

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050519/ec9f9e6f/attachment.html>

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Juan Manuel Diaz Lara 2005-05-20 19:00:13 [Pljava-dev] Embeding JPOX in Postgresql using pljava ?
Previous Message Thomas Hallgren 2005-05-18 21:40:07 [Pljava-dev] What about using the server jvm ?