From: thhal at mailblocks.com (Thomas Hallgren)
Date: Sun, 08 May 2005 10:46:14 +0200
Subject: [Pljava-dev] Re: PLJava Installation problem:java.sql.SQLException:
	ERROR: invalid macro name in dynamic library path: $libdi Addendum
In-Reply-To: <20050508015657.035BEB1EFCF@gborg.postgresql.org>
References: <20050508015657.035BEB1EFCF@gborg.postgresql.org>
	<427DD1D6.7050405@mailblocks.com>
	<thhal-0PG1ZAwGKyicbvCPPrk59tbhW+V6QBm@mailblocks.com>
Message-ID: <thhal-03W1ZAwOKyic7hcfs2/pRHI3b0xWdbR@mailblocks.com>

Eric,
You are using ':' as a path separator on Windows. You should use ';' 
(semicolon). You also seem to have a space after the colon. Try this:

dynamic_library_path = '$libdir;c:\\pljava'


You need to check your classpath also. The classpath seen by client 
programs should not contain pljava.jar. The server should not see a 
classpath at all aside from what's declared in postgresql.conf.

Regards,
Thomas Hallgren

Eric wrote:
>  
> 
> 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.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev