[Pljava-dev] Testing PL/Java Windows binaries

Hi Johann,
This is my postgres version running on windows 7 64 bits:
postgres=# select version(); version------------------------------------------------------------- PostgreSQL 9.0.4, compiled by Visual C++ build 1500, 64-bit(1 row)

This is the error I get:
psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": %1 is not a valid Win32 application.

kind of weird because it said 'not valid Win32 application' !! instead of not valid win64 application.
Im using JRE 32 bits version..Should I use JRE 64 bits version?
cheers,

> To: jcllario at hotmail.com
> Date: Fri, 29 Apr 2011 19:47:43 +0000
> Subject: Testing PL/Java Windows binaries
> From: johann at 2ndquadrant.com
>
> Hi Jose,
>
> Please let me know as soon as you can the result of your testing. It
> should be straight forward enough. Also if you have any problems at
> all and can resolve them. It'll be useful in case other people have
> the same issue.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110429/93304136/attachment.html>

Hi Jose,

On Fri, 29 Apr 2011 21:13:04 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

>
> Hi Johann,
>
> This is the error I get:
> psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library
> "c:/jaspa4pg/lib/pljava.dll": %1 is not a valid Win32 application.
>
> kind of weird because it said 'not valid Win32 application' !! instead
> of not valid win64 application.
> Im using JRE 32 bits version..Should I use JRE 64 bits version?
> cheers,

Yes, you need a 64bit JRE.

Good luck,

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Still no.
now I get this error:
C:\Program Files\PostgreSQL\9.0\bin>psql -U postgres -f C:\jaspa4pg\sql\pljavainstall.sql -d jaspatemplate1Password for user postgres:CREATE SCHEMAGRANTpsql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": The specified module could not be found.

Important to mention that with pljava 32 bits I had in my enviroment path variable: ...jre/bin;jre/bin/clientnow with jre 64 bits I had to change ...jre/bin;jre/bin/serverbut still getting the above error.
I have always installed pljava in windows as im doing now without any problen.some ideas what im doing wrong?
Im still checking things

> To: pljava-dev at pgfoundry.org
> Date: Fri, 29 Apr 2011 21:16:35 +0000
> From: johann at 2ndquadrant.com
> Subject: Re: [Pljava-dev] Testing PL/Java Windows binaries
>
> Hi Jose,
>
> On Fri, 29 Apr 2011 21:13:04 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
> >
> > Hi Johann,
> >
> > This is the error I get:
> > psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library
> > "c:/jaspa4pg/lib/pljava.dll": %1 is not a valid Win32 application.
> >
> > kind of weird because it said 'not valid Win32 application' !! instead
> > of not valid win64 application.
> > Im using JRE 32 bits version..Should I use JRE 64 bits version?
> > cheers,
>
> Yes, you need a 64bit JRE.
>
>
> Good luck,
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110429/5194ca21/attachment.html>

On Fri, 29 Apr 2011 21:37:02 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

>
> Still no.
> now I get this error:
> C:\Program Files\PostgreSQL\9.0\bin>psql -U postgres -f
> C:\jaspa4pg\sql\pljavainstall.sql -d jaspatemplate1Password for user
> postgres:CREATE SCHEMAGRANTpsql:C:/jaspa4pg/sql/pljavainstall.sql:6:
> ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": The
> specified module could not be found.

IIRC, I got that when I was missing the jre/bin and jre/bin/client
(32bit) from my PATH.

As far as I can tell, this means it is not finding some required
library for pljava.dll but does not mention which one it is try-
ing to find. You might try the dependency walker someone men-
tioned on this list before.

> Important to mention that with pljava 32 bits I had in my enviroment
> path variable: ...jre/bin;jre/bin/clientnow with jre 64 bits I had to
> change ...jre/bin;jre/bin/serverbut still getting the above error.
> I have always installed pljava in windows as im doing now without any
> problen.some ideas what im doing wrong?

Did you remember to restart the server after changing the path?

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

Yes, after restarting server and updating the path variable with jre/bin/server;jre/binI get:
psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": The specified procedure could not be found.
I will keep trying

