[log4plsql] Trans.: Fwd: RE: Problem using Log4j feature.

log4plsql general mailing list Mon, 12 Mar 2007 01:54:01 -0800

FYA


Note: forwarded message attached.

Note: forwarded message attached.

--- Begin Message ---

Hi
  I am evaluating log4plsql for my project.
  I am able to install the package in DB (PLOB, PLOGPARAM, PMDC). 
  But i am getting same problem. DBMS_PIPE.receive_message:1" message seems to 
mean that the listener process finds no message in the pipe. 
   
  I am not getting the logged messages when i run 
startLog4JbackgroundProcess.bat
  I have not change any other file from package. 
  I tried Log4plsqlV313, Log4plsqlV3132 versions.
   
  Please help. 
  log4plsql.xml
=============
<?xml version="1.0" encoding="UTF-8" ?>
<!--
 | This is the log4plsql Pages configuration file
 |
 | guillaume Moulard  6-may-2002 Creation
 | guillaume Moulard  24-April-2002 adaptation for log4plsql2.2 
 | guillaume Moulard  29-JAN-2003 adaptation for log4plsql3.1.1
 |                                - Multi dbms_pipe
 |                                - Multi user/database by backgroundProcess
 +-->
  <log4plsql>
    <log4jParameterUseBybackgroundProcess>
            <typeConfigurator confType="PropertyConfigurator" />
            <fileName name=".\\properties\\log4j.properties" />
    </log4jParameterUseBybackgroundProcess>
      <!-- 
     |  Log4plsql start one java thread by source
     +-->
    <logSource name="logSource1">
         <!-- log4j configuration part
          |   see : http://jakarta.apache.org/log4j for general information
          +-->
        <log4j>
             <!-- typeConfigurator reference to log4j Configurator type 
              |   Currently possible is : DOMConfigurator, 
PropertyConfigurator, BasicConfigurator
              +-->            
            <typeConfigurator confType="PropertyConfigurator" />
            <fileName name=".\\properties\\log4j.properties" />
        </log4j>
        <database>
            <source>
                <connection>
                   <!-- Database connection where log4plsql ase install.
                    |   see : JDBC Developer's Guide and Reference / Verifying 
a JDBC Client Installation
                    |         for all installation Oracle driver install
                    +-->
                  <username>testloguser2</username>
                  <password>password</password>
                   <!-- jdbc:oracle:thin:@<host_name>:<port_number>:<sid>  -->
                  <dburl>jdbc:oracle:thin:@127.0.0.1:1521:testlog2</dburl>
                </connection>
                   <!-- the default value of pipename is LOG_PIPE 
                    +-->
                <pipename>DBMS_PIPE</pipename>
            </source>
        </database>
  <paramAction>
         <action name="deleteInDatabase" value="Y" />
  </paramAction>
      </logSource>
</log4plsql>
  ======================
My properties file
  log4j.properties
=================
log4j.rootLogger=, A1, A2
  log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.threshold=WARN
log4j.appender.A1.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x 
- %m%n
  log4j.appender.A2=org.apache.log4j.FileAppender
log4j.appender.A2.File=.\\log\\log4plsql_${THRESHOLD_LEVEL}.log
log4j.appender.A2.Append=false
log4j.appender.A2.Threshold=${THRESHOLD_LEVEL}
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=%d %-5p (%c) - %m [%x]%n
  log4j.logger.backgroundProcess=INFO
log4j.logger.log4plsql=ALL

--- End Message ---

Hi
  I am evaluating log4plsql for my project.
  I am able to install the package in DB (PLOB, PLOGPARAM, PMDC). 
  But i am getting same problem. DBMS_PIPE.receive_message:1" message seems to 
mean that the listener process finds no message in the pipe. 
   
  I am not getting the logged messages when i run 
startLog4JbackgroundProcess.bat
  I have not change any other file from package. 
  I tried Log4plsqlV313, Log4plsqlV3132 versions.
   
  Please help. 
  log4plsql.xml
