[Pljava-dev] Cross Compiled Windows Binaries

Hi PL/Java,

I've managed to cross compile a 32bit Windows binary for Postgres 9.
However a colleague got the dreaded "unknown error 126."

Do any of you know what that could be?

Also if you can give it a try give me an email privately and I'll send you
the following files with simple instructions.

PLJAVA.JAR
PLJAVA.DLL
install.sql
uninstall.sql

The zip file is < 400k in size.

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

Hi Johann, I tried pljava with the files you sent me.
I installed install.sql and everything was ok,
but when I try to run a java store procedure I get:

jaspa4=# select jaspa_version();
WARNING: java.lang.NoSuchMethodError: Method org.postgresql.pljava.internal.Por
tal._fetch(JZI)I not found
ERROR: Unable to register native methods

Note that I tried pljava with the software im developping (jaspa) because the server is already configured.
With the old pljava dll and jar (from postgres plus) everything was working well.

Hope it helps,
Jose

> To: pljava-dev at pgfoundry.org
> Date: Mon, 14 Feb 2011 10:26:10 +0000
> From: johann at 2ndquadrant.com
> Subject: [Pljava-dev] Cross Compiled Windows Binaries
>
> Hi PL/Java,
>
> I've managed to cross compile a 32bit Windows binary for Postgres 9.
> However a colleague got the dreaded "unknown error 126."
>
> Do any of you know what that could be?
>
> Also if you can give it a try give me an email privately and I'll send you
> the following files with simple instructions.
>
> PLJAVA.JAR
> PLJAVA.DLL
> install.sql
> uninstall.sql
>
> The zip file is < 400k in size.
>
> --
> 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/20110214/1f50af0f/attachment.html>

Hi Jose,

On Mon, 14 Feb 2011 21:44:10 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> Hi Johann, I tried pljava with the files you sent me.
> I installed install.sql and everything was ok,
> but when I try to run a java store procedure I get:
>
> jaspa4=# select jaspa_version();
> WARNING: java.lang.NoSuchMethodError: Method
> org.postgresql.pljava.internal.Por
> tal._fetch(JZI)I not found
> ERROR: Unable to register native methods

There are some pointers here, can you try them out?

http://comments.gmane.org/gmane.comp.db.postgresql.pljava/623

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

Hi Johann, thanks you were right. Some pljava.dll/pljava.jar were still remaining in the lib directory under de postgres installation.
Great...now everything is working.. I have pljava 1.4.2 and postgres 9 working.Im wondering why the pljava 1.4.2 dll is around 650K and the old ones around 200KBytes?
I will try the binary in a deeply way during the next days.I will let you know if there is any problem.
Any though about building with postgres 64 bits?
Thanks a lot,Jose

> To: jcllario at hotmail.com; pljava-dev at pgfoundry.org
> Subject: Re: [Pljava-dev] Cross Compiled Windows Binaries
> Date: Tue, 15 Feb 2011 13:26:24 +0000
> From: johann at 2ndquadrant.com
>
> Hi Jose,
>
> On Mon, 14 Feb 2011 21:44:10 -0000, JOSE CARLOS MARTINEZ LLARIO
> <jcllario at hotmail.com> wrote:
>
> > Hi Johann, I tried pljava with the files you sent me.
> > I installed install.sql and everything was ok,
> > but when I try to run a java store procedure I get:
> >
> > jaspa4=# select jaspa_version();
> > WARNING: java.lang.NoSuchMethodError: Method
> > org.postgresql.pljava.internal.Por
> > tal._fetch(JZI)I not found
> > ERROR: Unable to register native methods
>
> There are some pointers here, can you try them out?
>
> http://comments.gmane.org/gmane.comp.db.postgresql.pljava/623
>
>
> --
> 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/20110215/939918b1/attachment.html>

Hi Jose,

On Tue, 15 Feb 2011 22:08:14 -0000, JOSE CARLOS MARTINEZ LLARIO
<jcllario at hotmail.com> wrote:

> Hi Johann, thanks you were right. Some pljava.dll/pljava.jar were still
> remaining in the lib directory under de postgres installation.
> Great...now everything is working.. I have pljava 1.4.2 and postgres 9
> working.Im wondering why the pljava 1.4.2 dll is around 650K and the old
> ones around 200KBytes?

I can only presume it's some artifact of the cross-compile instead of
direct compilation on Windows.

> I will try the binary in a deeply way during the next days.I will let
> you know if there is any problem.

Good, I hope to release Windows binaries in the next few days.

> Any though about building with postgres 64 bits?

Thoughts, yes. I'll need to setup a 64 bit cross compiler and try it
out. I'll let you know how it goes.

> Thanks a lot,Jose

You're welcome.

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