Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <appender name="db-output" class="org.apache.log4j.jdbc.JDBCAppender">
- <param name="url" value="jdbc:postgresql://myserver.mydomain.com:5432/somedb?currentSchema=someschema" />
- <param name="driver" value="org.postgresql.Driver" />
- <param name="user" value="myusername" />
- <param name="password" value="mypassword" />
- <param name="sql" value="INSERT INTO runlog(eventtime,event) VALUES('%d','%m')" />
- <layout class="org.apache.log4j.PatternLayout">
- </layout>
- </appender>
- log4j:ERROR Failed to excute sql java.sql.SQLException: No suitable driver found for jdbc:odbc:myDB
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:251)
- at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:215)
- at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:289)
- at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:186)
- at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251) at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
- at org.apache.log4j.Category.callAppenders(Category.java:206)
- at org.apache.log4j.Category.forcedLog(Category.java:391)
- at org.apache.log4j.Category.log(Category.java:856)
- at org.slf4j.impl.Log4jLoggerAdapter.info(Log4jLoggerAdapter.java:305)
- at report.Runner.main(Runner.java:109)
Add Comment
Please, Sign In to add comment