[Pljava-dev] PL/JAVA on Windows

Hi Danny,
A couple questions:
1) When you invoke java by itself in your command prompt, does it
run? java should give you its list of options.
2) Did you make modifications to your user path, or to the system
path? Changes need to be to the system path, so that the postgres
service is aware of them when it starts.
3) Have you defined CLASSPATH in your install environment? For
installation, CLASSPATH needs to contain deploy.jar, as well as the jdbc
driver of your choice, found in C:\Program Files\PostgreSQL\8.0\jdbc.

Once you've done that, running:

java org.postgresql.pljava.deploy.Deployer

should give the list of options as specified in the deployment instructions.

Also, it looks like you removed spaces from "Program Files" in a couple places - check that this is not the cause of your problem: C:\ProgramFiles\PostgreSQL\8.0\pljava

Hope some of that helps.

Cheers,

Eric

Danny Gaethofs wrote:

>Dear all,
>
>I have been reading the different mails about
>installing PL/Java on Postgres under Windows Xp.
>
>It is still not clear what exactly needs to be done.
>Let me explain the steps I took till I got stranded.
>
>I am running java 1.5 with JAVA_HOME at C:\Program
>Files\Java\jre1.5.0_02.
>
>My path is defined as follows:
>%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\ProgramFiles\apache-ant-1.6.5\bin
>
>Step 1: Download and install PostgreSQL
>Install the data directory on e:
>Install the software on c:
>Do not forget to Install Procedural Language
>(pl/pgsql)
>
>
>Step 2: Download and install PLJAVA
>- Download pljava from the website
>
>- Create a directory PLJAVA under
>C:\ProgramFiles\PostgreSQL\8.0\pljava
>
>- Extract the content of the file into this directory.
>
>- Edit the contents of the postgresql.conf file which
>can be found in the \data directory.
>
>Added the following lines:
>custom_variable_classes = 'pljava'
>pljava.classpath =
>'C:\ProgramFiles\PostgreSQL\8.0\pljava\pljava.jar'
>
>pljava.statement_cache_size = 10
>
>pljava.release_lingering_savepoints = true
>
>pljava.vmoptions = '-Xmx64M'
>
>pljava.debug = false
>
>dynamic_library_path =
>'$libdir:C:\\ProgramFiles\\PostgreSQL\\8.0\\pljava'
>
>log_min_messages = info
>
>Step 3: Deploy the PL/JAVA
>Now I should deploy the PL/Java but it is not clear to
>me how this should be done. I read something about
>executing this command:
>java org.postgresql.pljava.deploy.Deployer
>
>But when I do so nothing happens.
>Can anyone help me out here, what steps am I missing.
>
>regards,
>Danny
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
>