log4plsql-all-info Mailing List for LOG4PLSQL (Page 2)

Hari,

# the location for yours log4j configuration file

  <category name=3D"log4j">
    <property name=3D"properties" value=3D".\properties\log4j.properties"=
 />
  </category>

# Yours oracle database
  <category name=3D"JDBC">
    <property name=3D"URL" value=3D"jdbc:oracle:thin:@localhost:1521:ORAT=
EST"/>
    <property name=3D"USER" value=3D"ulog" />
    <property name=3D"PWD" value=3D"ulog" />
  </category>

# the standard don't change.
  <category name=3D"ACTION">
    <property name=3D"deleteInDatabase" value=3D"Y" />
  </category>



I think, you have some problem when you use log4j. find
"WARN Please initialize the log4j system properly"
In log4j maling list or in your internet search engine

Guillaume Moulard


Selon log4plsql general mailing list <log...@li...=
e.net>:

>
> Hi,
>       I have been trying to install LOG4PLSQL in my enivronment. I am a=
ble
> to use the logging features for the stored procedures(i.e.install.sh wo=
rks
> fine). But when I try to run the startLog4JbackgroundProcess script (to=
 use
> the log4j features) I am getting the following problem.
>
> /oracle/app/product/9.2.0
> /tmp/Log4plsql/lib/log4plsql.jar:/oracle/app/product/9.2.0
> /lib/runtime12.jar:/oracle/app/product/9.2.0
> /lib/nls_charexport12.jar:/oracle/app/product/9.2.0
> /lib/classes12.jar:/oracle/app/product/9.2.0
> /lib/xmlcomp.jar:/oracle/app/product/9.2.0
> /lib/xmlparserv2.jar:/oracle/app/product/9.2.0
> /tmp/Log4plsql/lib/log4j-1.2.8.jar::/oracle/app/product/9.2.0
> /tmp/Log4plsql/lib/runtime12ee.jar:/oracle/app/product/9.2.0
> /tmp/Log4plsql/lib/runtime12.jar:/oracle/app/product/9.2.0
> /jdbc/classes12.zip:/oracle/app/product/9.2.0
> /jdbc/lib/classes12.jar:/oracle/app/product/9.2.0/jdbc/lib/jndi.jar
> CLASSPATH
> start listener
> log4j:WARN No appenders could be found for logger (backgroundProcess).
> log4j:WARN Please initialize the log4j system properly.
>
> Also,I am also little unclear as to where exactly the following tags go=
.
>
> <?xml version=3D"1.0" ?>
> <properties>
> =A0 <category name=3D"log4j">
> =A0=A0=A0 <property name=3D"properties" value=3D".\properties\log4j.pro=
perties" />
> =A0 </category>
> =A0 <category name=3D"JDBC">
> =A0=A0=A0 <property name=3D"URL" value=3D"jdbc:oracle:thin:@localhost:1=
521:ORATEST"
> />
> =A0=A0=A0 <property name=3D"USER" value=3D"ulog" />
> =A0=A0=A0 <property name=3D"PWD" value=3D"ulog" />
> =A0 </category>
> =A0 <category name=3D"ACTION">
> =A0=A0=A0 <property name=3D"deleteInDatabase" value=3D"Y" />
> =A0 </category>
> </properties>
>
> It would great if you can help me in this regard.
>
> Hari
>
> This e-Mail may contain proprietary and confidential information and is=
 sent
> for the intended recipient(s) only.  If by an addressing or transmissio=
n
> error this mail has been misdirected to you, you are requested to delet=
e this
> mail immediately. You are also hereby notified that any use, any form o=
f
> reproduction, dissemination, copying, disclosure, modification, distrib=
ution
> and/or publication of this e-mail message, contents or its attachment o=
ther
> than by its intended recipient/s is strictly prohibited.
>
> Visit us at http://www.polaris.co.in
>
> -----------------------------------------------------------------------=
--
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> Get stuff done quickly with pre-integrated technology to make your job =
easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Log4plsql-all-info mailing list
> Log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
> log4plsq : http://log4plsql.sourceforge.net
>

Hi,
      I have been trying to install LOG4PLSQL in my enivronment. I am able
to use the logging features for the stored procedures(i.e.install.sh works
fine). But when I try to run the startLog4JbackgroundProcess script (to use
the log4j features) I am getting the following problem.

/oracle/app/product/9.2.0
/tmp/Log4plsql/lib/log4plsql.jar:/oracle/app/product/9.2.0
/lib/runtime12.jar:/oracle/app/product/9.2.0
/lib/nls_charexport12.jar:/oracle/app/product/9.2.0
/lib/classes12.jar:/oracle/app/product/9.2.0
/lib/xmlcomp.jar:/oracle/app/product/9.2.0
/lib/xmlparserv2.jar:/oracle/app/product/9.2.0
/tmp/Log4plsql/lib/log4j-1.2.8.jar::/oracle/app/product/9.2.0
/tmp/Log4plsql/lib/runtime12ee.jar:/oracle/app/product/9.2.0
/tmp/Log4plsql/lib/runtime12.jar:/oracle/app/product/9.2.0
/jdbc/classes12.zip:/oracle/app/product/9.2.0
/jdbc/lib/classes12.jar:/oracle/app/product/9.2.0/jdbc/lib/jndi.jar
CLASSPATH
start listener
log4j:WARN No appenders could be found for logger (backgroundProcess).
log4j:WARN Please initialize the log4j system properly.

Also,I am also little unclear as to where exactly the following tags go.

<?xml version=3D"1.0" ?>
<properties>
=A0 <category name=3D"log4j">
=A0=A0=A0 <property name=3D"properties" value=3D".\properties\log4j.propert=
ies" />
=A0 </category>
=A0 <category name=3D"JDBC">
=A0=A0=A0 <property name=3D"URL" value=3D"jdbc:oracle:thin:@localhost:1521:=
ORATEST"
/>
=A0=A0=A0 <property name=3D"USER" value=3D"ulog" />
=A0=A0=A0 <property name=3D"PWD" value=3D"ulog" />
=A0 </category>
=A0 <category name=3D"ACTION">
=A0=A0=A0 <property name=3D"deleteInDatabase" value=3D"Y" />
=A0 </category>
</properties>

It would great if you can help me in this regard.

Hari

This e-Mail may contain proprietary and confidential information and is sen=
t for the intended recipient(s) only.  If by an addressing or transmission =
error this mail has been misdirected to you, you are requested to delete th=
is mail immediately. You are also hereby notified that any use, any form of=
 reproduction, dissemination, copying, disclosure, modification, distributi=
on and/or publication of this e-mail message, contents or its attachment ot=
her than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

Hi,

Could you send more informartion about your system.
Whitch version for yours database and for log4plsql.

Could you send you plsql code.

Does you log4plsqls instalation is ok?

guillaume

----- Message d'origine -----
De: "log4plsql general mailing list" <log...@li....=
net>
=C0: log...@li...
Env: 16/08/06 14:45
Objet: [log4plsql] Dynamic logging level

Hello to all users of Log4plsql

Thanks in advance.

I am getting one problem in dynamic logging level. When I am trying to set
log level using PLOG.setlevel(pctx, plog.ldebug); it is giving error and
error logged as

[Aug 16, 16:57:47:62][ERROR][AQTEST][block][SQLCODE:-20501
SQLERRM:ORA-20501: SetLevel (-999.99) not in TLOGLEVEL table]

But in your example it is able to set log level please give the solution fo=
r
the same.

=20

Thanks

-HDD

Chenhui,

All features include in my article are include in the curent production rel=
ease(3.x)

Regards,
G
----- Message d'origine -----
De: "Chenhui Liu" <cl...@ca...>
=C0: gmo...@us...
Env: 17/08/06 20:53
Objet: question regarding log4plsql

Hi Guillaume,

I found this great article about log4plsql at

 http://www.oracle.com/technology/pub/articles/moulard_log4plsql.html

It indicated that you are the key contributor. I'd like to know the
current state-of-the-art of log4plsql. Specifically, are the features
mentioned in the article being implement by now:

"In its first release, you were able to manage logs and traces in an
Oracle table, inside or outside the current transaction. The second
release added Log4j features, such as the ability to log to many
different destinations (such as external file, mail, console, and SMTP).
In the next release (scheduled for January 2004), Log4plsql will add an
applicative framework for checking errors, logs, traces and exceptions
in PL/SQL code-supporting automatic management of Oracle error log
messages, writing of logs and traces in the alert.log and in the Oracle
trace files, easy debugging (error stack, call stack, assert, and so
on), the addition of custom log level, and more. "

Please kindly advice.

Regards,

Chenhui

=20

Hello to all users of Log4plsql

Thanks in advance.

I am getting one problem in dynamic logging level. When I am trying to set
log level using PLOG.setlevel(pctx, plog.ldebug); it is giving error and
error logged as

[Aug 16, 16:57:47:62][ERROR][AQTEST][block][SQLCODE:-20501
SQLERRM:ORA-20501: SetLevel (-999.99) not in TLOGLEVEL table]

But in your example it is able to set log level please give the solution for
the same.

 

Thanks

-HDD

 Hi -

 

Do you know of any "standards" that companies may have implemented
relative to the use of Log4PLSQL?  For example -

 

Issue an information log message containing the name of the package and
module name at the beginning of each package's procedure or function ...

 

If you know of any, or have any suggestion regarding such standards, I
would really appreciate your input.

 

We're going to try to use this product within a new application we are
developing here, and I want to be sure we are doing it RIGHT!

 

Thank you so much.

 

JoAnn 

I have changed then function calleurname and now returns line numbers 
for calls. I think it is very useful and should figure in the next 
release. the code is this:

FUNCTION calleurname return varchar2
IS
    endOfLine   constant    char(1) := chr(10);
    endOfField  constant    char(1) := chr(32);
    nbrLine     number;
    ptFinLigne  number;
    ptDebLigne  number;
    ptDebCode   number;
    pt1         number;
    cpt         number;
    allLines    varchar2(4000);
    resultat    varchar2(4000);
    Line        varchar2(4000);
    LineNumber  varchar2(10);
    ptDebCode2   number;
    UserCode    varchar2(4000);
    myName      varchar2(2000) := '.PLOG';
begin
    allLines    := dbms_utility.format_call_stack;
    cpt         := 2;
    ptFinLigne  := length(allLines);
    ptDebLigne  := ptFinLigne;

    While ptFinLigne > 0 and ptDebLigne > 83 loop
       ptDebLigne   := INSTR (allLines, endOfLine, -1, cpt) + 1 ;
       cpt          := cpt + 1;
       -- traite ligne
       Line         := SUBSTR(allLines, ptDebLigne, ptFinLigne - 
ptDebLigne);
       ptDebCode    := INSTR (Line, endOfField, -1, 1);
       UserCode     := SUBSTR(Line, ptDebCode+1);
       ptDebCode2    := INSTR (Line, endOfField, -1, 4);
       ptDebCode    := INSTR (Line, endOfField, -1, 5);
       LineNumber   := SUBSTR(Line, ptDebCode+1,ptDebCode2 - ptDebCode-1);

       IF instr(UserCode,myName) = 0 then
           IF cpt > 3 then
             resultat := resultat||'.';
           end IF;
           resultat := resultat||UserCode||(CASE WHEN LineNumber IS NULL 
THEN '' ELSE '('||LineNumber||')' END);
       end if;
       ptFinLigne := ptDebLigne - 1;
     end loop;

return resultat;
end calleurname;

thanks.

In Log4PlSql (version 3.1.3.1) there is a problem setting the level for
'log4plsql' log4j logger. Namely, the next line inside the configuration
file seems to have no effect (all messages will be passed down to the
root logger, i.e. as it would be in case of =
log4j.logger.log4plsql=3DALL):

log4j.logger.log4plsql=3DWARN

The technique presented in the official documentation is also broken.
Any suggestions? Thanks!

In Log4PlSql (version 3.1.3.1) there is a problem setting the level for
'log4plsql' log4j logger. Namely, the next line inside the configuration
file seems to have no effect (all messages will be passed down to the
root logger):

# Behaves in the same way as, for example, =
log4j.logger.log4plsql=3DDEBUG
log4j.logger.log4plsql=3DWARN

The technique presented in the official documentation is also broken.
Any suggestions? Thanks!

Hi,

	Can log4plsql be installed and run in Oracle 10g?  Are there any limitatio=
ns?

Thanks,

Paul


The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure.  If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof.  Thank you.

Dear,

In the new release of Log4j the DB appending is now based on 3 tables instead of 1, as initially proposed in various implementation of an appender to the DB.
Herewith the new proposed DB structure in Log4J (logging-log4j-1.3alpha-8\src\java\org\apache\log4j\db\dialect).
Has there plans to move Log4PLSQL to a a similar structure ... ?

\T,



 
-- Any fool can write code that a computer can understand. 
Good programmers write code that humans can understand.
                                                   Martin Fowler 
