Guest User

Untitled

a guest
Aug 30th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <Configuration status="error">
  3. <Appenders>
  4. <JDBC name="databaseAppender" tableName="dbo.application_log">
  5. <DataSource jndiName="java:/comp/env/jdbc/LoggingDataSource" />
  6. <Column name="eventDate" isEventTimestamp="true" />
  7. <Column name="level" pattern="%level" />
  8. <Column name="logger" pattern="%logger" />
  9. <Column name="message" pattern="%message" />
  10. <Column name="exception" pattern="%ex{full}" />
  11. </JDBC>
  12. </Appenders>
  13. <Loggers>
  14. <Root level="warn">
  15. <AppenderRef ref="databaseAppender"/>
  16. </Root>
  17. </Loggers>
  18. </Configuration>
  19.  
  20. <?xml version="1.0" encoding="UTF-8"?>
  21. <Configuration>
  22. <Appenders>
  23. <JDBC name="SQLServerAppender" tableName="dbo.LogEntry">
  24. <DataSource jndiName="jdbc:sqlserver://MyMachine\MyInstance:1433;databaseName=LoggingDB;applicationName=myappname;integratedSecurity=true;" />
  25. <Column name="EntryDateUtc" isEventTimestamp="true" />
  26. <Column name="LOGGER" pattern="%C" />
  27. <Column name="Level" pattern="%level" />
  28. <Column name="Message" pattern="%m" />
  29. <Column name="UserName" pattern="%x" />
  30. <Column name="Priority" pattern="%p" />
  31. <Column name="ElapsedMilliseconds" pattern="%r" />
  32. <Column name="ThreadName" pattern="%t" />
  33. <Column name="ThrowableMessage" pattern="%throwable " />
  34. </JDBC>
  35.  
  36. ERROR No ConnectionSource provided: connectionSource
  37. ERROR Could not create plugin of type class org.apache.logging.log4j.core.appender.db.jdbc.JdbcAppender for element JDBC org.apache.logging.log4j.core.config.ConfigurationException: Arguments given for element JDBC are invalid: field 'connectionSource' has invalid value 'null'
  38.  
  39. <Appenders>
  40. <JDBC name="SQLServerAppender" tableName="dbo.LogEntry">
  41.  
  42. <ConnectionSource jndiName="jdbc:sqlserver
Add Comment
Please, Sign In to add comment