[Pljava-dev] Error installing examples - Unrecognized JINI version x10004

Rodrigo,
Add the following lines to your postgresql.conf:

custom_variable_classes = pljava
pljava.classpath = 'E:\\PostgreSQL80_Beta2\\data\\pljava.jar'

(please not the double '\\' everywhere. The '\' is treated as an escape
character by the parser that reads postrgresql.conf).

The postgresql.jar and deploy.jar should *not* be included here since
this is the classpath seen by the backend. The pljava.jar contains the
classes needed by the backend only.

The deploy.jar is a client program and it in turn needs postgresql.jar
(the client JDBC driver). The pljava.jar should *not* be in your
classpath for the client programs. It's important to make this
distinction. I.e. one classpath for the backend and another for client
programs.

Regarding the JNI version error:
I checked if there was any difference between Java 1.4 version defines
but there isn't. This leads me to believe that the PATH you claim you
have is not the PATH that is visible to the backend process, i.e. it's
not the path in effect when the postmaster is started. The backend
process somehow finds an older JRE (1.3 perhaps?) and attempts to load it.

Please note that the PATH containing the JRE bin and JRE bin/client
directories must be visible to the backend process, i.e. it must be in
effect when the postmaster is started. Havin the JRE directories in your
path is normally not needed when running client programs as long as you
can find java.exe.

Regards,

Thomas Hallgren

> Hi Thomas,
>
> I install PostgreSQL 8.0 for windows in a Windows XP and when i
> run sqlj.install_jar i get the following message in postgresql.log
>
> "Unrecognized JINI version x10004"
> Failed to create Java VM
> attempt to redefine parameter "pljava.vmoptions"
>
> I'm using jre "1.4.1_01"
>
> classpath include
> E:\PostgreSQL80_Beta2\data\pljava.jar;E:\PostgreSQL80_Beta2\data\deploy.jar;E:\PostgreSQL80_Beta2\data\postgresql.jar
> ...
>
> path include
> E:\j2sdk1.4.1_01\jre\lib\i386;E:\j2sdk1.4.1_01\jre\lib\jre\lib\i386\client ...
>
> Regards,
>
> Rodrigo Foscarini
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>