agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Questions about pl/java
Date: Wed, 5 Apr 2006 10:59:02 +0200
Message-ID: <003e01c6588f$3034eba0$1e03a8c0@fhrbek> (raw)
References: <1d219a6f0604041903k528c7b27pd3f640cb03300390@mail.gmail.com>
	<44336D62.3000309@tada.se>

Hi all,

I would like to put some comments to Chris's questions...

****
2.  Is anyone using pl/java in a production environment?  If so, how long 
have you been using it in production.
****

Yes, we do. We have implemented a universal data warehouse based on 
PostgreSQL and PL/Java. It has been running in a production environment for 
about half a year, with no problems reported. I love this solution, becase 
of all the reasons Thomas has already mentioned (complexity, easy 
developement using IDE (Eclipse in our case) and many many more...)

> ## Limitations: ##
> ** Overly complex for very simple tasks
> Java code needs to be compiled, packaged in a jar file, and installed
> into the database. pgsql code is embedded in the function declaration.
>

Yes, this is true, but it can also be solved. Users of our data warehouse 
can configure its behaviour by writing small pieces of Java code (plugins) 
directly into the database. Once you install "tools.jar" into your database, 
you can implement a database function (written in pl/java of course) for 
compiling and installing Java procedures on-the-fly if you wish (the same 
idea like Oracle Java Sources).

Filip

PS: Thomas, do you plan fixing the getTime() bug?

view thread (4+ messages)  latest in thread

Message-ID: <003e01c6588f$3034eba0$1e03a8c0@fhrbek>
Permalink:  ../003e01c6588f$3034eba0$1e03a8c0@fhrbek/
Also on:    postgresql.org/message-id/003e01c6588f$3034eba0$1e03a8c0@fhrbek

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Questions about pl/java
  In-Reply-To: <003e01c6588f$3034eba0$1e03a8c0@fhrbek>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox