RE: [Log4plsql] technical question about log4plsql

[<log...@li...>]

Ciao Luciano.

You're absolutely right that it's much easier to use autonomous transactions
than DBMS_PIPE for obtaining separate transaction space. But since Log4PLSQL
is based on Log4J (an open source Logging API for Java) you need to have
Log4J's Java code running somewhere. The Log4PLSQL architects chose to run
Log4J outside the database in a server process because Oracle JServer has at
least one severe "feature" where it automatically closes open file handles
at the end of a Java stored procedure call, which means that open file
handles become invalid.

HTH.

Ciao,

Finn

---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: fe...@ch...                      DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
                      "Where do you want to GPF today?"

-----Original Message-----
From: log...@li...
[mailto:log...@li...]
Sent: Wednesday, 23 October, 2002 17:17
To: log...@li...
Subject: [Log4plsql] technical question about log4plsql


Dear Sirs,
This morning I tried log4plsql just to have a perspective of its use in our
environment and I found it really great.
There is a technical question I would like to submit to you, concerning the
use of dbms_pipe to implement a log transaction independent from the main
one. It seems to me pretty simpler to use an autonomous transaction, as
allowed in Oracle 8i. Is there any reason why dbms_pipe was used instead? I
heard about an odd bug affecting autonomous transactions when used together
a database link (bug 692232: Metalink can be visited for details), but it
has been solved in Oracle 9.0.2.
I would appreciate very much an opinion on this point.

Thank you in advance.

Best regards

Luciano Morello
DATA CONSULT S.I.
Pordenone - Italy
luc...@da...