Hello everybody, 
Sorry if it is a little off topic, since Chainsaw - SQLServer
interaction is not directly connected to log4net.
But I hope that you in this list have the most experiences with this
topic.
 
I wanted to read my db logs with Chainsaw, so i configured a
chainsaw.config
 
<?xml version="1.0" encoding="UTF-8" ?>
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/";
debug="false">
 
 <plugin name="DBReceiver1" class="org.apache.log4j.db.DBReceiver">
    <param name="sql" value="SELECT [ID],
[Date],[Thread],[Level],[Logger],[Message] FROM Log"/>
       <connectionSource
class="org.apache.log4j.db.DriverManagerConnectionSource">
        <param name="password" value="<mypass>"/>
        <param name="user" value="<myuser>"/>
        <param name="driverClass"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
        <param name="url"
value="jdbc:microsoft:sqlserver://<myserver>:<myport>;DatabaseName=GPD-Q
SS"/>
   </connectionSource>
   <param name="IDField" value="ID"/>
      <param name="refreshMillis" value="3000"/>
  </plugin>
 
    <root>
      <level value="debug"/>
   </root>
 
</log4j:configuration>
 
I also downloaded the "SQL Server 2000 Driver for JDBC Service Pack 3"
form Microsoft and installed it on my desktop machine. (It should put
the JDBC Jars in the right place, not?)
 
Now in the Chainsaw Log i find

Failed to locate Receiver class:org.apache.log4j.db.CustomSQLDBReceiver 

No Reciever appears in the right pane.
Where can i get CustomSQLDBReceiver, where do i put em? I use Chainsaw
from webstart.
 
Do i miss some thing???
 
Thank you
 
 
 
 
 
 
 

Reply via email to