Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Log output

Bobby
2005-05-20
2013-04-25
  • Bobby
    Bobby
    2005-05-20

    It would be nice if I could alter the log format of the P6Spy driver.  Currently, it looks like:

    current time|execution time|category|statement SQL String|effective SQL string

    But I only want to see the effective SQL string...
    It would help if there were a "ConversionPattern" something similiar to log4j...

     
    • Mattwm6698
      Mattwm6698
      2005-12-01

      What I'm getting in my log file is alittle different.  There seems to be an extra item.

      Here is one of my lines in the file:

      12/01/2005 16:24:58:604|48|1|statement|stmt sql|eff sql

      this would be:

      timestamp|execution time|??|category|stmt sql|eff sql

      What is the number in the 3rd column?

       
      • Hocher
        Hocher
        2006-11-30

        The third column seems to be a connection identifier/number.
        I have a connection pool with 5 Oracle connections and a regular check of the connections
        by my application server. The output in the log file is :
        11-30-06 10:22:30:717|2|4|statement|select count(*) from dual|select count(*) from dual
        11-30-06 10:22:30:719|1|3|statement|select count(*) from dual|select count(*) from dual
        11-30-06 10:22:30:720|1|2|statement|select count(*) from dual|select count(*) from dual
        11-30-06 10:22:30:722|1|1|statement|select count(*) from dual|select count(*) from dual
        11-30-06 10:22:30:724|1|0|statement|select count(*) from dual|select count(*) from dual