Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <JDBC name="DBLogger" tableName="db_logs" ignoreExceptions="false">
- <DriverManager
- connectionString="jdbc:mysql://localhost:3306/twib"
- userName="****"
- password="****"
- driverClassName="com.mysql.jdbc.Driver"
- />
- <ColumnMapping name="date_time" pattern="%d{UNIX_MILLIS}" />
- <ColumnMapping name="user_id" />
- <ColumnMapping name="session_id" />
- <ColumnMapping name="user_ip" />
- <ColumnMapping name="user_agent" />
- <ColumnMapping name="device_info" />
- <ColumnMapping name="device_id" />
- <ColumnMapping name="device_mac" />
- <ColumnMapping name="device_imei" />
- <ColumnMapping name="device_imsi" />
- <ColumnMapping name="request_name" />
- <ColumnMapping name="request_xml" />
- <ColumnMapping name="response_xml" />
- <MessageLayout />
- </JDBC>
- //get logger instance
- Logger dbLogger = LogManager.getLogger("DBLogger");
- //create map for map message
- HashMap map = new HashMap();
- //fill in map with values
- map.put("user_id", "...");
- //...here go other map fields
- map.put("response_xml", "...");
- //log the map message with logger to DB
- dbLogger.debug(new MapMessage(map));
- <ColumnMapping name="user_id" />
- <ColumnMapping name="user_id" pattern="%K{user_id}"/>
Add Comment
Please, Sign In to add comment