A requirement has come up and we want to build a logging server that actually performs the database write. Previously we had been logging to the file and it was working perfectly fine for web based application too.
We want to take one step further and log to db so that querying specific info as part of MIS and reporting would be easier.
We used Log4j to log to file and would continue to use Log4J for db logging too. We would like to take the logging as an asynchronous process thru jms so that performance wd not get affected.
I see that there are classes like xxxAppender for various types of logging.
Has anyone implemented this type of db logging? If so, can u throw some light on how you approached it etc.