[Pljava-dev] installing and configuring pljava on XP ???

While Janardhan's instructions are accurate, they are overcomplicating
things. In all likelihood you just don't have jvm.dll on your PATH and
there are certainly easier ways to fix that than scripting registry
edits. Simply do a search to find "jvm.dll" on your computer and add
that directory to the system PATH environment variable. Then restart
your postgresql server and you should be able to install pljava.

Kris Jurka

Smith Roman wrote:
> Hi,
>
> Well what your proposing is certainly not a painless alternative. I
> have no experience on manipulating windows registry. To be frank, I
> don't know how to do what your proposing. But will reinstalling
> postgresql 8.3 with the pljava option enabled do the trick ? This sounds
> like a more easier option to me.
>
> Thanks,
>
> Smith
>
>
> --- On *Wed, 4/22/09, Prabhakara_Janardhan at emc.com
> /<Prabhakara_Janardhan at emc.com>/* wrote:
>
> From: Prabhakara_Janardhan at emc.com <Prabhakara_Janardhan at emc.com>
> Subject: RE: [Pljava-dev] installing and configuring pljava on XP ???
> To: autisi at yahoo.com, pljava-dev at pgfoundry.org
> Date: Wednesday, April 22, 2009, 3:36 PM
>
> The module not found is because
> some dependency (which is usually
> jmv.dll) is not resolved.
>
> The Windows installer has an option of installing PL/Java. If you didn't
> install PL/Java while installing PostgreSQL (which was the case for me),
> then the only sure shot way of getting this to work for me was to get
> the pljava.dll,pljava.jar, install.sql and uninstall.sql from another
> install (*with* PL/Java) - or you can download the binaries alone from
> the project site - if you don't want to build PL/Java on Windows.
>
> Also make sure that all the dependencies for pljava.dll are resolved
> (and hence it can be loaded by the postgres backend) (use a tool such as
> depends: http://www.dependencywalker.com/ ). Note: pljava.dll depends on
> jmv.dll from the JRE installation...
>
> To satisfy the dependency, I had to manually add an entry to the system
> wide PATH variable in the registry to point to the libjava.dll :
>
> sub updateWindowsPathVariable(){
> #print "Current Path Variable: $PATH \n\n";
> my $CHANGED = 0;
> my $PATH =
> getRegVal("HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\Sessi
> on Manager\\Environment","PATH");
> $PATH=~s/\\$//; # strip off the trailing backslash if it exists
> if($PATH !~ m/.*\\jre\\bin\\server/){
>
> $PATH="$JAVA_HOME\\jre\\bin\\server;".$PATH;
>
> setRegVal("HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\Sessi
> on
> Manager\\Environment","PATH","REG_EXPAND_SZ",$PATH);
> $CHANGED = 1;
> }
> if($PATH !~ m/.*\\db\\controldb\\bin/){
>
> $PATH="$########\\db\\controldb\\bin;$#######\\db\\controldb\\lib;".$PAT
> H;
>
> setRegVal("HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\Sessi
> on
> Manager\\Environment","PATH","REG_EXPAND_SZ",$PATH);
> $CHANGED = 1;
> }
> if($CHANGED == 1){
> my
> $NEWPATH=getRegVal("HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Contr
> ol\\Session Manager\\Environment","PATH");
> $ENV{"PATH"}=$NEWPATH;
> #print "New Path Variable: $NEWPATH \n\n"
> }
> }
>
> sub setRegVal(){
> my $REGISTRY_KEY="$_[0]";
> my $KEY_NAME="$_[1]";
> my $KEY_TYPE="$_[2]";
> my $KEY_VALUE="$_[3]";
> system("reg add \"$REGISTRY_KEY\" /v
> \"$KEY_NAME\" /t \"$KEY_TYPE\"
> /d \"$KEY_VALUE\" /f >NUL") == 0 or die "Cannot
> update reg entry:
> $REGISTRY_KEY\\$KEY_NAME\n";
> }
>
> sub getRegVal{
> my $REGISTRY_KEY="$_[0]";
> my $KEY_NAME="$_[1]";
> my $KEY_VALUE;
> open(REGQUERY,"reg query \"$REGISTRY_KEY\" /v
> \"$KEY_NAME\" 2>&1 |")
> or die "Cannot open reg query\n";
> while (<REGQUERY>){
> if(/$KEY_NAME/){
> s/REG_SZ//g;
> s/$KEY_NAME//g;
> s/\t//g;
> s/ //g;
> $KEY_VALUE=$_;
> }
> }
> close(REGQUERY);
> chomp($KEY_VALUE);
> $KEY_VALUE;
> }
>
> Finally, I had to add the section in postgresql.conf for PL/Java (I had
> to script all this up).
>
>
> Is this painless? I reckon not... But it works for me.
>
> -Janardhan Prabhakara
>
>
> -----Original Message-----
> >From: pljava-dev-bounces at pgfoundry.org
> [mailto:pljava-dev-bounces at pgfoundry.org] On Behalf Of Smith Roman
> Sent: Wednesday, April 22, 2009 2:27 AM
> To: pljava-dev at pgfoundry.org
> Subject: [Pljava-dev] installing and configuring pljava on XP ???
>
>
> Hi,
>
> I am new to PL/Java. I have spent days trying to configure pljava with
> postgresql on my xp machine. I have read several guidelines or
> instructions on the web but to no avail. I keep getting a C:/Program
> Files/PostgreSQL/8.3/lib/pljava.dll or pljava module not found. It seems
> that several programmers are having this issue. Is'nt there a sure way
> of getting it to work painlessly.
>
>
> I would really appreciate it if I can get help on this issue.
>
> Thanks,
>
> Smith.
>
>
>
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev