logging analyse tool: profsql.cmd

[Martin Cavanagh]

Hello log4jdbc users.

I've tried to use profsql.cmd on the output from log4jdbc.

Unfortunately it tells me that 0 sql statements were found (even though the file contains thousands of statements).

Are there specific patterns which profsql.cmd requires?

# Direct log messages to a log file

log4j.appender.file=org.apache.log4j.DailyRollingFileAppender

log4j.appender.file.File=logs/log4j.log

log4j.appender.file.DatePattern='.'yyyy-MM-dd'.log'

log4j.appender.file.staticLogFileName=false

log4j.appender.file.MaxFileSize=1024MB

log4j.appender.file.MaxBackupIndex=7

log4j.appender.file.layout=org.apache.log4j.PatternLayout

#log4j.appender.file.layout.ConversionPattern=%d{yyyy-MMM-dd HH:mm:ss,SSS} [%t] %c %x%n  %-5p %m%n

log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

  

# Root logger option

log4j.rootLogger=WARN, file

#logs info from JDBC Driver

! Log timing information about the SQL that is executed.

log4j.logger.jdbc.sqltiming=DEBUG,jdbc_sqltiming

log4j.additivity.jdbc.sqltiming=false

! Log connection open/close events and connection number dump

log4j.logger.jdbc.connection=DEBUG,jdbc_connection

log4j.additivity.jdbc.connection=false

log4j.appender.jdbc_sqltiming=org.apache.log4j.DailyRollingFileAppender

log4j.appender.jdbc_sqltiming.File=logs/sqltiming-java-db-log4j.log

log4j.appender.jdbc_sqltiming.DatePattern='.'yyyy-MM-dd'.log'

log4j.appender.jdbc_sqltiming.staticLogFileName=false

log4j.appender.jdbc_sqltiming.MaxFileSize=1024MB

log4j.appender.jdbc_sqltiming.MaxBackupIndex=7

log4j.appender.jdbc_sqltiming.layout=org.apache.log4j.PatternLayout

#log4j.appender.jdbc_sqltiming.layout.ConversionPattern=%d{yyyy-MMM-dd HH:mm:ss,SSS} [%t] %c %x%n  %-5p %m%n

log4j.appender.jdbc_sqltiming.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

log4j.appender.jdbc_connection=org.apache.log4j.DailyRollingFileAppender

log4j.appender.jdbc_connection.File=logs/jdbc-connection.log

log4j.appender.jdbc_connection.DatePattern='.'yyyy-MM-dd'.log'

log4j.appender.jdbc_connection.staticLogFileName=false

log4j.appender.jdbc_connection.MaxFileSize=1024MB

log4j.appender.jdbc_connection.MaxBackupIndex=7

log4j.appender.jdbc_connection.layout=org.apache.log4j.PatternLayout

#log4j.appender.jdbc_connection.layout.ConversionPattern=%d{yyyy-MMM-dd HH:mm:ss,SSS} [%t] %c %x%n  %-5p %m%n

log4j.appender.jdbc_connection.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

Thanks for your help in advance.

Martin Cavanagh

[Arthur Blake]

profsql.cmd was an experimental tool that I created quite some time ago.  I've never received any questions about it at all, up to this point-- so I don't think anyone is really using it (not even me...)

As far as the exact syntax of the SQL, you'd have to go look at the code (even I myself have not used that tool in years.)