T. : +32 (0)2 742 05 94
M. : +32 (0)497 44 68 12
@  : duv...@ya...
Do you skype too ... ?

The fact that you write to a DB will always make the process slower (than writting to a file) per se.
Now many elements should be considered (DB has huge memory, multi process, IO's in C/C++ versus pure Java) to confirm this but I can afford a small performance impact to gain system wide improved reporting, facility, ... ! ! !

What I found funny is that nobody mentionned the work of the jdbc-appender
http://www.dankomannhaupt.de/projects/

Their tables looks more appropriate  for Java than the simple tables  of Log4plsql.
I think I will inspire myself from the code of Heri  and adapt the work of the log4plsql to have NDC in the table too !

\T,


 
-- Any fool can write code that a computer can understand. 
Good programmers write code that humans can understand.
                                                   Martin Fowler 
T. : +32 (0)2 742 05 94
M. : +32 (0)497 44 68 12
@  : duv...@ya...
Do you skype too ... ?

----- Original Message ----
From: Bender Heri <HB...@Er...>
To: Log4J Users List <log...@lo...>
Sent: Wednesday, March 8, 2006 2:54:57 PM
Subject: RE: Using the same tables for log4j with JDBC appender and Log4PLSQL

I have not noticed a performance impact, since we log only WARN, ERROR, and FATAL into DB. And this occurs not that often.
Heri

> -----Original Message-----
> From: Rakesh Patel [mailto:rak...@gm...]
> Sent: Wednesday, March 08, 2006 2:50 PM
> To: Log4J Users List
> Subject: Re: Using the same tables for log4j with JDBC appender and
> Log4PLSQL
> 
> 
> Thank you, what about performance?
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: log...@lo...
For additional commands, e-mail: log...@lo...

We are foreseen to use Log4PLSQL in our DB & I was wandering if we could use this for our WebApp to...
I would like to kknow if there are people who use both and preferably inserting the messages into the same tables ?

Tx,

\T,

 
-- Any fool can write code that a computer can understand. 
Good programmers write code that humans can understand.
                                                   Martin Fowler 
T. : +32 (0)2 742 05 94
M. : +32 (0)497 44 68 12
@  : duv...@ya...
Do you skype too ... ?

Hi,

Yes it's verry good if you publish your update.

Guillaume.
----- Message d'origine -----
    De: "Detlev"<det...@us...>
    Env: 13/02/06 10:00:44
    À: "gmo...@us..."<gmo...@us...>
    Cc: "det...@us..."<det...@us...>
    Objet: Extension to log4plsql
    
    
    Message body follows:
    
    Hello,
    
    I downloaded log4plsql and I think it is a fantastic product. 
    I had no problems toinstall and to get first tests running. 
    I'm very interested in using the tool in my applications. I
    have a tool that can also log events via dbms_pipe to a
    running background process. But it is completly inside the
    DB and writes out with utl_file.
    
    One thing that I ran into with log4plsql is when you use the
    background logger and the background process is not running,
    the application stops because of the filled pipe. 
    I solved that problem in my packages. If you are interested
    I can give you a tip.
    
    I think it would be also useful in log4plsql if the
    application doesn't hang when the background job doesn't run.
    
    I will go on testing log4plsql and find out the features. 
    
    I'm also member of the DOAG which is the German Oracle
    Usergroup and I'm thinking about a presentation of log4plsql
    when I found out about the features.
    
    If I find the time I think about a german translation of the
    documentation. 
    
    Regards
    Detlev Mörk
    
    
    --
    This message has been sent to you, a registered SourceForge.net user,
    by another site user, through the SourceForge.net site.  This message
    has been delivered to your SourceForge.net mail alias.  You may reply
    to this message using the "Reply" feature of your email client, or
    using the messaging facility of SourceForge.net at:
    https://sourceforge.net/sendmessage.php?touser=1307632
    
    

hi, 

I don't know a good way.

some idee:

- you can make a script for chage all you plsql code. but you can test all you application.

- you can change your code manuly only when you whant use a 'advence' feature of log4plsql

guillaume


 

----- Message d'origine -----
    De: "Mahadevan Krishnan"    Env: 05/02/06 19:17:42
    À: "gmoulard"    Objet: LOG4PLSQL
      Hi,
    
    I was just going through LOG4PLSQL. It would indeed help developers a
    lot..Good One.. But in our application we have almost around 1000
    Procedures/Packages/Triggers/Functions altogther where we have used
    DBMS_OUTPUT package. Is there a way to configure to use this LOG4PLSQL
    directly without making any changes to the existing code manually?
    
    Looking forward to hear your suggestions on this
    
    Thanks & Regards
    
    Mahadevan
    

Please include me in your mailing list.
=20
Thanks
=20
Lydia
=20

The electronic mail message you have received and any files transmitted
with it are confidential and solely for the intended addressee(s)'s
attention. Do not divulge, copy, forward, or use the contents,
attachments, or information without permission of Fannie Mae.
Information contained in this message is provided solely for the purpose
stated in the message or its attachment(s) and must not be disclosed to
any third party or used for any other purpose without consent of Fannie
Mae. If you have received this message and/or any files transmitted with
it in error, please delete them from your system, destroy any hard
copies of them, and contact the sender.    =20


=20

Hi,
=0D
You can start the background process when you whant use it :)
=0D
if you whant log only in  database, alert.log, trace file or in dbms_output
is not necessary to start the background process.
=0D
when you whant use the log4j capability, you can start this process.=0D
=0D
Guillaume
=0D

  _____ =0D

