From: esloane at bigpond.net.au (Eric)
Date: Sun, 8 May 2005 11:48:13 +1000
Subject: [Pljava-dev] PLJava Installation problem:java.sql.SQLException:
	ERROR: invalid macro name in dynamic library path: $libdi
Message-ID: <20050508014812.CBB92B1EFCF@gborg.postgresql.org>

Hi Thomas,
I'm getting the following error when trying to deploy PLJAVA;
java.sql.SQLException: ERROR: invalid macro name in dynamic library path:
$libdir: c:\pljava
        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:388)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:313)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:305)
        at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:419)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
 
I've read through most of the entries in this mail list but I don't see
anything that relates directly to this issue. Can you give me some
(printable) advice please. I'm sure the problem is something dumb!
 
From postgresql.conf;
dynamic_library_path = '$libdir: c:\\pljava'
pljava.classpath = 'c:\\pljava\\pljava.jar'
custom_variable_classes = 'pljava'
 
PATH varibles;
.;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;c:\apachefri
ends\xampp\apache\;C:\j2sdk1.4.2_07\jre\bin\client;C:\j2sdk1.4.2_07\jre\bin
 
CLASSPATH varables;
C:\j2sdk1.4.2_07\lib;C:\Program
Files\PostgreSQL\8.0\jdbc;C:\PLJava\deploy.jar;C:\PLJava\pljava.jar;C:\Progr
am Files\PostgreSQL\8.0\jdbc\postgresql-8.0-310.jdbc3.jar
As you can see I've tried a lotta desperate stuff!
 
Kind Regards,
Eric.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050508/09d9c3dc/attachment.html>