agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Testing PL/Java Windows binaries
8+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:13
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
0 siblings, 1 reply; 8+ messages in thread
From: @ 2011-04-29 21:13 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:16 `
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
0 siblings, 1 reply; 8+ messages in thread
From: @ 2011-04-29 21:16 UTC (permalink / raw)
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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:37 `
2011-04-29 21:46 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:55 ` [Pljava-dev] Testing PL/Java Windows binaries
0 siblings, 2 replies; 8+ messages in thread
From: @ 2011-04-29 21:37 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:46 `
2011-04-29 21:50 ` [Pljava-dev] Testing PL/Java Windows binaries
1 sibling, 1 reply; 8+ messages in thread
From: @ 2011-04-29 21:46 UTC (permalink / raw)
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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:46 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:50 `
2011-04-29 21:55 ` [Pljava-dev] Testing PL/Java Windows binaries
0 siblings, 1 reply; 8+ messages in thread
From: @ 2011-04-29 21:50 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:46 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:50 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:55 `
0 siblings, 0 replies; 8+ messages in thread
From: @ 2011-04-29 21:55 UTC (permalink / raw)
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/
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 21:55 `
2011-04-29 22:16 ` [Pljava-dev] Testing PL/Java Windows binaries
1 sibling, 1 reply; 8+ messages in thread
From: @ 2011-04-29 21:55 UTC (permalink / raw)
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;
^ permalink raw reply [nested|flat] 8+ messages in thread
* [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:37 ` [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:55 ` [Pljava-dev] Testing PL/Java Windows binaries
@ 2011-04-29 22:16 `
0 siblings, 0 replies; 8+ messages in thread
From: @ 2011-04-29 22:16 UTC (permalink / raw)
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...
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2011-04-29 22:16 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-29 21:13 [Pljava-dev] Testing PL/Java Windows binaries
2011-04-29 21:16 `
2011-04-29 21:37 `
2011-04-29 21:46 `
2011-04-29 21:50 `
2011-04-29 21:55 `
2011-04-29 21:55 `
2011-04-29 22:16 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox