how to pass datetime as long value in log4j2.properties file in jdbc appender

Question

I have a entity with a Long parameter that record 'System.currentTimeMillis()' value.

In log4j2 properties file, I need to get current Time in millisecond and pass as a column value, like below:

appender.systemLog.columnConfigs[0].type = Column
appender.systemLog.columnConfigs[0].name = CREATION_TIME
appender.systemLog.columnConfigs[0].literal = **???**
appender.systemLog.columnConfigs[0].isUnicode = false

I can not use isEventTimestamp because my parameter is a long!

how can I do it.

would converting your long parameter to a Date be an option? — Marcus Lanvers, Apr 24 '19 at 12:58

score 0 · Accepted Answer · answered May 13 '19 at 11:21

I use it to solve my problem:

appender.systemLog.columnConfigs[0].type = Column
appender.systemLog.columnConfigs[0].name = CREATION_TIME
appender.systemLog.columnConfigs[0].pattern = %d{UNIX_MILLIS}
appender.systemLog.columnConfigs[0].isUnicode = false

special thanks to thegeko

how to pass datetime as long value in log4j2.properties file in jdbc appender

1 Answers1