pl/java status

John R Pierce wrote:

is pl/java kind of dead? I don't see much activity since years ago.
this page seems quite out of date, talking about 1.1.0b1 released, but
the foundry has 1.4.0 from 2008 that supports 8.3. only

The last set of commits there was about 9 months ago, so it's not quite
as dead as it appears. The code in CVS supports 8.4, there just hasn't
been an official release in a while:
http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038

There are a couple of bugs to note at
http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse like
lack of support for JDK 1.6 and some known complier issues.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us

Greg Smith wrote:

John R Pierce wrote:

is pl/java kind of dead? I don't see much activity since years ago.
this page seems quite out of date, talking about 1.1.0b1 released,
but the foundry has 1.4.0 from 2008 that supports 8.3. only

The last set of commits there was about 9 months ago, so it's not
quite as dead as it appears. The code in CVS supports 8.4, there just
hasn't been an official release in a while:
http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038

There are a couple of bugs to note at
http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse
like lack of support for JDK 1.6 and some known complier issues.

k. the guys who asked me are probably fine with java 1.5, but they
definately want to use 8.4. on solaris 10 sparc :)

does the package contain a test suite so I'm sure its functional if I
build it?

John R Pierce wrote:

is pl/java kind of dead? I don't see much activity since years ago.

I've been a bit worried about that myself. With OpenJDK and a GPL java,
it makes a lot of sense to make Java a first-class PL in PostgreSQL.
There's a fair bit of activity from Java-using users, and there's not
really much reason Java should be restricted to the client side when the
same language can work well server-side too.

Not to mention all those Oracle users out there who're hooked on the stuff.

Of course, Java is extremely thread-happy and PostgreSQL is extremely
*not*, so perhaps there are reasons it doesn't seem to see much work. If
it's anything like working on an embedded Python interpreter...

--
Craig Ringer

On Wed, 2010-04-14 at 13:41 +0800, Craig Ringer wrote:

John R Pierce wrote:

is pl/java kind of dead? I don't see much activity since years ago.

I've been a bit worried about that myself. With OpenJDK and a GPL java,
it makes a lot of sense to make Java a first-class PL in PostgreSQL.
There's a fair bit of activity from Java-using users, and there's not
really much reason Java should be restricted to the client side when the
same language can work well server-side too.

Not to mention all those Oracle users out there who're hooked on the stuff.

Of course, Java is extremely thread-happy and PostgreSQL is extremely
*not*, so perhaps there are reasons it doesn't seem to see much work. If
it's anything like working on an embedded Python interpreter...

Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much love.

There is a reason that plPerl is king in this community (and I don't
even like Perl).

Joshua D. Drake

--
Craig Ringer

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering

Joshua D. Drake wrote:

Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much love.

There is a reason that plPerl is king in this community (and I don't
even like Perl).

yeah, understood. I'm getting the request 2nd hand, from someone in a
TZ 14 hours different than my own (big company, many left hands)... so
info is trickling to me.

apparently the requester is comfortable programming in Java, and needs
to do some sorta-statistical calculations inside a function used in a
join of some 73 columns, which will get used by some reporting
software... the database in question was ported from a different rdbms
where this was a single flat table rather than a several way join, and
... well... thats all I know so far.

I've already suggested plpgsql and/or plperl.

I'm going to take a stab at building the CVS head of pljava on solaris
sparc 64bit tonight or tomorrow. it appears the 64bit community
builds of PG 8.4 were built with sunstudio 11, pg_config lists
....
CC = /net/grok/ontools/onnv-tools/SUNWspro/SS11/bin/cc
CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include
-I/usr/sfw/include -I/usr/include/libxml2
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include
CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace
-W0,-Lt -W2,-Rcond_elim -Xa -xildoff
CFLAGS_SL = -KPIC
LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64
-L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64'

It appears I have Sun C 5.9 at my disposal, not sure which version of
sunstudio this is from.

$ /opt/SUNWspro/bin/cc -V
cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22

wish me luck :)

On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote:

Joshua D. Drake wrote:

Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much love.

There is a reason that plPerl is king in this community (and I don't
even like Perl).

Java2perl anyone ?
http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6
(99% joking)

And if you think positively a 14hour TZ difference is really only 10
if you go the other way.

Cheers,
-Damian

Damian Carey wrote:

On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote:

Joshua D. Drake wrote:

Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much love.

There is a reason that plPerl is king in this community (and I don't
even like Perl).

Java2perl anyone ?
http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6
(99% joking)

And if you think positively a 14hour TZ difference is really only 10
if you go the other way.

Is PL/J still being developed? I can't find it myself, but was curious.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

Greg Smith wrote:

John R Pierce wrote:

is pl/java kind of dead? I don't see much activity since years ago.
this page seems quite out of date, talking about 1.1.0b1 released,
but the foundry has 1.4.0 from 2008 that supports 8.3. only

The last set of commits there was about 9 months ago, so it's not
quite as dead as it appears. The code in CVS supports 8.4, there just
hasn't been an official release in a while:
http://pgfoundry.org/tracker/?func=detail&amp;atid=335&amp;aid=1010695&amp;group_id=1000038

