参考:
http://tomcat.apache.org/tomcat-6.0-doc/api/org/apache/catalina/valves/JDBCAccessLogValve.html
conf/server.xml
unpackWARs="false" autoDeploy="false"
xmlValidation="false" xmlNamespaceAware="false">
driverName="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/xx888"
connectionName ="root"
connectionPassword="123456789 "
tableName = "tomcat_access"
pattern="combined"
resolveHosts="false"
/>
mysql中建立表:
CREATE TABLE tomcat_access (
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
remoteHost CHAR(15) NOT NULL,
userName CHAR(15),
timestamp TIMESTAMP NOT NULL,
virtualHost VARCHAR(64) NOT NULL,
method VARCHAR(8) NOT NULL,
query VARCHAR(255) NOT NULL,
status SMALLINT UNSIGNED NOT NULL,
bytes INT UNSIGNED NOT NULL,
referer VARCHAR(300),
userAgent VARCHAR(300),
PRIMARY KEY (id),
INDEX (timestamp),
INDEX (remoteHost),
INDEX (virtualHost),
INDEX (query),
INDEX (userAgent)
);
mysql jdbc jar文件放到相应的目录,这个自不必说了.