Re: [Tora-develop] [Log4plsql] LOG4PLSQ - TOra integration

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

What I'm thinking about implementing (And please tell me if it isn't a 
good idea). Is a listener to some of the Log4J implementations. The most 
interesting one seems to be socket or telnet. In which you take your 
tora, enter the host and your filtering and it will starting showing the 
log pretty much like the SQL Output window? The advantage being not 
needing to constantly poll a table which could probably prove tiresome 
for the server if a lot of clients are doing it.

I still haven't installed the Log4PL/SQL package yet though.

/Mauritz
Underscore AB

MOULARD Guillaume OCISI wrote:

>Mauritz, 
>
>Yes, it is very good for LOGPLSQL if you add this template to TOra.
>
>If you whant read a log inside TOra you have 2 way.
>
>1. the most easy, it is by a reading a log table (see:vlog.sql).
>
>2. it is possible to use all LOG4J capability, for the dynamique 
>   parameters (Loggers, Appenders and Layouts)
>
>
>--g
>
>
>-----Message d'origine-----
>De : log...@li...
>[mailto:log...@li...]
>Envoye : lundi 29 juillet 2002 10:43
>A : MOULARD Guillaume 
>Cc : tor...@li...;
>Log...@li...
>Objet : Re: [Tora-develop] [Log4plsql] LOG4PLSQ - TOra integration
>
>
>This looks interesting. For really good integration you still need to be 
>able to look at the log from inside TOra which you still can't, but I'll 
>try to add that as soon as I can (Hopefully before 1.4). Can I add this 
>template to TOra?
>
>/Mauritz
>Underscore AB
>
>MOULARD Guillaume wrote:
>
>  
>
>>Hi,
>>
>>My log4plsql.tpl run with TOra.
>>
>>I am not on to have put the information in the check place
>>
>>Are all informations/doc is in end function or is possible
>>to add a doc in node place?
>>
>>In everything the cases, The integration has a big value added.
>>
>>--g
>>
>>
>>    
>>
>_______________________________________________
>Log4plsql-all-info mailing list
>Log...@li...
>https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
>log4plsq : http://log4plsql.sourceforge.net
>
>-------------------------------------------------------------------
>--
>--  Nom script         : TLOG
>--
>--  Objectif           : Generic tool of log in a Oracle database 
>--                       same prototype and functionality that log4j.  
>--                       http://jakarta.apache.org/log4j
>-------------------------------------------------------------------
>--
>-- History : who                 created     comment
>--     V0    Guillaume Moulard   18-AVR-02   Creation
>--                                     
>--
>-------------------------------------------------------------------
>/*
> * Copyright (C) LOG4PLSQL project team. All rights reserved.
> *
> * This software is published under the terms of the The LOG4PLSQL 
> * Software License, a copy of which has been included with this
> * distribution in the LICENSE.txt file.  
> * see: <http://log4plsql.sourceforge.net>  */
> 
> 
> 
>create or replace  view VLOG as 
>select '['||to_char(LDATE, 'DD/MM HH24:MI:SS')||':'||to_char(mod(LHSECS,100),'09')||']'||
>       '['||decode(llevel, 1,'OFF    ',
>                          2,'FATAL  ',
>                          3,'ERROR  ',
>                          4,'WARNING',
>                          5,'INFO   ',
>                          6,'DEBUG  ',
>                          7,'ALL' ,
>                          'UNDEFINED')||']['||
>       LUSER||']['||
>       LSECTION||']['||
>       LTEXTE||']' log
>from (select * from tlog where rownum < 25 order by id desc) 
>order by ID
>/
>
>
>
>
>-------------------------------------------------------------------
>-- End of document
>-------------------------------------------------------------------
>
>  
>