Thank you i will send my problem to the log4j list -----Urspr�ngliche Nachricht----- Von: Ron Grabowski [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 09. Juni 2005 15:10 An: Log4NET User Betreff: Re: Chainsaw - SQLServer please help
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 > > > > > > > >
