agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedPl/Java broken since Postgresql 8.3-rc1
10+ messages / 7 participants
[nested] [flat]
* Pl/Java broken since Postgresql 8.3-rc1
@ 2008-01-10 22:40 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
0 siblings, 1 reply; 10+ messages in thread
From: Jan Ischebeck @ 2008-01-10 22:40 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org; +Cc: pljava-dev@pgfoundry.org
Hi,
I'm following the 8.3 beta releases for some time now, mostly using the
Win32 with Installer package.
8.3beta3 and 4 have worked perfectly with the provided pljava ddl, just
with 8.3-rc1 it doesn't work anymore.
i.e.
1. automatic installation of Pl/Java via Installer fails.
2. manual Installation via
CREATE FUNCTION java_call_handler() RETURNS language_handler
AS 'pljava', 'java_call_handler'
LANGUAGE c;
raises the following error:
ERROR: could not load library
"C:/Programme/PostgreSQL/8.3-rc1/lib/pljava.dll": unknown error 127
Tested on two different WinXP machines with JDK 1.6.
Regards,
Jan Ischebeck
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
@ 2008-01-11 01:18 ` Kris Jurka <books@ejurka.com>
2008-01-11 04:19 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
0 siblings, 1 reply; 10+ messages in thread
From: Kris Jurka @ 2008-01-11 01:18 UTC (permalink / raw)
To: Jan Ischebeck <jan@ischebeck-consulting.de>; +Cc: pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
On Thu, 10 Jan 2008, Jan Ischebeck wrote:
> 8.3beta3 and 4 have worked perfectly with the provided pljava ddl, just
> with 8.3-rc1 it doesn't work anymore.
>
8.3RC1 changed the function definition for SetUserId, so it pljava needs
some changes and a rebuild. Will fix.
Kris Jurka
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
@ 2008-01-11 04:19 ` Kris Jurka <books@ejurka.com>
2008-01-11 04:50 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Tom Lane <tgl@sss.pgh.pa.us>
2008-01-11 08:47 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Dave Page <dpage@postgresql.org>
0 siblings, 2 replies; 10+ messages in thread
From: Kris Jurka @ 2008-01-11 04:19 UTC (permalink / raw)
To: Jan Ischebeck <jan@ischebeck-consulting.de>; +Cc: pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
On Thu, 10 Jan 2008, Kris Jurka wrote:
> On Thu, 10 Jan 2008, Jan Ischebeck wrote:
>
>> 8.3beta3 and 4 have worked perfectly with the provided pljava ddl, just
>> with 8.3-rc1 it doesn't work anymore.
>>
>
> 8.3RC1 changed the function definition for SetUserId, so pljava needs
> some changes and a rebuild. Will fix.
>
Turns out it's not just 83RC1, but all of the security releases, which
will require different pljava packages for the patch versions before/after
the security changes. I've committed a fix to CVS for this, and I guess
I'll try to respin those this weekend and try to convince the windows
installer folks to include them in the next point release.
For the moment you can pull the pljava.dll from here and it should work
for you.
http://www.ejurka.com/pgsql/pljava/83rc1/
Kris Jurka
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
2008-01-11 04:19 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
@ 2008-01-11 04:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-01-11 05:01 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
1 sibling, 1 reply; 10+ messages in thread
From: Tom Lane @ 2008-01-11 04:50 UTC (permalink / raw)
To: Kris Jurka <books@ejurka.com>; +Cc: Jan Ischebeck <jan@ischebeck-consulting.de>; pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
Kris Jurka <books@ejurka.com> writes:
> Turns out it's not just 83RC1, but all of the security releases, which
> will require different pljava packages for the patch versions before/after
> the security changes.
Just out of curiosity, what was pljava doing calling SetUserId?
If I'd known about that I'd have thought harder about removing the
function; but it's not clear to me why a PL should be doing that.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
2008-01-11 04:19 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
2008-01-11 04:50 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-01-11 05:01 ` Kris Jurka <books@ejurka.com>
0 siblings, 0 replies; 10+ messages in thread
From: Kris Jurka @ 2008-01-11 05:01 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Jan Ischebeck <jan@ischebeck-consulting.de>; pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
On Thu, 10 Jan 2008, Tom Lane wrote:
> Just out of curiosity, what was pljava doing calling SetUserId?
> If I'd known about that I'd have thought harder about removing the
> function; but it's not clear to me why a PL should be doing that.
>
pljava wants to run code as the session user when inside a security
definer function. The sqlj spec has an install_jar function which
installs a library of java code and has an optional deployment descriptor
which can create functions against the library and tables for it to use.
The install_jar function is security definer to be able to register the
jar file in various sqlj tables that the calling user may not be able to
write to, but it wants to create the tables and function specified in the
deployement descriptor with the ownership of the user calling install_jar,
not the person who initially installed pljava.
Kris Jurka
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
2008-01-11 04:19 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
@ 2008-01-11 08:47 ` Dave Page <dpage@postgresql.org>
1 sibling, 0 replies; 10+ messages in thread
From: Dave Page @ 2008-01-11 08:47 UTC (permalink / raw)
To: Kris Jurka <books@ejurka.com>; +Cc: Jan Ischebeck <jan@ischebeck-consulting.de>; pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
On 11/01/2008, Kris Jurka <books@ejurka.com> wrote:
> Turns out it's not just 83RC1, but all of the security releases, which
> will require different pljava packages for the patch versions before/after
> the security changes. I've committed a fix to CVS for this, and I guess
> I'll try to respin those this weekend and try to convince the windows
> installer folks to include them in the next point release.
Thanks Kris - I've pulled the 8.3 dll to the win32 build VM, if you
can provide 8.2 as well that'd be great.
Regards, Dave
^ permalink raw reply [nested|flat] 10+ messages in thread
* Pl/Java broken since Postgresql 8.3-rc1
@ 2008-01-14 15:33 juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>
2008-01-14 16:54 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 10+ messages in thread
From: juergen_reif.nbg@t-online.de @ 2008-01-14 15:33 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
Hi there,
as you now is plJava broken with the actual security releases.
There is a pljava.dll at http://www.ejurka.com/pgsql/pljava/83rc1/ to
fix it for version 8.3RC1.
Is a pljava.dll for version 8.2.6 out?
It's very important for me, need it for my office.
Juergen
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-14 15:33 Pl/Java broken since Postgresql 8.3-rc1 juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>
@ 2008-01-14 16:54 ` Josh Berkus <josh@agliodbs.com>
2008-01-15 03:51 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
0 siblings, 1 reply; 10+ messages in thread
From: Josh Berkus @ 2008-01-14 16:54 UTC (permalink / raw)
To: juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>; +Cc: pgsql-hackers@postgresql.org
Juergen,
> Is a pljava.dll for version 8.2.6 out?
> It's very important for me, need it for my office.
Try e-mailing pgsql-jdbc mailing list and asking there.
--Josh
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-14 15:33 Pl/Java broken since Postgresql 8.3-rc1 juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>
2008-01-14 16:54 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Josh Berkus <josh@agliodbs.com>
@ 2008-01-15 03:51 ` Kris Jurka <books@ejurka.com>
2008-01-22 03:46 ` Re: Pl/Java broken since Postgresql 8.3-rc1 kids <kdeopura@hotmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Kris Jurka @ 2008-01-15 03:51 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>; pgsql-hackers@postgresql.org; pljava-dev@pgfoundry.org
On Mon, 14 Jan 2008, Josh Berkus wrote:
> Juergen,
>
>> Is a pljava.dll for version 8.2.6 out?
>> It's very important for me, need it for my office.
>
> Try e-mailing pgsql-jdbc mailing list and asking there.
>
The correct list is actually pljava-dev@pgfoundry.org. The JDBC driver
and the server side language have little in common.
I've put up a new pljava build against 8.2.6 for windows here:
http://www.ejurka.com/pgsql/pljava/826/
In this case you need the new pljava.jar as well as the .dll because
it's had some updates since the previous release as well.
Kris Jurka
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Pl/Java broken since Postgresql 8.3-rc1
2008-01-14 15:33 Pl/Java broken since Postgresql 8.3-rc1 juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>
2008-01-14 16:54 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Josh Berkus <josh@agliodbs.com>
2008-01-15 03:51 ` Re: Pl/Java broken since Postgresql 8.3-rc1 Kris Jurka <books@ejurka.com>
@ 2008-01-22 03:46 ` kids <kdeopura@hotmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: kids @ 2008-01-22 03:46 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
Does anyone has a solution for pljava.dll not loading? I see the same issue
listed
for 8.3-rc1, supposedly fixed in 8.3-rc3. But I need something that works
for
8.2
C:\Program Files\PostgreSQL\8.2\bin>"%JAVA_HOME%/bin/java" -cp
../../../../pljav
a-i686-pc-mingw32-pg8.2-1.3.1/deploy.jar;../jdbc/postgresql-8.2-505.jdbc3.jar
or
g.postgresql.pljava.deploy.Deployer -install -user postgres -password
postgres -
database utilimesh
org.postgresql.util.PSQLException: ERROR: could not load library "C:/Program
Fil
es/PostgreSQL/8.2/lib/pljava.dll": The specified module could not be found.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:337)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:329)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:
474)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)
Kris Jurka wrote:
>
>
> -Kids
>
> On Mon, 14 Jan 2008, Josh Berkus wrote:
>
>> Juergen,
>>
>>> Is a pljava.dll for version 8.2.6 out?
>>> It's very important for me, need it for my office.
>>
>> Try e-mailing pgsql-jdbc mailing list and asking there.
>>
>
> The correct list is actually pljava-dev@pgfoundry.org. The JDBC driver
> and the server side language have little in common.
>
> I've put up a new pljava build against 8.2.6 for windows here:
>
> http://www.ejurka.com/pgsql/pljava/826/
>
> In this case you need the new pljava.jar as well as the .dll because
> it's had some updates since the previous release as well.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
--
View this message in context: http://www.nabble.com/Pl-Java-broken-since-Postgresql-8.3-rc1-tp14804305p15012040.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2008-01-22 03:46 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-10 22:40 Pl/Java broken since Postgresql 8.3-rc1 Jan Ischebeck <jan@ischebeck-consulting.de>
2008-01-11 01:18 ` Kris Jurka <books@ejurka.com>
2008-01-11 04:19 ` Kris Jurka <books@ejurka.com>
2008-01-11 04:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-01-11 05:01 ` Kris Jurka <books@ejurka.com>
2008-01-11 08:47 ` Dave Page <dpage@postgresql.org>
2008-01-14 15:33 Pl/Java broken since Postgresql 8.3-rc1 juergen_reif.nbg@t-online.de <juergen_reif.nbg@t-online.de>
2008-01-14 16:54 ` Josh Berkus <josh@agliodbs.com>
2008-01-15 03:51 ` Kris Jurka <books@ejurka.com>
2008-01-22 03:46 ` kids <kdeopura@hotmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox