tomcat mysql数据库配置文件_配置tomcat 将详细日志写入mysql数据库

参考:

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文件放到相应的目录,这个自不必说了.