Logging into Database

[Jibitesh Prasad]

I want my logs to be generated into a database. I am able to populate the logs if i have a single column. But how do i populate multiple columns?

Lets say log is : "Welcome User"

I want to log it into two columns of the database: "Welcome" and "User"
Can anyone help me with this.

Thanks in advance.

[Ulf Dittmer]

In general, you can use the "...sql" parameter to execute any SQL statement you like; that should be sufficient to insert into two columns. This article shows how.

But you'll probably have to write your own appender (which can extend JDBCAppender) to break the logging string into two.
[ March 14, 2008: Message edited by: Ulf Dittmer ]