Chainsaw - SQLServer please help

[Ro...@inhouse.wko.at]

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
 
 
 
 
 
 
 

Re: Chainsaw - SQLServer please help

[Ron Grabowski <ro...@yahoo.com>]

Have you verified that com.microsoft.jdbc.sqlserver.SQLServerDriver is
in your class path? Scott Deboy on the log4j list is the Chainsaw guru.
Here is one of his example reciever files for SQL Server:

http://tinyurl.com/99uf5
http://www.mail-archive.com/log4j-user%40logging.apache.org/msg03466.html

--- Roland.Kofler@inhouse.wko.at wrote:

> 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
>  
>  
>  
>  
>  
>  
>  
>