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>
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 ? |