There are a couple of bugs to note at
http://pgfoundry.org/tracker/?atid=334&amp;group_id=1000038&amp;func=browse
like lack of support for JDK 1.6 and some known complier issues.

is there a pl/java mail list? I've started to begin to commence to try
to compile this stuff, I checked out the whole thing from CVS and when I
run make, I'm getting an error that there's missing files in the
postgres tree. I'm using the 8.4-community tarball for 64bit
postgresql from the postgres website, am I instead going to have to
build my own?

~/org.postgresql.pljava]$ gmake
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/classes/pljava'
gmake[1]: Nothing to be done for `all'.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/classes/pljava'
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/classes/deploy'
gmake[1]: Nothing to be done for `all'.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/classes/deploy'
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/objs'
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:59:
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.global:
No such file or directory
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:84:
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib:
No such file or directory
gmake[1]: *** No rule to make target
`/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib'.
Stop.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/objs'
gmake: *** [c_all] Error 2

this is on Solaris 10, UltraSparc, with SunStudio installed. the
postgres is the 8.4 community build, but I do note its only 8.4.1, and I
really should upgrade it to 8.4.3....
....20 mins later, upgraded to 8.4.3, and still getting same error.

pg_config says...

$ pg_config
BINDIR = /usr/postgres/8.4-community/bin/64
DOCDIR = /usr/postgres/8.4-community/share/doc
HTMLDIR = /usr/postgres/8.4-community/share/doc
INCLUDEDIR = /usr/postgres/8.4-community/include
PKGINCLUDEDIR = /usr/postgres/8.4-community/include
INCLUDEDIR-SERVER = /usr/postgres/8.4-community/include/server
LIBDIR = /usr/postgres/8.4-community/lib/64
PKGLIBDIR = /usr/postgres/8.4-community/lib/64
LOCALEDIR = /usr/postgres/8.4-community/share/locale
MANDIR = /usr/postgres/8.4-community/man
SHAREDIR = /usr/postgres/8.4-community/share
SYSCONFDIR = /usr/postgres/8.4-community/etc
PGXS = /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/postgres/8.4-community'
'--exec-prefix=/usr/postgres/8.4-community'
'--bindir=/usr/postgres/8.4-community/bin/64'
'--libexecdir=/usr/postgres/8.4-community/bin/64'
'--sbindir=/usr/postgres/8.4-community/bin/64'
'--datadir=/usr/postgres/8.4-community/share'
'--sysconfdir=/usr/postgres/8.4-community/etc'
'--mandir=/usr/postgres/8.4-community/man'
'--libdir=/usr/postgres/8.4-community/lib/64'
'--includedir=/usr/postgres/8.4-community/include'
'--sharedstatedir=/var/postgres/8.4-community'
'--localstatedir=/var/postgres/8.4-community'
'--with-system-tzdata=/usr/share/lib/zoneinfo' '--enable-nls'
'--with-docdir=/usr/postgres/8.4-community/doc' '--with-python'
'--with-pam' '--with-openssl' '--with-libedit-preferred' '--with-libxml'
'--with-libxslt' '--with-gssapi' '--enable-thread-safety'
'--enable-dtrace' 'DTRACEFLAGS=-64'
'--with-includes=/zstore/pgsql/pg84b1/proto/root_sparc/usr/include:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include:/usr/sfw/include'
'--with-tclconfig=/usr/sfw/lib'
'--with-libs=/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64:/usr/lib/64:/usr/sfw/lib/64'
'CC=/opt/SUNWspro/SS11/bin/cc' 'CFLAGS=-xO3 -xarch=v9 -dalign
-Wc,-Qiselect-regsym=0 -xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff '
'LDFLAGS=-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64
-L/usr/sfw/lib/64'
'CPPFLAGS=-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include'
CC = /opt/SUNWspro/SS11/bin/cc
CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include
-I/usr/sfw/include -I/usr/include/libxml2
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include
CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace -W0,-Lt
-W2,-Rcond_elim -Xa -xildoff
CFLAGS_SL = -KPIC
LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64
-L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64'
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgss -lz -ledit
-ltermcap -lnsl -lrt -lsocket -lm
VERSION = PostgreSQL 8.4.3

.... my CC is...

$ which cc
/opt/SUNWspro/bin/cc
$ cc -V
cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22
usage: cc [ options] files. Use 'cc -flags' for details

On Wed, 2010-04-14 at 22:53 -0400, Bruce Momjian wrote:

Damian Carey wrote:

On Thu, Apr 15, 2010 at 6:18 AM, John R Pierce <pierce@hogranch.com> wrote:

Joshua D. Drake wrote:

Mostly, I think you will find that the back end developers aren't fond
of Java and thus, it doesn't get much love.

There is a reason that plPerl is king in this community (and I don't
even like Perl).

Java2perl anyone ?
http://search.cpan.org/~philcrow/Java-Javap-0.04/bin/java2perl6
(99% joking)

And if you think positively a 14hour TZ difference is really only 10
if you go the other way.

Is PL/J still being developed? I can't find it myself, but was curious.

Not as far as I know.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering