为什么log4j连不了数据库

Question

  我在程序里直接连没什么问题,但是log4j连接时就报错
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:212)
at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:175)
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.info(Category.java:663)
at servlet.Log4jServlet.doPost(Log4jServlet.java:62)
at servlet.Log4jServlet.doGet(Log4jServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)这是配置文件:
log4j.appender.db1=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.db1.url=jdbc:microsoft:sqlserver://localhost:1433;databaseName=log_db
log4j.appender.db1.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
log4j.appender.db1.user=sa
log4j.appender.db1.password=

Answer 1

log4j.appender.db1.url=jdbc:microsoft:sqlserver://localhost:1433;databaseName=log_db你用的SqlServer，在你的classpath目录下有没有放数据库的驱动Driver的jar包？

Answer 2

   谢谢,根据你们的思路最后发现URL要写大写,否则报错
log4j.appender.db1.url=jdbc:microsoft:sqlserver://localhost:1433;databaseName=log_db
要改成:
log4j.appender.db1.URL=jdbc:microsoft:sqlserver://localhost:1433;databaseName=log_db