java.sql.SQLException: ORA-00917: 缺少逗(log4j在数据库中插入相应信息时出现了此错误)

在用log4j在数据库中写的信息时出现了java.sql.SQLException: ORA-00917: 缺少逗号 错误，但在数据库中也插入进去数据了。log4j的内容为：

log4j.rootLogger=INFO,stdout,database
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%t %m

log4j.appender.logfile=org.apache.log4j.FileAppender
log4j.appender.logfile.File=target/spring.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] -%m%%n

log4j.appender.database=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.database.Driver=oracle.jdbc.driver.OracleDriver
log4j.appender.database.URL=jdbc:oracle:thin:@127.0.0.1:1521:zwndb
log4j.appender.database.user=zwn
log4j.appender.database.password=zwn
log4j.appender.database.BufferSize=1
log4j.appender.database.layout=org.apache.log4j.PatternLayout
log4j.appender.database.Sql=INSERT INTO LOGERROR(ERRORID,ERRORMESSAGE) VALUES('%t','%m')

 

下面为出现的：java.sql.SQLException: ORA-00917: 缺少逗号

 

信息: Initializing Log4J from [C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/Struts_Hibernate_Spring/WEB-INF/log4j.properties]
main ContextLoaderPlugIn for Struts ActionServlet 'action, module '': initialization startedlog4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-00917: 缺少逗号

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
 at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
 at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
 at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
 at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:178)
 at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:250)
 at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:146)
 at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:230)
 at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:65)
 at org.apache.log4j.Category.callAppenders(Category.java:203)
 at org.apache.log4j.Category.forcedLog(Category.java:388)
 at org.apache.log4j.Category.log(Category.java:853)
 at org.apache.commons.logging.impl.Log4JLogger.info(Log4JLogger.java:133)
 at org.springframework.web.struts.ContextLoaderPlugIn.init(ContextLoaderPlugIn.java:218)
 at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869)
 at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336)
 at javax.servlet.GenericServlet.init(GenericServlet.java:212)
 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4364)
 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:525)
 at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
 at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
 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:578)
 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)
2008-10-28 22:31:52 org.apache.catalina.core.ApplicationContext log