log4plsql-all-info

[Log4plsql] technical question about log4plsql

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

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.=20
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...

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...

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