关于spring log4j配置数据库的问题。求解决

0 0

关于spring log4j配置数据库的问题。求解决5

web.xml的配配置如下

<!--Spring contextConfigLocation 载入开始 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
			classpath:config/applicationContext.xml
		</param-value>
	</context-param>
		<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<!--Spring contextConfigLocation 载入结束 -->
	
	
<!--由Sprng载入的Log4j配置文件位置-->
<context-param>
       <param-name>log4jConfigLocation</param-name>
       <param-value>classpath:config/log4j.properties</param-value>
</context-param>

<!--Spring默认刷新Log4j配置文件的间隔,单位为millisecond-->
<context-param>
       <param-name>log4jRefreshInterval</param-name>
       <param-value>60000</param-value>
</context-param>

<!--Spring log4j Config loader-->
<listener>
       <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
</listener>

log4j.properties 配置如下：

log4j.rootLogger=INFO, DATABASE , A1 ,CONSOLE

log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DATABASE.URL=jdbc:oracle:thin:@127.0.0.1:1521:orcl
log4j.appender.DATABASE.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.DATABASE.user=test
log4j.appender.DATABASE.password=test
#log4j.appender.DATABASE.sql=INSERT INTO LOG4J(id,Message) VALUES (sysdate,[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n)
log4j.appender.DATABASE.sql=INSERT INTO log4j (log_date, log_level, location, message) VALUES ('%d{ISO8601}', '%p', '%C,%L', '%m')  
log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
log4j.appender.DATABASE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n

表结构如下：

create table LOG4J
(
  MESSAGE   VARCHAR2(4000),
  LOG_DATE  VARCHAR2(50),
  LOG_LEVEL VARCHAR2(50),
  LOCATION  VARCHAR2(500)
)

报错如下：
2012-2-28 0:53:44 org.apache.catalina.core.ApplicationContext log
信息: Initializing log4j from [classpath:config/log4j.properties]
2012-2-28 0:53:44 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class org.springframework.web.util.Log4jConfigListener
java.lang.IllegalArgumentException: Illegal pattern character 'l'
at java.text.SimpleDateFormat.compile(SimpleDateFormat.java:751)
at java.text.SimpleDateFormat.initialize(SimpleDateFormat.java:558)
at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:483)
at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:458)
at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:218)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:132)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:96)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:654)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612)
at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:509)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:415)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:316)
at org.apache.log4j.PropertyWatchdog.doOnChange(PropertyConfigurator.java:682)
at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:88)
at org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:57)
at org.apache.log4j.PropertyWatchdog.<init>(PropertyConfigurator.java:674)
at org.apache.log4j.PropertyConfigurator.configureAndWatch(PropertyConfigurator.java:382)
at org.springframework.util.Log4jConfigurer.initLogging(Log4jConfigurer.java:106)
at org.springframework.web.util.Log4jWebConfigurer.initLogging(Log4jWebConfigurer.java:144)
at org.springframework.web.util.Log4jConfigListener.contextInitialized(Log4jConfigListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2012-2-28 0:53:44 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2012-2-28 0:53:44 org.apache.catalina.core.StandardContext start。

能正常加载log4j，但写入数据失败。

2012年2月28日 01:03

fishitit
25
0 0 0

1个答案按时间排序按投票排序

0 0

java.lang.IllegalArgumentException: Illegal pattern character 'l' 
at java.text.SimpleDateFormat.compile(SimpleDateFormat.java:751)

2012年3月01日 13:37

7454103
2621
0 1 18

添加评论

已解决问题

未解决问题

排行榜

查看全部排名>>