> As you are using a datasource maybe you can configure P6Spy to use it >instead ? OK, i'll try.
>Anyway, you might also want to ask on the P6Spy mailing lists as this >problem seems more related to that subsystem rather than the SQLProfiler. Yes, of course. Thanks, >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 > > > >
