I have a web service Jax-RS running in Weblogic. I have a need to logg the calls made to the service.
What is the best way to log to SQL Server from a java application?
Thanks.
+2
A:
Since you're asking for the best way, and if Log4J is not a strong requirement, my suggestion would be to use Logback and its DbAppender. That's the best way :)
Last time I checked, the JDBCAppender from Log4J was still not satisfying and if you can't use logback, you might prefer some third party implementation. See the links below for details:
Pascal Thivent
2010-09-21 14:40:06
Can logback be dynamically turned on and off once the app is live?
John
2010-09-23 13:56:18
@John Yes, logback can be configured to [reload](http://logback.qos.ch/manual/configuration.html#autoScan) its configuration. You can also configure it at runtime via [JMX](http://logback.qos.ch/manual/jmxConfig.html).
Pascal Thivent
2010-09-23 14:03:00
A:
This question was asked in a very simlilar fashion a little while ago.
See here for the original: http://stackoverflow.com/questions/1364322/log-to-a-database-using-log4j
The accepted answer points to the DBAppender by logback. http://logback.qos.ch/manual/appenders.html#DBAppender
fgysin
2010-09-21 14:50:06