log4plsql-all-info Mailing List for LOG4PLSQL
Brought to you by:
gmoulard
You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
|
Apr
(8) |
May
(4) |
Jun
(11) |
Jul
(13) |
Aug
(2) |
Sep
(1) |
Oct
(2) |
Nov
(9) |
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(3) |
Feb
(1) |
Mar
(4) |
Apr
(1) |
May
(1) |
Jun
(5) |
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
(5) |
Dec
(6) |
2004 |
Jan
(7) |
Feb
(26) |
Mar
(8) |
Apr
(1) |
May
(5) |
Jun
(4) |
Jul
|
Aug
|
Sep
|
Oct
(5) |
Nov
(4) |
Dec
(8) |
2005 |
Jan
(2) |
Feb
|
Mar
(2) |
Apr
|
May
(10) |
Jun
(2) |
Jul
|
Aug
(5) |
Sep
|
Oct
(7) |
Nov
|
Dec
|
2006 |
Jan
|
Feb
(2) |
Mar
(4) |
Apr
(2) |
May
(2) |
Jun
|
Jul
|
Aug
(5) |
Sep
(2) |
Oct
(3) |
Nov
|
Dec
|
2007 |
Jan
|
Feb
(2) |
Mar
(3) |
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(3) |
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
(1) |
Dec
|
2009 |
Jan
(4) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
(1) |
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: log4plsql g. m. l. <log...@li...> - 2010-06-29 14:17:36
|
From: John Finlay Date: Thu, Jun 24, 2010 at 23:18 Subject: PLOG_OUT_DBMS_OUTPUT To: guillaume Guillaume, I've attached an update (actually a replacement) for the PLOG_OUT_DBMS_OUTPUT.LOG procedure. The original version indented the message text to whatever length the header (timestamp-severity-callstack) was, which made for some strange output like 14:58:12.73-FATAL-block:2->MORE.STUFF:27->EVENMORE.STUFF:128 Here is my message that wraps at 100 characters which looks kind of weird and wastes a lot of space. Big deal o n the space, but still... Unfortunately, the original code used the pCTX.DBMS_OUTPUT_WRAP value as the maximum length of the line (as it should), so if the timestamp-severity-callstack is greater than 100 characters, there's no room left for the message, and the procedure loops and throws an ORU-10027 buffer overflow error. This new version uses a constant indent (of 3 spaces), so wrapped output now looks like 14:58:12.73-FATAL-block:2->MORE.STUFF:27->EVENMORE.STUFF:128 Here is my message that wraps at 100 characters which looks much nicer and is easier to read because there is actually some length to the message line's output and at least it never explodes. John Finlay |
From: log4plsql g. m. l. <log...@li...> - 2010-06-23 08:49:50
|
Hi, Thank you very much for your update. Could you send me a output exemple for the documentation? I can introduse this update in next release. G. On Wed, Jun 23, 2010 at 03:27, wrote: > > Message body follows: > > Hello, > I have found that the getCallStack function produces poor > results when plog is called from a package. I suggest the > line number be included in the getCallStack output. I have > included the following code as an example: > > FUNCTION getCallStack RETURN VARCHAR2 IS > endOfLine CONSTANT CHAR(1) := chr(10); > endOfField CONSTANT CHAR(1) := chr(32); > myName CONSTANT VARCHAR2(2000) := '.PLOG'; > allLines VARCHAR2(4000); > v_result VARCHAR2(4000); > Line VARCHAR2(4000); > UserCode VARCHAR2(4000); > lineNumber VARCHAR2(20); > arrow varchar2(2); > startPtr number; > endPtr number; > BEGIN > allLines := dbms_utility.format_call_stack; > startPtr := 83; > LOOP > endPtr := INSTR(allLines, endOfLine, startPtr); > exit when endPtr = 0; > > Line := SUBSTR(allLines, startPtr, endPtr - startPtr); > UserCode := SUBSTR(Line, INSTR (Line, endOfField, -1) > + 1); > > if INSTR(UserCode, myName) = 0 THEN > startPtr := instr(Line, endOfField); > lineNumber := LTRIM(substr(line, startPtr, > instr(line, endOfField, startPtr+1, 1))); > v_result := UserCode || ':' || lineNumber || > arrow || v_result; > arrow := '->'; > END IF; > > startPtr := endPtr + 1; > END LOOP; > RETURN v_result; > END getCallStack; > > I will be using this updated version in my environment. > Please let me know if you think this update would be > beneficial to you. > > John Finlay > > > -- > 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=2964138 > > |
From: log4plsql g. m. l. <log...@li...> - 2010-04-13 16:45:37
|
Nitin, Infrastructure is not a problem. I have start this project this is 9 year ago and there is only 2 update make by on other of me. I'm very open but at moment, I use for log4plsql only one version by one dev. The current update protocol is very basic : 1. You explain the new feature to the mailing list. 2. We agree this new feature 3. You descibe your dev. 4. We agree your technical update 5. You make the new .zip version with code, test and doc 6. I put this new version in beta 7. If there is no bug, we put it in production status. Guillaume On Tue, Apr 13, 2010 at 17:28, Nitin Malik <************> wrote: > Nitin |
From: log4plsql g. m. l. <log...@li...> - 2010-04-09 09:11:08
|
Nitin, I'm sorry we don't user a CVS/SVN because there are too may change. Could you send me your update? have you update the documentation to? Many thank to share you work. G. On Fri, Apr 9, 2010 at 02:30, log4plsql general mailing list < log...@li...> wrote: > Nitin |
From: log4plsql g. m. l. <log...@li...> - 2010-04-09 00:30:53
|
Hi Guillaume, I am currently using log4plsql in my database. I would like to commit a new feature to change log level at database level without compiling the package. This feature will be useful for Oracle 9i, 10g users till they can compile packages in production without downtime using editions based redefinition. Please guide me for CVS/SVN access. Cheers Nitin Malik |
From: log4plsql g. m. l. <log...@li...> - 2009-10-02 21:14:28
|
Hi Mark, Only SID will not help in case of connection pooling with Java application servers. We need a mechanism to 1) Log a unique identificaiton per jdbc call. This can be a random number generated / Starting timestamp in Log4PLSQL context for that call. 2) Currently I am loggin following into TLOG.LTEXTE but it is still not helpful as the same identifier is repeated in case the same connection is reused by application server. I am using userenv('sessionid')||' : '||pLTEXTE We use the same technique in Java logging to create a unique identifier per server call. I am planning to add that identified in session and add that to log messages instead of SID. Please comment if such a feature will be useful for anyone else using this project. Regards Nitin log4plsql-all-info mailing list wrote: > > When looking through my TLOG file, messages logged from many different > sessions are interleaved. It would be useful to be able to filter a view > by the SID from which the messages were generated. I feel that this > would best be handled by adding a new column to the TLOG table and > enhancing the code to automatically populate this column when inserting > a row. > > > > ______________________________________________________ > > Mark Freeman | Data Architect | Click4Care, Inc. > > 50 South Liberty Street | Suite 200 | Powell, OH 43065 > > Email: mfr...@cl... <http://www.click4care.com> > > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9-12, 2009. Register > now! > http://p.sf.net/sfu/devconf > _______________________________________________ > Log4plsql-all-info mailing list > Log...@li... > https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info > log4plsq : http://log4plsql.sourceforge.net > > -- View this message in context: http://www.nabble.com/Enhancement-suggestion%3A-log-the-SID-tp25695283p25722070.html Sent from the log4plsql-all-info mailing list archive at Nabble.com. |
From: log4plsql g. m. l. <log...@li...> - 2009-09-30 18:51:29
|
When looking through my TLOG file, messages logged from many different sessions are interleaved. It would be useful to be able to filter a view by the SID from which the messages were generated. I feel that this would best be handled by adding a new column to the TLOG table and enhancing the code to automatically populate this column when inserting a row. ______________________________________________________ Mark Freeman | Data Architect | Click4Care, Inc. 50 South Liberty Street | Suite 200 | Powell, OH 43065 Email: mfr...@cl... <http://www.click4care.com> |
From: log4plsql g. m. l. <log...@li...> - 2009-02-24 23:12:40
|
Hi, Look the big working make by Zoly with log4plsq. Wath you think about the Maven integration? Guillaume ---------- Forwarded message ---------- From: Zoltan Farkas <zo...@da...> Date: Tue, Feb 17, 2009 at 5:12 PM Subject: RE: [log4plsql - Open Discussion] Code contribution - log to arbitrary file To: gui...@mo... I have finalized my contributions and commited everything to cvs. I have also integrated the whole documentation/site generation to be easily be generated with: mvn site and deployed with: mvn site:deploy you can see what the site looks like: http://www.zoltran.com/log4plsql let me know what you think or if you have any questions… regards --zoly ------------------------------ *From:* gmo...@gm... [mailto:gmo...@gm...] *On Behalf Of *Guillaume Moulard *Sent:* Tuesday, February 03, 2009 1:05 PM *To:* Zoltan Farkas *Subject:* Re: [log4plsql - Open Discussion] Code contribution - log to arbitrary file Zoly, The log4plsql.tpl file is necessary to use log4plsql ion TOra : http://tora.sourceforge.net/ Guillaume On Tue, Feb 3, 2009 at 6:33 PM, Zoltan Farkas <zo...@da...> wrote: Thanks One more question: There is a file with the tpl extension in the source tree, do you have any idea of what it does? Looks like it contains some documentation…. I will look into maybe converting the user guide to something open like the docbook format, or open document, so that I can automate the publishing to html or pdf … But this is not critical the code can be easily integrated into the project site. My goal is to generate everything with maven and assemble it automatically. It makes the project a lot easier to maintain. I will proceed sometime in the next days with the code commit. (with an improved version of what you saw) --zoly ------------------------------ *From:* gmo...@gm... [mailto:gmo...@gm...] *On Behalf Of *Guillaume Moulard *Sent:* Tuesday, February 03, 2009 12:09 PM *To:* Zoltan Farkas *Subject:* Re: [log4plsql - Open Discussion] Code contribution - log to arbitrary file hi, We edit direcly UserGuide.html by word. Guillaume On Mon, Feb 2, 2009 at 11:59 PM, Zoltan Farkas <zo...@da...> wrote: Where is the source doc file? I did not find it in the repository. thanks --zoly ------------------------------ *From:* Guillaume Moulard [mailto:gui...@mo...] *Sent:* Monday, February 02, 2009 1:10 PM *To:* Zoltan Farkas *Subject:* RE: [log4plsql - Open Discussion] Code contribution - log to arbitrary file Hi, We use microsoft word for generate the doc. G ------------------------------ *De: *Zoltan Farkas <zo...@da...> *Env: *lundi 2 février 2009 18:17 *À: *Guillaume Moulard <gui...@mo...> *Objet: *RE: [log4plsql - Open Discussion] Code contribution - log to arbitrary file Hi guillaume, I have restructured a little bit the project to be more like other maven projects. The folder src contains all source files (java, sql, sqlj scripts, config files) Here is what the folders contain: assemble – contains xml files that will create the distribution files, one of them creates a whole install zip, and the other one creates a distribution that contains only the sql files. cmd – contains the install/run scripts, I have improved the unix scripts to be easier to use, the windows scripts need some work due to the changes contribs – have no clue what it contains, left it iuntouched. docs – user documentation, unchanged java – the java sources, with minor code changes. (no functionality changes) properties – contains the config files. sql – contains the sql code, I have added the log 2 file support. sqlj – contains the sqlj code, that is used by the sqlj plugin to generate the java code, the generated code is created in target/generated-sources. tpl - contains the tpl file, have no clue wht file is this J the test folder contains all the files used for testing purposes. I have one question about the documentation, is it generated? what tool did you use? regards --zoly ------------------------------ *From:* Guillaume Moulard [mailto:gui...@mo...] *Sent:* Monday, February 02, 2009 9:03 AM *To:* Zoltan Farkas *Subject:* RE: [log4plsql - Open Discussion] Code contribution - log to arbitrary file Zoly, I have dowload open and read yours file. I dont understand your update, there is a lot of new file. Can you start to a new version (4) and perapse send me you update of the user documentation Thank for you good job guillaume ------------------------------ *De: *Zoltan Farkas <zo...@da...> *Env: *vendredi 30 janvier 2009 22:05 *À: *guillaume moulard <gui...@fr...> *Cc: *log...@li... *Objet: *RE: [log4plsql - Open Discussion] Code contribution - log to arbitrary file Hi guillaume I have finished the pldoc integration, also contributed the maven 2 projects and plugin to the pldoc sourceforge project. So you have pretty much everything buildable with maven2 and I have finished the log to arbitrary file integration. Let me know what you think You can download the result at: http://www.zoltran.com/log4plsql.tar.gz I used netbeans with the maven plugin to dev/build the project. regards --zoly ------------------------------ *From:* gmo...@gm... [mailto:gmo...@gm...] *On Behalf Of *guillaume moulard *Sent:* Friday, January 23, 2009 6:15 AM *To:* Zoltan Farkas *Cc:* log...@li... *Subject:* Re: [log4plsql - Open Discussion] Code contribution - log to arbitrary file hi Welcome to log4plsql projets ;) Whist is your sourceforge user? Do you know the log4plsql feature to log in alert.log and trace file? Guillaume On Fri, Jan 23, 2009 at 1:20 AM, SourceForge.net <no...@so...> wrote: Read and respond to this message at: https://sourceforge.net/forum/message.php?msg_id=6220742 By: nobody I would be interested in contributing some PLSQL code that does logging to arbitrary files with log file rotation/management. I know that currently it can be done via the log4j process, but it might be useful to have the option to log to a arbitrary file without the extra java process. let me know it it make sense or not, and if it makes let me know how can I proceed with it... you can email me at zoly at daxtechnologies dot com ______________________________________________________________________ You are receiving this email because you elected to monitor this forum. To stop monitoring this forum, login to SourceForge.net and visit: https://sourceforge.net/forum/unmonitor.php?forum_id=170438 |
From: log4plsql g. m. l. <log...@li...> - 2009-01-28 09:09:29
|
Hi, Someone in log4plsq community think is a new interesting feature ? Guillaume ---------- Forwarded message ---------- From: Zoltan Farkas <zo...@da...> Date: Fri, Jan 23, 2009 at 6:23 PM Subject: Re: [log4plsql - Open Discussion] Code contribution - log to arbitrary file To: guillaume moulard <gui...@fr...> I am going over the code in Log4PLSql and found some code that I think in not optimal in ReaderThread.java: public void run() { while (true) { ldbLogger.debug("ReaderLogDataBase: CallBD"); readerDB.readlog(ldbLogger); ldbLogger.debug("ReaderLogDataBase: EndCallBD"); try { sleep(1000); } catch(InterruptedException e) { ldbLogger.error(e); } } } I believe in this case the InterruptedException handler should exit the infinite loop, and since this case is not really an error the logging should be changed to info. This will allow you to stop your thread and effectively stop your java process and implement a clean SIG_TERM process termination. let me know what you think Regards --zoly guillaume moulard wrote: > hi > > Welcome to log4plsql projets ;) > > Whist is your sourceforge user? > > Do you know the log4plsql feature to log in alert.log and trace file? > > > Guillaume > > > > On Fri, Jan 23, 2009 at 1:20 AM, SourceForge.net <no...@so...<mailto: > no...@so...>> wrote: > > > Read and respond to this message at: > https://sourceforge.net/forum/message.php?msg_id=6220742 > By: nobody > > I would be interested in contributing some PLSQL code that does > logging to arbitrary > files with log file rotation/management. I know that currently it > can be done > via the log4j process, but it might be useful to have the option > to log to a > arbitrary file without the extra java process. > > let me know it it make sense or not, and if it makes let me know > how can I proceed > with it... you can email me at zoly at daxtechnologies dot com > > > > ______________________________________________________________________ > You are receiving this email because you elected to monitor this > forum. > To stop monitoring this forum, login to SourceForge.net and visit: > https://sourceforge.net/forum/unmonitor.php?forum_id=170438 > > > |
From: log4plsql g. m. l. <log...@li...> - 2009-01-23 11:14:41
|
hi Welcome to log4plsql projets ;) Whist is your sourceforge user? Do you know the log4plsql feature to log in alert.log and trace file? Guillaume On Fri, Jan 23, 2009 at 1:20 AM, SourceForge.net <no...@so...>wrote: > > Read and respond to this message at: > https://sourceforge.net/forum/message.php?msg_id=6220742 > By: nobody > > I would be interested in contributing some PLSQL code that does logging to > arbitrary > files with log file rotation/management. I know that currently it can be > done > via the log4j process, but it might be useful to have the option to log to > a > arbitrary file without the extra java process. > > let me know it it make sense or not, and if it makes let me know how can I > proceed > with it... you can email me at zoly at daxtechnologies dot com > > > > ______________________________________________________________________ > You are receiving this email because you elected to monitor this forum. > To stop monitoring this forum, login to SourceForge.net and visit: > https://sourceforge.net/forum/unmonitor.php?forum_id=170438 > |
From: log4plsql g. m. l. <log...@li...> - 2009-01-07 14:33:37
|
Guillaume On Wed, Jan 7, 2009 at 1:48 PM, < Ber...@bo...> wrote: > Hi Guillaume, > > I think Tom should create public synonyms for the package PLOGPARAM and > PLOG > > connected as sys: > > CREATE PUBLIC SYNONYM PLOGPARAM FOR PL.PLOGPARAM; > CREATE PUBLIC SYNONYM PLOG FOR PL.PLOG; > > After that your users can use theses packages in their programs. > > If you have installed the PLOG_OUT_AQ package and use it as output > (output in a queue) , you should replace the line > l_queue_name := 'LOG_QUEUE'; > with : > l_queue_name := 'PL.LOG_QUEUE'; > > (if not the users will get an exception as they do not own this > LOG_QUEUE) > > Regards > > Bertrand > > > > -----Ursprüngliche Nachricht----- > *Von:* Guillaume Moulard [mailto:gmo...@gm...] > *Gesendet:* Mittwoch, 7. Januar 2009 11:08 > *An:* Bertrand Caradec > *Betreff:* Fwd: log4plsql > > Bertrand, > > Have you some information? > > Guillaume > > > > ---------- Forwarded message ---------- > From: DBA <db...@em...> > Date: Tue, Jan 6, 2009 at 10:24 AM > Subject: Re: log4plsql > To: Guillaume Moulard <gmo...@gm...> > Cc: log...@li..., > bca...@se... > > > Hi, > > log4plsql is installed under user pl. > When i connect as user pl i am able to log all. I see in alert.log needed > information. > alert.log: > -------- > Tue Jan 06 10:11:51 2009 > PLOG:2009-01-06 10:11:51:60 user: PL level: DEBUG logid: 57 firstSection > Hello LOG > > but on the server are other users ( developers ) example martin01. When i > connect under this user and run the same test: > sqlplus: > ------- > Declare > pCTX PLOGPARAM.LOG_CTX := PLOG.init (pSECTION => 'firstSection', > pLEVEL => PLOG.LDEBUG, > pLOG4J => TRUE, > pLOGTABLE => TRUE, > pOUT_TRANS => TRUE, > pALERT => TRUE, > pTRACE => TRUE, > pDBMS_OUTPUT => TRUE ); > begin > PLOG.debug (pCTX, 'Hello LOG'); > end; > / > > I get an error: > -------------- > pCTX PLOGPARAM.LOG_CTX := PLOG.init (pSECTION => 'firstSection', > * > ERROR at line 2: > ORA-06550: line 2, column 6: > PLS-00201: identifier 'PLOGPARAM.LOG_CTX' must be declared > ORA-06550: line 2, column 6: > PL/SQL: Item ignored > ORA-06550: line 11, column 13: > PLS-00320: the declaration of the type of this expression is incomplete or > malformed > ORA-06550: line 11, column 1: > PL/SQL: Statement ignored > > QUESTION > ------------- > Which packages must be granted to all developers ( or to public user ) when > I need log all from different schema than pl. > > > Regards, > Tom > > > > > Guillaume Moulard wrote: > >> Hi, >> Have you some information? >> >> Guillaume >> On Tue, Jan 6, 2009 at 8:36 AM, DBA <> wrote: >> >> Hi Guillaume, >> >> may I have a question regarding log4plsql? >> I installed beta version 4 because we are on 11g. I did it per >> manual but now I want to use it under different user than "pl" >> Which packages I must grant to user or is there any sql script? >> >> The reason is that log4plsql is installed under user pl but we >> have 3 developers which needs to log their own procedures under >> their own schema. >> >> Thank you. >> >> Regards, >> Tom >> >> Guillaume Moulard wrote: >> >> >> >> LinkedIn >> >> *Guillaume Moulard* has sent you a message. >> >> *Date:* 12/17/2008 >> >> *Subject:* RE: log4plsql >> >> hello, >> >> Could you send me you log () please. >> >> G >> >> On 12/16/08 5:57 AM, Tomas Solar wrote: >> -------------------- >> Hi Guillaume, >> >> i would like to try your tool log4plsq but during the install >> i am getting an error. >> Could i sent you install log to check it? >> I am not developer so i am not able to found an error. >> >> tx & regards, >> Tom >> mail >> >> >> >> >> > > |
From: log4plsql g. m. l. <log...@li...> - 2009-01-06 08:48:36
|
Hi, Have you some information? Guillaume On Tue, Jan 6, 2009 at 8:36 AM, DBA <> wrote: > Hi Guillaume, > > may I have a question regarding log4plsql? > I installed beta version 4 because we are on 11g. I did it per manual but > now I want to use it under different user than "pl" > Which packages I must grant to user or is there any sql script? > > The reason is that log4plsql is installed under user pl but we have 3 > developers which needs to log their own procedures under their own schema. > > Thank you. > Regards, > Tom > > Guillaume Moulard wrote: > >> >> >> LinkedIn >> >> *Guillaume Moulard* has sent you a message. >> >> *Date:* 12/17/2008 >> >> *Subject:* RE: log4plsql >> >> hello, >> >> Could you send me you log () please. >> >> G >> >> On 12/16/08 5:57 AM, Tomas Solar wrote: >> -------------------- >> Hi Guillaume, >> >> i would like to try your tool log4plsq but during the install i am getting >> an error. >> Could i sent you install log to check it? >> I am not developer so i am not able to found an error. >> >> tx & regards, >> Tom >> mail >> >> >> > > |
From: log4plsql g. m. l. <log...@li...> - 2008-11-13 11:42:59
|
Hi, All Is there some kind of source repository for log4plsql. I tried to use CVS that is hosted by sourceforge but it seems to contain previous release of log4plsql. Is there something more actual ? What do you think about SVN ? Now SourceForge provides SVN hosting so it is possible to create SVN source repository -- Regards, Andre Koval |
From: log4plsql g. m. l. <log...@li...> - 2008-09-30 13:32:16
|
hello, It's the first time to write in this mailing list; I inform you that my English it's not good. I am looking for a good documentation about the best practices of using a framework of logging (Context PL/SQL) like LOG4PLSQL. I need this document to write document of architecture for a client. Thanks Hicham _________________________________________________________________ Appelez vos amis de PC à PC -- C'EST GRATUIT http://get.live.com/messenger/overview |
From: log4plsql g. m. l. <log...@li...> - 2007-08-21 14:42:44
|
Hi, I Will close the log4plsql mailing list. There is no message and to many spam. if you need some help you can contact directly the log4plsq projet manager (me :D) Guillaume |
From: log4plsql g. m. l. <log...@li...> - 2007-07-10 12:36:26
|
Hi, I've been looking at the internals of log4plsql to determine whether I can use some of the functionality in my own logging framework. In particular I've been looking at the context mechanism. First off I should explain that I'm actually a Java developer, so my question could well be the result of my crude understanding of plsql, but here goes anyway! Basically, each procedure maintains it's context information across many procedure calls. For example: create or replace package body test_logging IS pCTX PLOG.LOG_CTX := PLOG.init ('initApplication'); PROCEDURE test_1 IS BEGIN plog.setBeginSection(pCTX, 'test_1_section'); dbms_output.put_line('1 ' || pCTX.LSECTION); --output 1 test_2; dbms_output.put_line('2 ' || pCTX.LSECTION); --output 2 plog.setEndSection(pCTX, 'test_1_section'); END; PROCEDURE test_2 IS BEGIN plog.setBeginSection(pCTX, 'test_2_section'); --do some logging plog.setEndSection(pCTX, 'test_2_section'); END; END; >From this example both output 1 and output 2 are initApplication.test_1_section, which is what I would expect. My query is about how this is achieved. Looking at the mechanism, it seems that this is achieved with the use of pass by value semantics. But, looking at the context configuration methods, such as setBeginSection and setEndSection, these methods specify the NOCOPY parameter mode hint on the context parameter in an attempt to enforce pass by reference semantics on the context. This confused me. The behaviour I was seeing seemed to be the result of passing the context by value. Then I read that under certain circumstances the compiler may decide to silently ignore the NOCOPY hint, one of these being when the actual and formal parameters are record structures, which the config is. So, my questions are these, is the context mechanism meant to work through the use of pass by value semantics? If so, why does the context param defined with the NOCOPY parameter mode hint? And if not, how does the context mechanism work??? Cheers, Tony _________________________________________________________________ The next generation of Hotmail is here! http://www.newhotmail.co.uk |
From: log4plsql g. m. l. <log...@li...> - 2007-03-30 06:33:03
|
Hi I want to know if it is possible to use NDC / MDC feature while logging messages through Log4PLSQL. So that the java background process picks up the context and appropriately prints in the log file. Regards Akash Important : Any comments or statements made in this email are not necessarily those of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity group companies. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. if you have received this in error, please contact the sender and delete the material from any computer. All e-mails sent from or to Fidelity Business Services India Pvt. Ltd. may be subject to our monitoring procedures. |
From: log4plsql g. m. l. <log...@li...> - 2007-03-20 13:33:20
|
Hi, I am very happy to find your project. I am connected to a big project where the main business logic is implemented in plsql. Unfortunately, I am not capable to understand the useful part of code without working, because you know old system with a couple years after some change requests and some people changes, I just based only on the working code to filter the nonworking and unnecessary parts. So, I think your product would be the proper component to make logging. I analysed your code, and I have a question: I think, the performance of a logger is critical, because this can decrease the processing speed. So as I am using the log4j, I want to use the isLevelEnabled to minimize the overhead. I think this method could contain only an IF. This would be the maximum extra processing time. Although I see: isLevelEnabled: - getDefaultContext (expensive) - calleurname (expensive) - init (cheap) - getLevel (cheap) - IF So you can see, before the IF there are extra overhead. Why? I think, we need to make default context only once, when the session is started. However, we can solve to manage separately the section or calculate this on demand. So sum up, I would be happy if the isLevelEnabled method is primitive step, so it just contains a simple IF. What do you think? Thanks! -- Andor |
From: log4plsql g. m. l. <log...@li...> - 2007-03-12 09:53:40
|
FYA |
From: log4plsql g. m. l. <log...@li...> - 2007-02-27 14:56:56
|
Hi there, I'm trying Log4PLSQL and I want to manage the log level outside my applicat= ion. Just like for Log4J, but without passing an connection object or whatever. I want to change the log level at runtime from, for example from the backgr= ound process. Is it possible or will it be possible? Use case is, in production environment, if I want to activate the debug mod= e, I have to recompile the PLOGPARAM package, but I can't do that in produc= tion. Or I have to use the 2 arguments versions of the logging procedure. That me= ans that I have to add to all my procedures and functions a parameter with = type LOG_CTX. And it's not a good solution too. I want the log level change be independent of my developpment. Is it possible with the actual version of Log4PLSQL? Thanks in advance for your help, Regards, Olivier. ______________________________________ Olivier STRYPSTEIN > DEXIA Banque Internationale =E0 Luxembourg > Architecture & Software Quality >=20 > * 5-7 Rue des Primeurs > L-8035 Strassen > SBC+001 > * +352 4590 9723=20 fax +352 4590 6749 mobile +32 475365289 oli...@de... ______________________________________ > Plan d'acc=E8s: http://www.viamichelin.fr/viamichelin/fra/dyn/controller/= mapPerformPage?expressMap=3Dfalse&act=3D&pim=3Dtrue&strAddress=3DRue+Des+Pr= imeurs&strCP=3D&strLocation=3DStrassen&strCountry=3D247&productId=3D&x=3D21= &y=3D9 >=20 >=20 --------------------- An electronic message is not binding on its sender. Any message referring to a binding engagement must be confirmed in writing = and duly signed. --------------------- |
From: log4plsql g. m. l. <log...@li...> - 2007-02-23 10:40:12
|
Hi, I would like to use Log4PLSQL and to be able to change the logging level at Runtime without having to change any code etc. Is this possible? The options that are suggested seem to be: 1) Using a different context - this then change the log level for that piece of code, to change the level would require a change to the code 2) Change the constant in the PLogParam package specifications - this would invalidate existing packages before they picked up the changes, and would effectively be a code change to the PLogParam package. Many thanks, Russell |
From: log4plsql g. m. l. <log...@li...> - 2006-10-10 10:57:20
|
Hi, I want to purchase TORA software could you please guide me with contact details of concerned persons. Also I have some queries regarding TORA like weather its compatible to HP-unix. Awaiting for your positive reply. Regards, Sagar Contact: 9850336436 |
From: log4plsql g. m. l. <log...@li...> - 2006-10-03 05:45:59
|
Hi, I am having problem configuring log4j.properties, here is my file: log4j.rootLogger=DEBUG, A1 log4j.appender.A1=org.apache.log4j.ConsoleAppender log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.XYZ=org.apache.log4j.FileAppender log4j.appender.XYZ.File=/tmp/xyz.log log4j.appender.XYZ.layout=org.apache.log4j.PatternLayout log4j.logger.log4plsql=DEBUG, XYZ log4j.logger.backgroundProcess=ERROR All messages are sent to A1 and not to XYZ. Any help is greatly appreciated. -cs |
From: log4plsql g. m. l. <log...@li...> - 2006-09-28 14:55:25
|
Thanks. I misunderstood the setup. I saw the Log4jBackgroundProcess = and hoped this would separate the overhead of the file i/o from the = PL/SQL thread. We're running on an 8-way system, and PL/SQL generally = seems to sit on one CPU. Our debug logging is adding about 10% to the = processing time. In theory, if I can push the logging overhead to a = second thread, I should see about a 10% performance increase.=20 -----Original Message----- From: gui...@fr... [mailto:gui...@fr...] Sent: Thursday, September 28, 2006 10:39 AM To: Thompson, John Cc: log...@li... Subject: Re: Log4plsql Performance John, Unfortunly, we have never compare all log4plsql performance with = util_file. But in V3 for writing into file, log4plsql use util_file package. Intuitively it must be very similare Guillaume Selon "Thompson, John" > Guillaume, > > I just read your article on OTN about log4plsql. Just curious about = how the > performance of log4plsql compares to writing log information via the > util_file package. We're using util_file for debug messages, and = running > into a surprising amount of overhead. > > Thanks, > > JT > > |
From: log4plsql g. m. l. <log...@li...> - 2006-09-28 14:39:11
|
John, Unfortunly, we have never compare all log4plsql performance with util_fil= e. But in V3 for writing into file, log4plsql use util_file package. Intuitively it must be very similare Guillaume Selon "Thompson, John" > Guillaume, > > I just read your article on OTN about log4plsql. Just curious about ho= w the > performance of log4plsql compares to writing log information via the > util_file package. We're using util_file for debug messages, and runni= ng > into a surprising amount of overhead. > > Thanks, > > JT > > |