Wow, that's really weird. I'm using recently downloaded chainsaw-bundle (2.0alpha according to 'About') on Java 1.4.2. In trying your example, I'm getting the same warn/errors in the chainsaw console as previously mentioned:
======================================== 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [sql] in org.apache.log4j.Hierarchy. log4j:INFO Returning existing logger [org.apache.log4j.joran.spi.Interpreter] in repository [default]. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [password] in org.apache.log4j.Hierarchy. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [user] in org.apache.log4j.Hierarchy. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [driverClass] in org.apache.log4j.Hierarc hy. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [url] in org.apache.log4j.Hierarchy. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [IDField] in org.apache.log4j.Hierarchy. 3578 [Thread-7] WARN org.apache.log4j.config.PropertySetter - No such property [refreshMillis] in org.apache.log4j.Hiera rchy. ====================================== I did try the ant -f install-chainsaw.xml installer, but that failed as there actually wasn't an ant task for 'chainsaw' with that download. Maybe I'm testing with the wrong version? -D > -----Original Message----- > From: Scott Deboy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 20, 2005 4:24 PM > To: Log4J Users List > Subject: RE: Chainsaw V2 config file for DBAppender > > I haven't used UrlConnectionSource, but I use > DriverManagerConnectionSource with CustomSQLDBReceiver. > > Here's my receiver config. You may want to try copying this > example's connectionsource section into your config & > changing the appropriate info. > > <plugin name="MyDBReceiver" > class="org.apache.log4j.db.CustomSQLDBReceiver"> > <param name="sql" value="SELECT logger AS 'LOGGER', > event_time AS 'TIMESTAMP', log_level AS 'LEVEL', thread AS > 'THREAD', message AS 'MESSAGE', '' AS 'NDC', '' AS 'MDC', > 'class_name' AS 'CLASS', method AS 'METHOD', file_name AS > 'FILE', line AS 'LINE', '{{application,' + app_name + > ',hostname,' + machine_name + ',log4jid,' + CAST(counter AS > varchar(255)) + '}}' AS 'PROPERTIES', '' AS 'EXCEPTION' FROM > log_event"/> > <connectionSource > class="org.apache.log4j.db.DriverManagerConnectionSource"> > <param name="password" value="XXXXX"/> > <param name="user" value="YYYYY"/> > <param name="driverClass" > value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> > <param name="url" > value="jdbc:microsoft:sqlserver://ZZZZZ:1433;DatabaseName=AAAAAA"/> > </connectionSource> > <param name="IDField" value="counter"/> > <param name="refreshMillis" value="3000"/> > </plugin> > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