De : log...@li...
[mailto:log...@li...]=0D
Envoy=E9 : lundi 10 octobre 2005 16:13
=C0 : 'log...@li...'
Objet : [log4plsql] Background process



Hello,

=0D

I'm just about to start evaluating log4plsql. The DBAs are refusing to
install it unless I tell them what the background process does and why it
has to be left running.

=0D

The script runs the following

=0D

. ./setVariable.sh

cd $LOG4PLSQL_HOME

echo start listener

java log4plsql.backgroundProcess.Run ./properties/log4plsql.xml

=0D

=0D

Does anyone either know what this does, or know where the relevant
documentation is.

=0D

Thanks!

This is an email from the CPP Group Plc, Holgate Park, York, YO26 4GA;
telephone +44 (0)1904 544500.
This message may contain information that is confidential. If you are not
the intended recipient,
you may not peruse, use, disseminate, distribute or copy this message. If
you have received this
message in error, please notify the sender immediately by email, facsimile
or telephone and either
return or destroy the original message.
The CPP Group Plc accepts no responsibility for any changes made to this
message after it has been
sent by the original author. This email has been scanned for all viruses by
the MessageLabs Email Security System.
=0D


***********************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont=
 confidentiels et etablis a l'intention exclusive de
ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France=
 Telecom decline toute responsabilite au titre de
ce message s'il a ete altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire=
 immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the "message") are confidential and=
 intended solely for the addressees. Any unauthorised
use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be=
 liable for the message if altered, changed or
falsified.
If you are not receiver of this message, please cancel it immediately and=
 inform the sender.
***********************************

The background process is only needed if you want to log via DBMS_PIPE,
which is then read by the Java background process and logged through Log4J.
If you don't need that log path, you don't need the background process.

On 10/10/05, log...@li... <
log...@li...> wrote:
>
>  Hello,
>
>  I'm just about to start evaluating log4plsql. The DBAs are refusing to
> install it unless I tell them what the background process does and why it
> has to be left running.
>
>  The script runs the following
>
>  . ./setVariable.sh
>
> cd $LOG4PLSQL_HOME
>
> echo start listener
>
> java log4plsql.backgroundProcess.Run ./properties/log4plsql.xml
>
>   Does anyone either know what this does, or know where the relevant
> documentation is.
>
>  Thanks!
>  This is an email from the CPP Group Plc, Holgate Park, York, YO26 4GA;
> telephone +44 (0)1904 544500.
> This message may contain information that is confidential. If you are not
> the intended recipient,
> you may not peruse, use, disseminate, distribute or copy this message. If
> you have received this
> message in error, please notify the sender immediately by email, facsimil=
e
> or telephone and either
> return or destroy the original message.
> The CPP Group Plc accepts no responsibility for any changes made to this
> message after it has been
> sent by the original author. This email has been scanned for all viruses
> by the MessageLabs Email Security System.
>

Hello,

 

I'm just about to start evaluating log4plsql. The DBAs are refusing to
install it unless I tell them what the background process does and why it
has to be left running.

 

The script runs the following

 

. ./setVariable.sh

cd $LOG4PLSQL_HOME

