Guest User

Untitled

a guest
Jul 10th, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. <JDBC name="DBLogger" tableName="db_logs" ignoreExceptions="false">
  2. <DriverManager
  3. connectionString="jdbc:mysql://localhost:3306/twib"
  4. userName="****"
  5. password="****"
  6. driverClassName="com.mysql.jdbc.Driver"
  7. />
  8.  
  9. <ColumnMapping name="date_time" pattern="%d{UNIX_MILLIS}" />
  10. <ColumnMapping name="user_id" />
  11. <ColumnMapping name="session_id" />
  12. <ColumnMapping name="user_ip" />
  13. <ColumnMapping name="user_agent" />
  14. <ColumnMapping name="device_info" />
  15. <ColumnMapping name="device_id" />
  16. <ColumnMapping name="device_mac" />
  17. <ColumnMapping name="device_imei" />
  18. <ColumnMapping name="device_imsi" />
  19. <ColumnMapping name="request_name" />
  20. <ColumnMapping name="request_xml" />
  21. <ColumnMapping name="response_xml" />
  22. <MessageLayout />
  23. </JDBC>
  24.  
  25. //get logger instance
  26. Logger dbLogger = LogManager.getLogger("DBLogger");
  27. //create map for map message
  28. HashMap map = new HashMap();
  29. //fill in map with values
  30. map.put("user_id", "...");
  31. //...here go other map fields
  32. map.put("response_xml", "...");
  33. //log the map message with logger to DB
  34. dbLogger.debug(new MapMessage(map));
  35.  
  36. <ColumnMapping name="user_id" />
  37.  
  38. <ColumnMapping name="user_id" pattern="%K{user_id}"/>
Add Comment
Please, Sign In to add comment