RE: RE: [Log4plsql] technical question about log4plsql

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

Finn,

Thank for your responce in this mailing list.

You're absolutely right in yours responces.

In more, I don't use JServer because, is possible to use
log4plsql without JServer and Log4J.
Now, is possible to use log4plsql in Oracle7 without java.


Regards
Guillaume


> -----Message d'origine-----
> De : log...@li...
> [mailto:log...@li...]
> Envoy=E9 : mercredi 23 octobre 2002 17:48
> =C0 : log...@li...
> Objet : RE: [Log4plsql] technical question about log4plsql
>
>
> 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...




-------------------------------------------------------
This sf.net email is sponsored by: Influence the future
of Java(TM) technology. Join the Java Community
Process(SM) (JCP(SM)) program now.
http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0002en

_______________________________________________
Log4plsql-all-info mailing list
Log...@li...
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net