echo start listener

java log4plsql.backgroundProcess.Run ./properties/log4plsql.xml

 

 

Does anyone either know what this does, or know where the relevant
documentation is.

 

Thanks!



This is an email from the CPP Group Plc, Holgate Park, York, YO26 4GA; telephone +44 (0)1904 544500.
This message may contain information that is confidential. If you are not the intended recipient,
you may not peruse, use, disseminate, distribute or copy this message. If you have received this
message in error, please notify the sender immediately by email, facsimile or telephone and either
return or destroy the original message.
The CPP Group Plc accepts no responsibility for any changes made to this message after it has been
sent by the original author.  This email has been scanned for all viruses by the MessageLabs Email Security System.

Hi!

I found following code in plog.log, LOG4PLSQL_VERSION  =3D  '3.1.3.0' =
(similar in older versions)):
...
hdr :=3D TO_CHAR(pLDATE, =
'HH24:MI:SS')||':'||LTRIM(TO_CHAR(MOD(pLHSECS,100),'09'))||'-'||getLevelI=
nText(pLLEVEL)||'-'||pLSECTION||' ';
...
sys.DBMS_OUTPUT.PUT(hdr);
...
If pLSECTION is very big (several calls through packages) then following =
error happens:
ORU-10028: line length overflow, limit of 255 chars per line.

First recommendation:
Filter out in plog.callurname duplicate items, eg. call stack in the =
same package, to shorten pLSECTION.
Second recommendation:
Substring the second line above before output it to a length lower than =
255 and think about exactly the wrapping which follows in plog.log.
=20

With kind regards / Mit freundlichen Gruessen
-------------------------------------------------------------------------=
-----------
Dipl.-Ing. Torsten Kleiber
Organisation und Informationsverarbeitung - Anwendungsentwicklung
IKB Deutsche Industriebank AG
Wilhelm-B=F6tzkes-Strasse 1
40474 D=FCsseldorf

Fon +49 (211) 82 21-41 21
Fax +49 (211) 82 21-21 21
mailto:tor...@ik...
http://www.ikb.de

Diese Email begr=FCndet keine Verpflichtung der IKB, es sei
denn dies w=E4re durch schriftliche Vereinbarung mit dem
Empf=E4nger vereinbart.

This emails contents do not constitute a commitment by
IKB, except where provided for in a written agreement
between the bank and the recipient of this message.
-------------------------------------------------------------------------=
-----------=20

You would need to use a different log context object for that module - mayb=
e
make a package global that is initialized in the package body BEGIN section=
,
and then use it for all log calls in that package.

On 04/10/05, log...@li... <
log...@li...> wrote:
>
>
> Hi,
>
> I want to use LOG4PLSQL for debug information and i have a question about
> it? Is it possible to set the debug level for just one module (procedure)
> instead for the whole application?
>
> With kind regards,
>
> Marco Faber
> PricewaterhouseCoopers (the Netherlands)
>
> _________________________________________________________________
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from any
> computer.

Hi,

I want to use LOG4PLSQL for debug information and i have a question about 
it?  Is it possible to set the debug level for just one module (procedure) 
instead for the whole application?

With kind regards,

Marco Faber
PricewaterhouseCoopers (the Netherlands)


_________________________________________________________________
The information transmitted is intended only for the person or entity to 
which it is addressed and may contain confidential and/or privileged 
material.  Any review, retransmission, dissemination or other use of, or 
taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited.   If you 
received this in error, please contact the sender and delete the material 
from any computer.

Thanks Luc, thank you very much for your time and replying me.
 I have solved this problem by creating multiple background processes and=
=20
each process has different PIPE name.
 For the same process, PIPE name must be same for Stored Proc context and=
=20
log4plsql.properties file
 --Raja

 On 8/29/05, Luc Tanguay <luc...@be...> wrote:=20
