[Pljava-dev] Re: PLJAVA ERROR!

Hi Thomas,

Postgresql version is 7.4.0. The problem is a version because the
minimum version is 7.4.2, correct ?
If yes, I will go install a PostgreSQL 8.0.

Thanks a lot

Regards,
Rodrigo Foscarini

----- Original Message -----
From: <pljava-dev-request at gborg.postgresql.org>
To: <pljava-dev at gborg.postgresql.org>
Sent: Sunday, September 12, 2004 8:00 AM
Subject: Pljava-dev Digest, Vol 7, Issue 3

> Send Pljava-dev mailing list submissions to
> pljava-dev at gborg.postgresql.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> or, via email, send a message with subject or body 'help' to
> pljava-dev-request at gborg.postgresql.org
>
> You can reach the person managing the list at
> pljava-dev-owner at gborg.postgresql.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pljava-dev digest..."
>
>
> Today's Topics:
>
> 1. Error installing examples.jar (Rodrigo Foscarini)
> 2. Re: Error installing examples.jar (Thomas Hallgren)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 11 Sep 2004 18:07:07 -0300
> From: "Rodrigo Foscarini" <rfoscarini at uol.com.br>
> Subject: [Pljava-dev] Error installing examples.jar
> To: <pljava-dev at gborg.postgresql.org>
> Cc: rodrigo at syspoint.com.br
> Message-ID: <000801c49843$4f7f2560$1c01a8c0 at intranet.bibi.com.br>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Thomas,
>
> I'm installing pl/java in cygwin and when i try "select
sqlj.install_jar( '/usr/local/pgsql/data/examples.jar', 'samples', true ),
the postmaster restart
> with message : "Error occurred during initialization of VM
java.lang.UnsatisfiedLinkError : _getConfigOption".
> All others steps before this are OK.
>
> $ java -version
> java version "1.4.1_01"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-b01)
> Java HotSpot(TM) Client VM (build 1.4.1_01-b01, mixed mode)
>
> Thanks for your help.
>
> Regards,
>
> Rodrigo Foscarini
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
http://gborg.postgresql.org/pipermail/pljava-dev/attachments/20040911/26adb6
10/attachment-0001.html
>
> ------------------------------
>
> Message: 2
> Date: Sat, 11 Sep 2004 23:53:52 +0200
> From: Thomas Hallgren <thomas.hallgren at frameworx.com>
> Subject: Re: [Pljava-dev] Error installing examples.jar
> To: Rodrigo Foscarini <rfoscarini at uol.com.br>
> Cc: pljava-dev at gborg.postgresql.org, rodrigo at syspoint.com.br
> Message-ID: <414373F0.4040902 at frameworx.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Rodrigo,
>
> > Hi Thomas,
> >
> > I'm installing pl/java in cygwin and when i try "select
> > sqlj.install_jar( '/usr/local/pgsql/data/examples.jar', 'samples',
> > true ), the postmaster restart
> > with message : "Error occurred during initialization of VM
> > java.lang.UnsatisfiedLinkError : _getConfigOption".
> > All others steps before this are OK.
>
> My guess is that you use the binary cygwin distribution of PL/Java. That
> binary is linked using PostgreSQL 7.4 and your installed PostgreSQL is
> older probably an older version. If my assumption is correct, and if
> it's in no way possible for you to upgrade your PostgreSQL to a 7.4 then
> let me know. It shouldn't be too difficult to provide a patch if that's
> the case.
>
> Regards,
>
> Thomas Hallgren
>
>
>
> ------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
> End of Pljava-dev Digest, Vol 7, Issue 3
> ****************************************
>

Rodrigo,
My mistake, the problem is not a version problem. It is somehow caused
by different JVM initialization behavior and the way I set up the Java
logger. I'm not sure where the problem is right now or why it only
occurs when using Cygwin but I'll investigate that further.

Meanwhile, if you can use PostgreSQL 8.0, I'd recommend that you go
ahead and upgrade. Using 8.0 you no longer need Cygwin. 8.0 also
intdoduces a couple of new features that PL/Java makes use of such as
better exception handling and customization support. You can read more
about that here:
http://gborg.postgresql.org/project/pljava/genpage.php?pljava_and_postgresql_8

Regards,

Thomas Hallgren

daniel.ovalle wrote:

>I trying again to write some procedures with PLJAVA, I using
>POSTGRESQL8b3 and PLJAVAb5.
>
>
The PL/Java 1.0.0.b5 is not compatible with PostgreSQL 8.0.0beta3 (or
beta4 for that matter) since PostgreSQL changed a couple of function
signatures between beta2 and beta3. So at present, you need to use
PL/Java 1.0.0.b5 with PostgreSQL 8.0.0beta2 or lower.

I will soon release of PL/Java that can be used with PostgreSQL
8.0.0beta3 and above. The changes has already been entered into CVS HEAD.

Regards,
Thomas Hallgren