[Pljava-dev] How stable is pljava?

Greetings,
I am working on a new architecture for a healthcare application, and I have
been defending the idea of using the capabilities of the db layer (that is
postgresql) to the max, with every single advantage that our choice of
technology can provide.

pl/java is in many ways a great option for my quite specific requirements,
but if I invest in it, I have to assume the same kind of stability I'd
expect from pl/pgsql, becuse I'd be placing my bets for on pl/java for key
application functionality.

So I'd appreciate your feedback about the maturity/stability of pljava. Is
it used in production servers in finance/healthcare? Is it used in any big
postgresql installations where uptime needs to be 99.99% ?

Kind regards
Seref
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120328/94925b2f/attachment.html>

On 28/03/12 17:58, Seref Arikan wrote:
> Greetings,
> I am working on a new architecture for a healthcare application, and I
> have been defending the idea of using the capabilities of the db layer
> (that is postgresql) to the max, with every single advantage that our
> choice of technology can provide.
>
> pl/java is in many ways a great option for my quite specific
> requirements, but if I invest in it, I have to assume the same kind of
> stability I'd expect from pl/pgsql, becuse I'd be placing my bets for
> on pl/java for key application functionality.
>
> So I'd appreciate your feedback about the maturity/stability of
> pljava. Is it used in production servers in finance/healthcare? Is it
> used in any big postgresql installations where uptime needs to be
> 99.99% ?
>
> Kind regards
> Seref

We've been using it solidly every day for about 6 years I think - seems
bullet-proof to me ;)

--
Tim Clarke MBCS
IT Director
Manifest
9 Freebournes Court
Newland Street
Witham, Essex
CM8 2BL
England

Phone: +44 1376 503500
Direct: +44 1376 504510
Fax: +44 1376 503550
Email: tim.clarke at manifest.co.uk <mailto:tim.clarke at manifest.co.uk>
Web: http://www.manifest.co.uk
Skype: callto:tim.clarke

Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd:
Registered in England Number 2920820. Registered Office at above address. VAT Registration Number: GB 700 1880 77
Copyright: This e-mail may contain confidential or legally privileged information.
If you are not the named addressee you must not use or disclose such information, instead please report it to: admin at manifest.co.uk
Please see http://www.manifest.co.uk/legal/legal_notices.htm for further information.

Hi Tim,
Thank you, this is exactly the kind of real life experience I wanted to
hear about. Do you mind letting me know about the type of tasks you perform
with pljava? I'm especially interested in the cases where networks
connections are used.
If that is not possible, thanks anyway for your kind response

Kind regards
Seref

On Wed, Mar 28, 2012 at 6:57 PM, Tim Clarke <tim.clarke at manifest.co.uk>wrote:

> On 28/03/12 17:58, Seref Arikan wrote:
> > Greetings,
> > I am working on a new architecture for a healthcare application, and I
> > have been defending the idea of using the capabilities of the db layer
> > (that is postgresql) to the max, with every single advantage that our
> > choice of technology can provide.
> >
> > pl/java is in many ways a great option for my quite specific
> > requirements, but if I invest in it, I have to assume the same kind of
> > stability I'd expect from pl/pgsql, becuse I'd be placing my bets for
> > on pl/java for key application functionality.
> >
> > So I'd appreciate your feedback about the maturity/stability of
> > pljava. Is it used in production servers in finance/healthcare? Is it
> > used in any big postgresql installations where uptime needs to be
> > 99.99% ?
> >
> > Kind regards
> > Seref
>
> We've been using it solidly every day for about 6 years I think - seems
> bullet-proof to me ;)
>
> --
> Tim Clarke MBCS
> IT Director
> Manifest
> 9 Freebournes Court
> Newland Street
> Witham, Essex
> CM8 2BL
> England
>
> Phone: +44 1376 503500
> Direct: +44 1376 504510
> Fax: +44 1376 503550
> Email: tim.clarke at manifest.co.uk <mailto:tim.clarke at manifest.co.uk>
> Web: http://www.manifest.co.uk
> Skype: callto:tim.clarke
>
> Manifest is the trading name of: Manifest Information Services Ltd:
> Registered in England Number 3401145 & The Manifest Voting Agency Ltd:
> Registered in England Number 2920820. Registered Office at above address.
> VAT Registration Number: GB 700 1880 77
> Copyright: This e-mail may contain confidential or legally privileged
> information.
> If you are not the named addressee you must not use or disclose such
> information, instead please report it to: admin at manifest.co.uk
> Please see http://www.manifest.co.uk/legal/legal_notices.htm for further
> information.
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20120328/fd917225/attachment.html>

On 28/03/12 19:30, Seref Arikan wrote:
> Hi Tim,
> Thank you, this is exactly the kind of real life experience I wanted
> to hear about. Do you mind letting me know about the type of tasks you
> perform with pljava? I'm especially interested in the cases where
> networks connections are used.
> If that is not possible, thanks anyway for your kind response
>
> Kind regards
> Seref

Sure, we call an extensive calculation routine from within our Postgres
database via a group of stored procedures. The Java thus called makes
database updates of its own dependant upon those calculations. We did it
simply because PL/Java couldn't replicate the logic we needed.

--
Tim Clarke MBCS
IT Director
Manifest
9 Freebournes Court
Newland Street
Witham, Essex
CM8 2BL
England

Phone: +44 1376 503500
Direct: +44 1376 504510
Fax: +44 1376 503550
Email: tim.clarke at manifest.co.uk <mailto:tim.clarke at manifest.co.uk>
Web: http://www.manifest.co.uk
Skype: callto:tim.clarke

Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd:
Registered in England Number 2920820. Registered Office at above address. VAT Registration Number: GB 700 1880 77
Copyright: This e-mail may contain confidential or legally privileged information.
If you are not the named addressee you must not use or disclose such information, instead please report it to: admin at manifest.co.uk
Please see http://www.manifest.co.uk/legal/legal_notices.htm for further information.