Re: Experiences with pl/Java

From: "Welty, Richard" <rwelty(at)ltionline(dot)com>
To: Thomas Hill <Thomas(dot)K(dot)Hill(at)t-online(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Experiences with pl/Java
Date: 2012-11-19 14:55:49
Message-ID: 1579549587CEA24C85CE49CE261FA5E10FD6C9BD@ltischcorpx01.lti.int
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i used it for a project about 6 months ago. it took a little bit of effort to get things going, and the documentation could use some work, but it was reliable once i got oriented.

the developer does read the mailing list, and responds to requests for help.

i think you could use it in production so long as you have good processes in place and can dedicate some developer time to learning & supporting it. but it's definitely not plug and play right now.

richard
________________________________________
From: pgsql-general-owner(at)postgresql(dot)org [pgsql-general-owner(at)postgresql(dot)org] on behalf of Thomas Hill [Thomas(dot)K(dot)Hill(at)t-online(dot)de]
Sent: Monday, November 19, 2012 3:02 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Experiences with pl/Java

Hi,

was wondering if there is anyone wanted to share some experiences gained
and some knowledge on pl/Java. Have looked into it for a couple of days
now and am getting the impression it is not something ready to use in
production environment. Also have trouble sending to the developer
mailing list (the last email on the mail archive of that list is almost
three weeks old) which raises questions on how active this project is.

Have worked with PostgreSQL and pg/SQL before and also used Apache Derby
in the past. On Apache Derby I have implemented some stored procedures
using Java code and my interst now was on seeing how much of this could
be re-used this pl/Java so PostgreSQL could potentially become a second
data base backend my application would run on.

But trying to port my java procedures from Derby to PostgreSQL had a bad
start and for me pl/Java and the support around it so far suggest not to
pursue this any further. Why?.
Porting the simlest procedure was possible, but trying procedures with
out parameters was not.

Has anyone made the same experience with pl/Java or is it just my lack
of understanding (in conjunction with a lack of documentation on pl/Java).

Thanks a lot in advance
Thomas

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-11-19 15:22:06 Re: How to upgrade postgres 8.4 -> 9.1 contrib?
Previous Message Merlin Moncure 2012-11-19 14:33:22 Re: High SYS CPU - need advise