agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Configuring PLJava
5+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Configuring PLJava
@ 2011-06-28 00:32
0 siblings, 2 replies; 5+ messages in thread
From: @ 2011-06-28 00:32 UTC (permalink / raw)
OK, I finally managed to get PLJava working on Windows XP with
PostgreSQL 9.0.
Some weeks back I tried for 2 days to get it working, but kept running
into DLL Hell issues. In retrospect, I probably missed some crucial
configuration step, and diagnosing the problem became hell.
So on Windows XP SP3 I
* installed jdk-6u20-windows-i586.exe
o There are known problems with updates > 20, but I am not
sure if they affect PLJava, I'm just playing it safe
* set the environment variables
o JRE_HOME = C:\Program Files\Java\jre6
o PGHOME = C:\Program Files\PostgreSQL\9.0
o PGDATA = C:\Program Files\PostgreSQL\9.0\data
o Path += ;C:\Program Files\Java\jre6\bin
o Path += ;C:\Program Files\Java\jre6\client
+ on a 64-bit Java this would be "server" instead of
"client"
o Path += ;C:\Program Files\PostgreSQL\9.0\bin
o Path += ;C:\Program Files\PostgreSQL\9.0\lib
o it is best to have all your environment variables set
correctly before running postgresql
* installed postgresql-9.0.4-1-windows_x32.exe as built by
Enterprise DB using default settings
o note: the installer does not work properly on XP if you
change some of the settings, such as PGHOME or PGDATA. I've
reported this as a bug, but I doubt it will ever be fixed
+ I do not have this problem on Windows 7
o This release actually has a working PLJava in it, so there
is nothing more to install
+ With the 64-bit version I have to repair the
PostgreSQL installation with a bunch of 64-bit files
# msvcm90.dll
# msvcp90.dll
# msvcr90.dll
# IEShims.dll
# and I have to add the PLJava files from the
latest release
* edited the PGDATA\postgresql.conf file and added
o custom_variable_classes = 'pljava'
o pljava.classpath = '$libdir/pljava.jar'
* Restarted the server with "net restart postgresql-9.0"
o It is crucial all your environment variable are set properly
before starting or restarting the server
o using "pg_ctl reload" causes the server to crash
+ I do not have this problem on Windows 7
o using the program menu doesn't work either, same problem
o using "pg_ctl restart" you always get: FATAL: could not
create lock file "postmaster.pid": Permission denied
* using cmdtool
o cd ...\share\pljava
o psql -f install.sql postgres postgres
Which seems to work so far - that's always the hardest part. I have yet
to test it with my actual Java code on anything except 32-bit PostgreSQL
on 32-bit Windows 7.
Basically configuring PLJava and getting it to work is an extremely
fragile process. Get something wrong and you're headed for days of misery...
I have written software which automates this whole process for Windows
XP, Vista, 7, etc. as well as 32-bit and 64bit variants, because it is
totally insane to try to do it manually.
Cheers, Eric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20110627/103d3c6e/attachment.html;
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Configuring PLJava
@ 2012-10-16 15:06
parent:
1 sibling, 1 reply; 5+ messages in thread
From: @ 2012-10-16 15:06 UTC (permalink / raw)
Merci,
svp ! vous utiliser quelle version de pljava ?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Configuring-PLJava-tp4530294p5728437.html
Sent from the PL/Java mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Configuring PLJava
@ 2012-10-16 15:32
parent:
0 siblings, 1 reply; 5+ messages in thread
From: @ 2012-10-16 15:32 UTC (permalink / raw)
Please use English on this list.
- thomas
On 2012-10-16 17:06, bruno wrote:
> Merci,
> svp ! vous utiliser quelle version de pljava ?
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Configuring-PLJava-tp4530294p5728437.html
> Sent from the PL/Java mailing list archive at Nabble.com.
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Configuring PLJava
@ 2012-10-16 15:51
parent:
0 siblings, 0 replies; 5+ messages in thread
From: @ 2012-10-16 15:51 UTC (permalink / raw)
thank you,
Please! what version of pljava do you use ?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Configuring-PLJava-tp4530294p5728443.html
Sent from the PL/Java mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* [Pljava-dev] Configuring PLJava
@ 2012-10-16 16:00
parent:
1 sibling, 0 replies; 5+ messages in thread
From: @ 2012-10-16 16:00 UTC (permalink / raw)
On 06/27/11 5:32 PM, Eric Kolotyluk wrote:
> Basically configuring PLJava and getting it to work is an extremely
> fragile process. Get something wrong and you're headed for days of
> misery...
understatement of the year.
it took me about 2 weeks to get it working on AIX with IBM Java, and
even then I had to use a linux system to compile the Java portions then
copy the build tree over to the AIX system to build the C parts.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-10-16 16:00 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-28 00:32 [Pljava-dev] Configuring PLJava
2012-10-16 15:06 `
2012-10-16 15:32 `
2012-10-16 15:51 `
2012-10-16 16:00 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox