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 --- [EMAIL PROTECTED] 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 > > > > > > > >
