agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi
@ 2005-05-08 01:48
0 siblings, 0 replies; 3+ messages in thread
From: @ 2005-05-08 01:48 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
@ 2005-05-08 01:56
2005-05-08 08:46 ` [Pljava-dev] Re: PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
0 siblings, 1 reply; 3+ messages in thread
From: @ 2005-05-08 01:56 UTC (permalink / raw)
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://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050508/d7955894/attachment.html;
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Re: PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
2005-05-08 01:56 [Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
@ 2005-05-08 08:46 `
0 siblings, 0 replies; 3+ messages in thread
From: @ 2005-05-08 08:46 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-05-08 08:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-08 01:48 [Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi
2005-05-08 01:56 [Pljava-dev] PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
2005-05-08 08:46 ` [Pljava-dev] Re: PLJava Installation problem:java.sql.SQLException: ERROR: invalid macro name in dynamic library path: $libdi Addendum
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox