From: tdavis at hydroblaster.com (Terrance Davis)
Date: Thu, 19 May 2005 16:49:11 -0600
Subject: [Pljava-dev] language "java" does not exist
Message-ID: <200505192249.j4JMn0EJ027471@bigmac.hydroblaster.com>

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>