=============
<?xml version="1.0" encoding="UTF-8" ?>
<!--
 | This is the log4plsql Pages configuration file
 |
 | guillaume Moulard  6-may-2002 Creation
 | guillaume Moulard  24-April-2002 adaptation for log4plsql2.2 
 | guillaume Moulard  29-JAN-2003 adaptation for log4plsql3.1.1
 |                                - Multi dbms_pipe
 |                                - Multi user/database by backgroundProcess
 +-->
  <log4plsql>
    <log4jParameterUseBybackgroundProcess>
            <typeConfigurator confType="PropertyConfigurator" />
            <fileName name=".\\properties\\log4j.properties" />
    </log4jParameterUseBybackgroundProcess>
      <!-- 
     |  Log4plsql start one java thread by source
     +-->
    <logSource name="logSource1">
         <!-- log4j configuration part
          |   see : http://jakarta.apache.org/log4j for general information
          +-->
        <log4j>
             <!-- typeConfigurator reference to log4j Configurator type 
              |   Currently possible is : DOMConfigurator, 
PropertyConfigurator, BasicConfigurator
              +-->            
            <typeConfigurator confType="PropertyConfigurator" />
            <fileName name=".\\properties\\log4j.properties" />
        </log4j>
        <database>
            <source>
                <connection>
                   <!-- Database connection where log4plsql ase install.
                    |   see : JDBC Developer's Guide and Reference / Verifying 
a JDBC Client Installation
                    |         for all installation Oracle driver install
                    +-->
                  <username>testloguser2</username>
                  <password>password</password>
                   <!-- jdbc:oracle:thin:@<host_name>:<port_number>:<sid>  -->
                  <dburl>jdbc:oracle:thin:@127.0.0.1:1521:testlog2</dburl>
                </connection>
                   <!-- the default value of pipename is LOG_PIPE 
                    +-->
                <pipename>DBMS_PIPE</pipename>
            </source>
        </database>
  <paramAction>
         <action name="deleteInDatabase" value="Y" />
  </paramAction>
      </logSource>
</log4plsql>
  ======================
My properties file
  log4j.properties
=================
log4j.rootLogger=, A1, A2
  log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.threshold=WARN
log4j.appender.A1.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x 
- %m%n
  log4j.appender.A2=org.apache.log4j.FileAppender
log4j.appender.A2.File=.\\log\\log4plsql_${THRESHOLD_LEVEL}.log
log4j.appender.A2.Append=false
log4j.appender.A2.Threshold=${THRESHOLD_LEVEL}
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=%d %-5p (%c) - %m [%x]%n
  log4j.logger.backgroundProcess=INFO
log4j.logger.log4plsql=ALL

I am evaluating log4plsql for my project.

I am able to install the package in DB (PLOB, PLOGPARAM, PMDC).

But i am getting same problem. DBMS_PIPE.receive_message:1" message seems to mean that the listener process finds no message in the pipe.

I am not getting the logged messages when i run startLog4JbackgroundProcess.bat

I have not change any other file from package.

I tried Log4plsqlV313, Log4plsqlV3132 versions.

Please help.

log4plsql.xml
=============
<?xml version="1.0" encoding="UTF-8" ?>

<logSource name="logSource1">
         
        <log4j>
             
            <typeConfigurator confType="PropertyConfigurator" />
            <fileName name=".\\properties\\log4j.properties" />
        </log4j>
        <database>
            <source>
                <connection>
                   
                  <username>testloguser2</username>
                  <password>password</password>
                   
                  <dburl>jdbc:oracle:thin:@127.0.0.1:1521:testlog2</dburl>
                </connection>
                   
                <pipename>DBMS_PIPE</pipename>
            </source>
        </database>
  <paramAction>
         <action name="deleteInDatabase" value="Y" />
  </paramAction>

</logSource>
</log4plsql>

======================
My properties file

log4j.properties
=================
log4j.rootLogger=, A1, A2

log4j.appender.A1=org.apache.log4j.ConsoleAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.threshold=WARN
log4j.appender.A1.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n

log4j.appender.A2=org.apache.log4j.FileAppender
log4j.appender.A2.File=.\\log\\log4plsql_${THRESHOLD_LEVEL}.log
log4j.appender.A2.Append=false
log4j.appender.A2.Threshold=${THRESHOLD_LEVEL}
log4j.appender.A2.layout=org.apache.log4j.PatternLayout
log4j.appender.A2.layout.ConversionPattern=%d %-5p (%c) - %m [%x]%n

log4j.logger.backgroundProcess=INFO
log4j.logger.log4plsql=ALL

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Log4plsql-all-info mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/log4plsql-all-info
log4plsq : http://log4plsql.sourceforge.net

[log4plsql] Trans.: Fwd: RE: Problem using Log4j feature.

Reply via email to