Hi all, I have a problem using p6spy with Tomcat 4.1 and Oracle9i. I have declared a datasource in the server.xml file where I've replaced "oracle.jdbc.OracleDriver" by "com.p6spy.engine.spy.P6SpyDriver". But here is the problem : The spy.log file is telling nothing but "No value in environment for...". What's happening please ?
My spy.properties : # oracle driver realdriver=oracle.jdbc.OracleDriver #specifies the appender to use for logging #appender=com.p6spy.engine.logging.appender.Log4jLogger #appender=com.p6spy.engine.logging.appender.StdoutLogger appender=com.p6spy.engine.logging.appender.FileLogger # name of logfile to use, note Windows users should make sure to use forward slashes in their pathname (e:/test/spy.log) (used for file logger only) logfile = spy.log # append to the p6spy log file. if this is set to false the # log file is truncated every time. (file logger only) append=true #The following are for log4j logging only log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=p6spy - %m%n #log4j.appender.CHAINSAW_CLIENT=org.apache.log4j.net.SocketAppender #log4j.appender.CHAINSAW_CLIENT.RemoteHost=localhost #log4j.appender.CHAINSAW_CLIENT.Port=4445 #log4j.appender.CHAINSAW_CLIENT.LocationInfo=true log4j.logger.p6spy=DEBUG, CONSOLE My spy.log : 1097746770810|-1||debug||com.p6spy.engine.common.P6SpyOptions reloading properties 1097746770860|-1||info||Using properties file: C:\Program Files\Apache Group\Tomcat 4.1\common\lib\spy.properties 1097746770860|-1||info||No value in environment for: getStackTrace, using: false 1097746770860|-1||info||No value in environment for: getFilter, using: false 1097746770860|-1||info||No value in environment for: getAppender, using: com.p6spy.engine.logging.appender.FileLogger 1097746770860|-1||info||No value in environment for: getAppend, using: true 1097746770860|-1||info||No value in environment for: getInclude, using: 1097746770860|-1||info||No value in environment for: getDeregisterDrivers, using: false 1097746770860|-1||info||No value in environment for: getUsePrefix, using: false 1097746770860|-1||info||No value in environment for: getExecutionThreshold, using: 0 1097746770860|-1||info||No value in environment for: getAutoflush, using: true 1097746770860|-1||info||No value in environment for: getExclude, using: 1097746770860|-1||info||No value in environment for: getExcludecategories, using: info,debug,result,batch 1097746770860|-1||info||No value in environment for: getIncludecategories, using: 1097746770860|-1||info||No value in environment for: getLogfile, using: spy.log 1097746770860|-1||info||No value in environment for: getRealdriver, using: oracle.jdbc.OracleDriver 1097746770860|-1||info||No value in environment for: getRealdriver2, using: 1097746770860|-1||info||No value in environment for: getRealdriver3, using: 1097746770860|-1||info||No value in environment for: getSpydriver, using: com.p6spy.engine.spy.P6SpyDriver 1097746770860|-1||info||No value in environment for: getDateformat, using: 1097746770860|-1||info||No value in environment for: getDateformatter, using: null 1097746770870|-1||info||No value in environment for: getStringmatcher, using: com.p6spy.engine.common.SubstringMatcher 1097746770870|-1||info||No value in environment for: getStringMatcherEngine, using: [EMAIL PROTECTED] 1097746770870|-1||info||No value in environment for: getStackTraceClass, using: 1097746770870|-1||info||No value in environment for: getSQLExpression, using: null 1097746770870|-1||info||No value in environment for: getReloadProperties, using: false 1097746770870|-1||info||No value in environment for: getReloadPropertiesInterval, using: 60 1097746770870|-1||info||No value in environment for: getJNDIContextFactory, using: null 1097746770870|-1||info||No value in environment for: getJNDIContextProviderURL, using: null 1097746770870|-1||info||No value in environment for: getJNDIContextCustom, using: null 1097746770870|-1||info||No value in environment for: getRealDataSource, using: null 1097746770870|-1||info||No value in environment for: getRealDataSourceClass, using: null 1097746770870|-1||info||No value in environment for: getRealDataSourceProperties, using: null A last thing : Since I use a datasource declared in server.xml, I've put the p6spy.jar and spy.properties in [TOMCAT]\common\lib. Could it be the problem ? Thanks in advance, Jean-Jacques
