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

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