You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@logging.apache.org by "Petar Petrov (Jira)" <ji...@apache.org> on 2020/01/14 08:35:00 UTC
[jira] [Comment Edited] (LOG4J2-2757) JDBCAppender tableName from
Main Arguments Lookup
[ https://issues.apache.org/jira/browse/LOG4J2-2757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014924#comment-17014924 ]
Petar Petrov edited comment on LOG4J2-2757 at 1/14/20 8:34 AM:
---------------------------------------------------------------
It doesn't seem to help. *tableName=${main:1}*
{code:java}
2020-01-14 09:26:56,496 pool-2-thread-3 ERROR Unable to write to database [JdbcManager{name=TaskLogJDBC, bufferSize=0, tableName=${main:1}, columnConfigs=[{...], columnMappings=[], immediateFail=false, retry=true, reconnectIntervalMillis=5000, truncateStrings=true], connection=null, statement=null, reconnector=Reconnector [latch=java.util.concurrent.CountDownLatch@2d3b2097[Count = 0], shutdown=false], isBatchSupported=true, columnMetaData=null]).
at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeInternal(JdbcDatabaseManager.java:793)
at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeThrough(JdbcDatabaseManager.java:887)
at org.apache.logging.log4j.core.appender.db.AbstractDatabaseManager.write(AbstractDatabaseManager.java:264)
at org.apache.logging.log4j.core.appender.db.AbstractDatabaseAppender.append(AbstractDatabaseAppender.java:110)
at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:156)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:129)
at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:120)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84)
at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:543)
at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:502)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:485)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:460)
at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:82)
at org.apache.logging.log4j.core.Logger.log(Logger.java:161)
at org.apache.logging.log4j.spi.AbstractLogger.tryLogMessage(AbstractLogger.java:2198)
at org.apache.logging.log4j.spi.AbstractLogger.logMessageTrackRecursion(AbstractLogger.java:2152)
at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2135)
at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:2028)
at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1899)
at org.apache.logging.log4j.spi.AbstractLogger.debug(AbstractLogger.java:453)
at com.my.app.QueryExecutor.execute(QueryAndroidDeviceExecutor.java:50)
at com.my.app.TaskExecutor.execute(TaskExecutor.kt:30)
at com.my.app.TaskExecutor.run(TaskExecutor.kt:57)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
{code}
Config
{code:xml}
<JDBC name="TaskLogJDBC"
tableName="$${main:1}">
{code}
was (Author: ppetrov_mp):
It doesn't seem to help. *tableName=${main:1}*
{code:java}
2020-01-14 09:26:56,496 pool-2-thread-3 ERROR Unable to write to database [JdbcManager{name=TaskLogJDBC, bufferSize=0, tableName=${main:1}, columnConfigs=[{...], columnMappings=[], immediateFail=false, retry=true, reconnectIntervalMillis=5000, truncateStrings=true], connection=null, statement=null, reconnector=Reconnector [latch=java.util.concurrent.CountDownLatch@2d3b2097[Count = 0], shutdown=false], isBatchSupported=true, columnMetaData=null]).
at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeInternal(JdbcDatabaseManager.java:793)
at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeThrough(JdbcDatabaseManager.java:887)
at org.apache.logging.log4j.core.appender.db.AbstractDatabaseManager.write(AbstractDatabaseManager.java:264)
at org.apache.logging.log4j.core.appender.db.AbstractDatabaseAppender.append(AbstractDatabaseAppender.java:110)
at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:156)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:129)
at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:120)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84)
at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:543)
at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:502)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:485)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:460)
at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:82)
at org.apache.logging.log4j.core.Logger.log(Logger.java:161)
at org.apache.logging.log4j.spi.AbstractLogger.tryLogMessage(AbstractLogger.java:2198)
at org.apache.logging.log4j.spi.AbstractLogger.logMessageTrackRecursion(AbstractLogger.java:2152)
at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2135)
at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:2028)
at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1899)
at org.apache.logging.log4j.spi.AbstractLogger.debug(AbstractLogger.java:453)
at com.my.app.QueryExecutor.execute(QueryAndroidDeviceExecutor.java:50)
at com.my.app.TaskExecutor.execute(TaskExecutor.kt:30)
at com.my.app.TaskExecutor.run(TaskExecutor.kt:57)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
{code}
> JDBCAppender tableName from Main Arguments Lookup
> -------------------------------------------------
>
> Key: LOG4J2-2757
> URL: https://issues.apache.org/jira/browse/LOG4J2-2757
> Project: Log4j 2
> Issue Type: Question
> Components: Appenders, JDBC
> Affects Versions: 2.13.0
> Reporter: Petar Petrov
> Priority: Major
>
> Hi,
> I've posted this on StackOverflow, however, I could not really get any solution there.
> There is a JDBCAppender in my application to which I'd like to set the *tableName* parameter from a [main argument lookup|http://logging.apache.org/log4j/2.x/manual/lookups.html#AppMainArgsLookup]. Reason for this is that my database table may optionally have a prefix, so I'm reading this from a configuration file in my application and I'd like to apply it to the appender at runtime.
> {code:java}
> <JDBC name="TaskLogJDBC" tableName="${main:1}LogEvents">
> <ConnectionFactory class="my.package.name.ConnectionFactory" method="getConnection"/>
> <Column name="created_on" isEventTimestamp="true"/>
> <Column name="lvl" pattern="%level"/>
> <Column name="logger" pattern="%logger"/>
> <Column name="message" pattern="%message"/>
> <Column name="throwable" pattern="%ex{full}"/>
> </JDBC>
> {code}
> This is what I use in *Main.java* to set the arguments:
> {code:java}
> MainMapLookup.setMainArguments(new String[] { "--prefix", tablesPrefix });{code}
> Unfortunately, this does not seem to work. The JDBCAppender keeps reading the *tableName* parameter verbatim as _${main:1}LogEvents_ instead of _prefix_LogEvents_. I traced it and I think the JDBCAppender configuration read happens before the *MainMapLookup.setMainArguments()* gets called.
> Environment variable lookup is an option, but I'd like to avoid it at this point. Are there any other options or am I doing something wrong?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)