Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <Configuration status="error">
- <Appenders>
- <JDBC name="databaseAppender" tableName="dbo.application_log">
- <DataSource jndiName="java:/comp/env/jdbc/LoggingDataSource" />
- <Column name="eventDate" isEventTimestamp="true" />
- <Column name="level" pattern="%level" />
- <Column name="logger" pattern="%logger" />
- <Column name="message" pattern="%message" />
- <Column name="exception" pattern="%ex{full}" />
- </JDBC>
- </Appenders>
- <Loggers>
- <Root level="warn">
- <AppenderRef ref="databaseAppender"/>
- </Root>
- </Loggers>
- </Configuration>
- <?xml version="1.0" encoding="UTF-8"?>
- <Configuration>
- <Appenders>
- <JDBC name="SQLServerAppender" tableName="dbo.LogEntry">
- <DataSource jndiName="jdbc:sqlserver://MyMachine\MyInstance:1433;databaseName=LoggingDB;applicationName=myappname;integratedSecurity=true;" />
- <Column name="EntryDateUtc" isEventTimestamp="true" />
- <Column name="LOGGER" pattern="%C" />
- <Column name="Level" pattern="%level" />
- <Column name="Message" pattern="%m" />
- <Column name="UserName" pattern="%x" />
- <Column name="Priority" pattern="%p" />
- <Column name="ElapsedMilliseconds" pattern="%r" />
- <Column name="ThreadName" pattern="%t" />
- <Column name="ThrowableMessage" pattern="%throwable " />
- </JDBC>
- ERROR No ConnectionSource provided: connectionSource
- 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'
- <Appenders>
- <JDBC name="SQLServerAppender" tableName="dbo.LogEntry">
- <ConnectionSource jndiName="jdbc:sqlserver
Add Comment
Please, Sign In to add comment