[Pljava-dev] Error on loading libpljava.dll

Strange. I modified the SQL script below to point to pljava.dll (which is
included in the 8.2 distribution) and it installed java and javu just fine.
Could there be something wrong with the libpljava.dll included in the
stand-alone distribution?

Nageswara, thank you very much for the sugggestion! That's what led me to
try pointing to the included dll instead. For some reason when I installed
Postgres8.2, the option to install Pl/java was greyed out. Not sure why
(maybe because Java_home and Jre_home were not set at the time).

Brad

> -----Original Message-----
> From: Nageswara R. Ambavaram
> [mailto:nageswara.ambavaram at coalitiondev.com]
> Sent: Monday, April 23, 2007 12:33 AM
> To: bburan at MIT.EDU; pljava-dev at gborg.postgresql.org
> Subject: RE: [Pljava-dev] Error on loading libpljava.dll
>
> Hi Brad
>
> I have also faced same problems.
>
> I can suggest an easy way to start from scratch. I see that
> you are using Postgres8.2. This version comes with pljava as
> an installation option. Just select it as one of the
> components to install and it should be a smooth ride.
> Remember, the postmaster needs to be restarted.
>
> Also, I am assuming that u have JAVA_HOME and JRE_HOME
> environment variables and restarted the computer for these
> environ variables to take effect.
>
> Thanks
> - Nageswara Reddy
>
> -----Original Message-----
> From: pljava-dev-bounces at gborg.postgresql.org
> [mailto:pljava-dev-bounces at gborg.postgresql.org] On Behalf Of
> Brad Buran
> Sent: Monday, April 23, 2007 1:26 AM
> To: pljava-dev at gborg.postgresql.org
> Subject: [Pljava-dev] Error on loading libpljava.dll
>
> I followed all the instructions for installing pljava with postgresql
> 8.2
> (windows xp), but when I try to run the sql file to create
> the sqlj schema, I get the following error:
>
> ERROR: could not load library "C:/Program
> Files/PostgreSQL/8.2/lib/libpljava.dll": The specified module
> could not be found.
>
> SQL state: 58P01
>
> The dll is there, and the system classpath contains the paths
> to the JRE bin and bin/client folders. I'm a bit confused as
> to where to go from here to fix the problem. Any advice?
>
> Thanks!
> Brad
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>