>=20
> Raja,
>=20
> it may be possible to use section names with different log4j loggers.
> For example, if you define the section named "firstSection", the
> log4j.properties could have a line like:
>=20
> log4j.logger.log4plsql.PIPENAME.USERNAME.firstSection=3DDEBUG, myAppender
>=20
> where
> PIPENAME is the name of the Oracle pipe (default is LOG_PIPE)
> USERNAME is the Oracle user using the LOG4PLSQL package
>=20
> Each section (or subsection) could have its own logger.
>=20
> I got this info by looking at the source code for ReaderLogDataBase.sqlj
> but I've not experienced it myself.
> Can somebody confirm this?
>=20
> Luc
>=20
>=20
>=20
> log...@li... a =E9crit :
>=20
> > Please let me know if it is not possible using the current log4plsql
> > context.
> >
> > Thanks
> > Raja
> >
> >
> > On 8/24/05, *Raja Ram* <raj...@gm...
> > <mailto:raj...@gm...>> wrote:
> >
> > Hi,
> >
> > I am just exploring the way log4plsql is working and I want some
> > clarification.
> >
> > I have some stored procs like SP1, SP2, SP3 etc. and I have
> > implemented log4plsql there. The log is going into TLOG table and
> > finally it is going into a file called "lo4plsql.log".
> >
> > Now I want separate files for all the Stored Procedure. SO How can
> > I implement this???
> >
> > I will be really thankful to you and appreciate your time if you
> > can answer my question as soon as possible.
> >
> > Regards
> > Raja
> >
> >
> >
>=20
> --
> Luc Tanguay, ing./P. Eng.
> BELL CANADA
> PERFORMANCE ET HAUTE DISPONIBILITE/HIGH AVAILABILITY & PERFORMANCE
> 1050 BEAVER HALL, 2e ETAGE/2nd FLOOR
> MONTREAL (QUEBEC) H2Z 1S4, CANADA
> TEL: (514) 786-6440
> CEL: (514) 229-7585
>=20
>=20
>=20
>

Raja,

it may be possible to use section names with different log4j loggers.  
For example, if you define the section named "firstSection", the 
log4j.properties could have a line like:

log4j.logger.log4plsql.PIPENAME.USERNAME.firstSection=DEBUG, myAppender

where
PIPENAME is the name of the Oracle pipe (default is LOG_PIPE)
USERNAME is the Oracle user using the LOG4PLSQL package

Each section (or subsection) could have its own logger.

I got this info by looking at the source code for ReaderLogDataBase.sqlj 
but I've not experienced it myself.
Can somebody confirm this?

Luc



log...@li... a écrit :

> Please let me know if it is not possible using the current log4plsql 
> context.
>  
> Thanks
> Raja
>
>  
> On 8/24/05, *Raja Ram* <raj...@gm... 
> <mailto:raj...@gm...>> wrote:
>
>     Hi,
>      
>     I am just exploring the way log4plsql is working and I want some
>     clarification.
>      
>     I have some stored procs like SP1, SP2, SP3 etc. and I have
>     implemented log4plsql there. The log is going into TLOG table and
>     finally it is going into a file called "lo4plsql.log".
>      
>     Now I want separate files for all the Stored Procedure. SO How can
>     I implement this???
>      
>     I will be really thankful to you and appreciate your time if you
>     can answer my question as soon as possible.
>      
>     Regards
>     Raja
>      
>
>

-- 
Luc Tanguay, ing./P. Eng.
BELL CANADA
PERFORMANCE ET HAUTE DISPONIBILITE/HIGH AVAILABILITY & PERFORMANCE
1050 BEAVER HALL, 2e ETAGE/2nd FLOOR
MONTREAL (QUEBEC) H2Z 1S4, CANADA
TEL: (514) 786-6440
CEL: (514) 229-7585

If you are using the Log4Plsql Java background process to process log
statements with Log4J, then just configure each package to use a
different context name, which will translate to a Log4J Logger name.=20
Each logger can have it's own FileAppender configuration to write to a
different file.


On 24/08/05, log...@li...
<log...@li...> wrote:
> Please let me know if it is not possible using the current log4plsql
> context.=20
>  =20
> Thanks=20
> Raja
>=20
> =20
> =20
> On 8/24/05, Raja Ram <raj...@gm...> wrote:=20
> >=20
> > Hi,=20
> >  =20
> > I am just exploring the way log4plsql is working and I want some
> clarification.=20
> >  =20
> > I have some stored procs like SP1, SP2, SP3 etc. and I have implemented
> log4plsql there. The log is going into TLOG table and finally it is going
> into a file called "lo4plsql.log".=20
> >  =20
> > Now I want separate files for all the Stored Procedure. SO How can I
> implement this???=20
> >  =20
> > I will be really thankful to you and appreciate your time if you can
> answer my question as soon as possible.=20
> >  =20
> > Regards=20
> > Raja=20
> > =20
>=20
>