[Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum

[Eric]

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.
 
The postgres log shows;
2005-05-08 11:02:54 LOG:  unexpected EOF on client connection
2005-05-08 11:04:17 ERROR:  invalid macro name in dynamic library path:
$libdir: c:\pljava
2005-05-08 11:04:17 LOG:  could not receive data from client: No connection
could be made because the target machine actively refused it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pljava-dev/attachments/20050508/d7955894/attachment.html