Guest User

Untitled

a guest
Jan 8th, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. <appender name="db-output" class="org.apache.log4j.jdbc.JDBCAppender">
  2. <param name="url" value="jdbc:postgresql://myserver.mydomain.com:5432/somedb?currentSchema=someschema" />
  3. <param name="driver" value="org.postgresql.Driver" />
  4. <param name="user" value="myusername" />
  5. <param name="password" value="mypassword" />
  6. <param name="sql" value="INSERT INTO runlog(eventtime,event) VALUES('%d','%m')" />
  7. <layout class="org.apache.log4j.PatternLayout">
  8. </layout>
  9. </appender>
  10.  
  11. log4j:ERROR Failed to excute sql java.sql.SQLException: No suitable driver found for jdbc:odbc:myDB
  12. at java.sql.DriverManager.getConnection(Unknown Source)
  13. at java.sql.DriverManager.getConnection(Unknown Source)
  14. at org.apache.log4j.jdbc.JDBCAppender.getConnection(JDBCAppender.java:251)
  15. at org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:215)
  16. at org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:289)
  17. at org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:186)
  18. at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251) at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
  19. at org.apache.log4j.Category.callAppenders(Category.java:206)
  20. at org.apache.log4j.Category.forcedLog(Category.java:391)
  21. at org.apache.log4j.Category.log(Category.java:856)
  22. at org.slf4j.impl.Log4jLoggerAdapter.info(Log4jLoggerAdapter.java:305)
  23. at report.Runner.main(Runner.java:109)
Add Comment
Please, Sign In to add comment