[log4plsql] Problem using Log4j feature.

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

Hi all,

I try to use the log4j feature with log4plsql.

Unfortunetly, the listener process seems not to receive messages from =
the DBMS_PIPE.

Here is a fragment of the listener's ouput :=20

-------------------------------------------------------------------------=
--
2005-05-10 17:29:03,382 INFO  [main] backgroundProcess.Run (Run.java:62) =
- start   log4plsql.properties: ./properties/log4plsql.xml               =
                  2005-05-10 17:29:03,388 DEBUG [main] =
backgroundProcess.Run (Run.java:63) - log4j  .properties : =
/ulis/users/ulisu9/Log4plsql/properties/log4j.xml                   =
2005-05-10 17:29:03,430 DEBUG [main] backgroundProcess.ReaderThread =
(ReaderThrea  d.java:40) - ReaderLogDataBase : Connect                   =
                       2005-05-10 17:29:03,461 DEBUG [main] =
backgroundProcess.ReaderLogDataBase (Reader  LogDataBase.sqlj:78) - =
Start logSource:source1 dbURI:jdbc:oracle:thin:@127.0.0.1  :1542:PRODU9 =
dbUser:ulog dbPass:ulog pipeName:LOG_PIPE                            =
2005-05-10 17:29:04,207 INFO  [main] backgroundProcess.ReaderLogDataBase =
(Reader  LogDataBase.sqlj:85) - Startup logSource:source1 =
dbURI:jdbc:oracle:thin:@127.0.0  .1:1542:PRODU9 dbUser:ulog dbPass:ulog =
pipeName:LOG_PIPE                          2005-05-10 17:29:04,355 DEBUG =
[main] backgroundProcess.DynamicLevel (DynamicLeve  l.java:34) - Level =
Creation name:OFF level:99999 syslogEquiv:10                  =20

.....

 2005-05-10 17:29:48,999 DEBUG [Thread-1] =
backgroundProcess.ReaderLogDataBase (Re aderLogDataBase.sqlj:147) - =
Start Log4j Backgroung fetching                      2005-05-10 =
17:29:49,002 DEBUG [Thread-1] backgroundProcess.ReaderLogDataBase (Re =
aderLogDataBase.sqlj:169) - DBMS_PIPE.receive_message:1                  =
        2005-05-10 17:29:49,003 DEBUG [Thread-1] =
backgroundProcess.ReaderLogDataBase (Re aderLogDataBase.sqlj:210) - Nbr =
line read in logSource:source1 : 0              =20

---------------------------------------------------

You can see that the DBMS pipe name is the default and that's the same =
in the PLOGPARAM package.

By inserting some debug code to the PLOG.LOG procedure I noticed that it =
actually writes to the pipe (the following code is executed and ret is =
0).

        ret :=3D DBMS_PIPE.send_message(pCTX.DBMS_PIPE_NAME);       =20
        IF RET <> 0 then
             raise_application_error(ERR_CODE_DBMS_PIPE, =
MES_CODE_DBMS_PIPE || RET);
        END IF;        =20


But the "DBMS_PIPE.receive_message:1" message seems to mean that the =
listener process finds no message in the pipe. Am I right ?

Do you know where it comes from ?