Postgres Pro
Downloads
Home   >   mailing lists

Thread: pl/java status

pl/java status

From
John R Pierce
Date:
is pl/java kind of dead?   I don't see much activity since years ago.


I note the pgfoundry page, http://pgfoundry.org/projects/pljava/?readme
the link to the project home page
http://wiki.tada.se/display/pljava/Home is broken


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

Re: pl/java status

From
Greg Smith
Date:
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

Re: pl/java status

From
John R Pierce
Date:
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?

Re: pl/java status

From
Craig Ringer
Date:
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

Re: pl/java status

From
"Joshua D. Drake"
Date:
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

Re: pl/java status

From
John R Pierce
Date:
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 :)

Re: pl/java status

From
Damian Carey
Date:
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

Re: pl/java status

From
"Joshua D. Drake"
Date:
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

Re: pl/java status

From
Bruce Momjian
Date:
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

Re: pl/java status

From
John R Pierce
Date:
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.

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

Re: pl/java status

From
"Joshua D. Drake"
Date:
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

Re: pl/java status

From
"Joshua D. Drake"
Date:
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