> To: pljava-dev at pgfoundry.org
> Date: Fri, 29 Apr 2011 21:46:19 +0000
> From: johann at 2ndquadrant.com
> Subject: Re: [Pljava-dev] Testing PL/Java Windows binaries
>
> On Fri, 29 Apr 2011 21:37:02 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
> >
> > Still no.
> > now I get this error:
> > C:\Program Files\PostgreSQL\9.0\bin>psql -U postgres -f
> > C:\jaspa4pg\sql\pljavainstall.sql -d jaspatemplate1Password for user
> > postgres:CREATE SCHEMAGRANTpsql:C:/jaspa4pg/sql/pljavainstall.sql:6:
> > ERROR: could not load library "c:/jaspa4pg/lib/pljava.dll": The
> > specified module could not be found.
>
> IIRC, I got that when I was missing the jre/bin and jre/bin/client
> (32bit) from my PATH.
>
> As far as I can tell, this means it is not finding some required
> library for pljava.dll but does not mention which one it is try-
> ing to find. You might try the dependency walker someone men-
> tioned on this list before.
>
> > Important to mention that with pljava 32 bits I had in my enviroment
> > path variable: ...jre/bin;jre/bin/clientnow with jre 64 bits I had to
> > change ...jre/bin;jre/bin/serverbut still getting the above error.
> > I have always installed pljava in windows as im doing now without any
> > problen.some ideas what im doing wrong?
>
> Did you remember to restart the server after changing the path?
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110429/a55792e4/attachment.html>

On Fri, 29 Apr 2011 21:50:40 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

>
> Yes, after restarting server and updating the path variable with
> jre/bin/server;jre/binI get:
> psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load library
> "c:/jaspa4pg/lib/pljava.dll": The specified procedure could not be found.

This can actually mean the required symbol is not exported in the DLL which
would be my fault. I'll check the binary/build process and see if I can
confirm that.

> I will keep trying

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

I'm having similar problems.

I'm using pljava.dll from 2011-04-18 and I am getting

ERROR: could not load library "C:.../Postgres/lib/pljava.dll": The
specified module could not be found.

When I open the DLL with DependencyWalker it is trying to link the DLL
against 64-bit DLLs. This was exactly the same problem I had back in
January. As I discovered back then, this DLL runs fine on 32-bit
Windows, but fails on 64-bit windows.

My default JRE is 32-bit

So, now I'm wondering if I can get a copy of the 64-bit version of
pljava.dll so I can test that.

Cheers, Eric

On 2011-04-29 2:37 PM, JOSE CARLOS MARTINEZ LLARIO wrote:
> Still no.
>
> now I get this error:
>
> C:\Program Files\PostgreSQL\9.0\bin>psql -U postgres -f
> C:\jaspa4pg\sql\pljavain
> stall.sql -d jaspatemplate1
> Password for user postgres:
> CREATE SCHEMA
> GRANT
> psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load
> library "c:/jas
> pa4pg/lib/pljava.dll": The specified module could not be found.
>
>
>
> Important to mention that with pljava 32 bits I had in my enviroment
> path variable: ...jre/bin;jre/bin/client
> now with jre 64 bits I had to change ...jre/bin;jre/bin/server
> but still getting the above error.
>
> I have always installed pljava in windows as im doing now without any
> problen.
> some ideas what im doing wrong?
>
> Im still checking things
>
>
>
> > To: pljava-dev at pgfoundry.org
> > Date: Fri, 29 Apr 2011 21:16:35 +0000
> > From: johann at 2ndquadrant.com
> > Subject: Re: [Pljava-dev] Testing PL/Java Windows binaries
> >
> > Hi Jose,
> >
> > On Fri, 29 Apr 2011 21:13:04 -0000, JOSE CARLOS MARTINEZ LLARIO
> > <jcllario at hotmail.com> wrote:
> >
> > >
> > > Hi Johann,
> > >
> > > This is the error I get:
> > > psql:C:/jaspa4pg/sql/pljavainstall.sql:6: ERROR: could not load
> library
> > > "c:/jaspa4pg/lib/pljava.dll": %1 is not a valid Win32 application.
> > >
> > > kind of weird because it said 'not valid Win32 application' !!
> instead
> > > of not valid win64 application.
> > > Im using JRE 32 bits version..Should I use JRE 64 bits version?
> > > cheers,
> >
> > Yes, you need a 64bit JRE.
> >
> >
> > Good luck,
> >
> > --
> > Johann Oskarsson http://www.2ndquadrant.com/ |[]
> > PostgreSQL Development, 24x7 Support, Training and Services --+--
> > |
> > Blog: http://my.opera.com/myrkraverk/blog/
> > _______________________________________________
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110429/92738486/attachment.html>

On 04/29/11 2:55 PM, Eric Kolotyluk wrote:
>
> My default JRE is 32-bit
>
> So, now I'm wondering if I can get a copy of the 64-bit version of
> pljava.dll so I can test that.

if you're running 64bit postgres, you must have 64bit pljava.dll and
64bit JRE

if you're running 32bit postgres, you must have 32bit pljava.dll and
32bit JRE

you *can* run 32bit all-of-the-above on 64bit windows, but obviously you
can't run 64bit stuff on 32bit Windows...