Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 [EMAIL PROTECTED] 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. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 [EMAIL PROTECTED] 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
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
On 11/01/2008, Kris Jurka [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
Kris Jurka [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Pl/Java broken since Postgresql 8.3-rc1
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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq