This is my configuration of the log4j.xml.

<appender name="LOGTABLE" class="org.apache.log4j.jdbc.JDBCAppender">
<param name="url" value="jdbcostgresql://myhost/db"/>
<param name="driver" value="org.postgresql.Driver"/>
<param name="user" value="myusername"/>
<param name="password" value="mypassword"/>

<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="INSERT INTO public.logtable(dated,message) VALUES('%d','%m')"/>
</layout>
</appender>

<logger name="log4j.rootLogger" additivity="true">
<level value="DEBUG"/>
<appender-ref ref="LOGTABLE"/>
</logger>
  • After each configuration change I restart Mondrian server(Saiku)
  • Run few MDX queries on Saiku
  • Then check my database table and nothing is written on it.

Is there anything I'm doing wrong? Please help...