JDBCAppender and Webservice Trace

[krishnaroopa senthilkumar]

Hi all

We need to log all web services request and response trace. When i used file appender, the traces are logged. But with JDBCAppender, the category and appender-ref seems to have no effect.

   <appender name="Database" class="org.apache.log4j.jdbc.JDBCAppender">
	<param name="Driver" value="com.mysql.jdbc.Driver"/>
	<param name="URL" value="jdbc:mysql://127.0.0.1:3306/logdb" />
	<param name="user" value="root" /> 
	<param name="password" value="root" />
	<param name="sql" value="insert into logTable (message, class, priority, log_date) 
	values ('%m', '%c', '%p', '%d{dd.MM.yyyy}')"/>
</appender>

<category name="org.jboss.ws.core.MessageTrace">
	<appender-ref ref="Database"></appender-ref>
	<priority value="TRACE"/>
 </category>
 

What might be issue or is it not possible with JDBCAppender ?

regards
KRS

[Martijn Verburg]

Hi there and welcome to Javaranch!

Unfortunately I don't use the JDBCAppender but have you tried the log4j mailing list?