On 2017-10-11 00:49, Matt Sicker <[email protected]> wrote:
> Are you using ColumnMapping? See <
> https://logging.apache.org/log4j/2.x/manual/appenders.html#JDBCAppender>.
>
> See <
> https://github.com/apache/logging-log4j2/blob/master/log4j-nosql/src/test/resources/CassandraAppenderTest.xml>
> for example usage (even though that uses the CassandraAppender, the same
> ColumnMapping element works in JdbcAppender).
>
> On 10 October 2017 at 09:03, [email protected] <[email protected]>
> wrote:
>
> > Hi Log4j2 users,
> >
> > I've created custom-message implementing log4j2's 'message' interface like
> > following tutorial
> > https://logging.apache.org/log4j/2.x/manual/messages.html
> >
> > I've defined JDBCAppender in lo4j2.xml which writes values from above
> > message to database table.
> > I've tried using conversion-pattern %m in the Column configuration but it
> > stores the whole message.
> > Which conversion-pattern to use here to get specific variable values and
> > writing them in the table's column?
> >
> > Link to Stackoverflow question: https://stackoverflow.com/
> > questions/46668645/store-custom-message-variable-
> > values-to-the-database-tables-column-using-log4j2
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
> >
>
>
> --
> Matt Sicker <[email protected]>
>
No.
Here, they are taking the whole message
<ColumnMapping name="message" pattern="%message"/>
I dont want that.
e.g.
What I want is following:
when we execute
logger.info(new MyMessage("temp","1234","[email protected]"));
then it should write into a table
name id email
temp 1234 [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]