agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] java.lang.SecurityException
Date: Tue, 29 Mar 2005 08:59:40 +0200
Message-ID: <4248FCDC.7080104@mailblocks.com> (raw)
In-Reply-To: <005801c53426$99907530$1e03a8c0@fhrbek>
References: <11C803742910E84E9CDBFD344773B814759F9C@srqech02.teltronics.com>
	<005801c53426$99907530$1e03a8c0@fhrbek>

Filip Hrbek wrote:

> Thomas, I think there could be one reason to use explicit JDBC driver 
> within PL/Java routine if you want to log something in an autonomous 
> transaction (if your session crashes or is rolled back, logged items 
> remain saved).
>
Yes, that would be a special case where it (perhaps) would make sense 
although the performance hit caused by such logging would be 
significant. I wouldn't recommend it. One major reason to move 
functionality into functions is to get rid of the overhead of using a 
remote process. Logging through a client jdbc driver will introduce that 
overhead once again and every session that uses it will tie up two 
backend processes. I'm not sure of what use case you are thinking of but 
perhaps it can be solved using the standard java.util.log.Logger? 
Entries written there ends up in the backend log. Formatted the right 
way they should be easy to parse if need be.

Regards,
Thomas Hallgren

view thread (35+ messages)  latest in thread

Message-ID: <4248FCDC.7080104@mailblocks.com>
Permalink:  ../4248FCDC.7080104@mailblocks.com/
Also on:    postgresql.org/message-id/4248FCDC.7080104@mailblocks.com

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] java.lang.SecurityException
  In-Reply-To: <4248FCDC.7080104@mailblocks.com>

* 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