Could you turn on show queries in PostgreSQL and check what logback is doing?<div><br></div><div><a href="http://www.postgresql.org/docs/current/static/runtime-config-logging.html">http://www.postgresql.org/docs/current/static/runtime-config-logging.html</a> documents the log_statement configuration element that you'd need to fiddle with to get that working.</div>
<div><br></div><div>Nik<br><br><div class="gmail_quote">On Thu, Mar 4, 2010 at 10:05 AM, Mohammad Haider <span dir="ltr"><<a href="mailto:mohammadh@lashpoint.com">mohammadh@lashpoint.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Yes, the status message is:<br>
<br>
Driver name=PostgreSQL Native Driver<br>
Driver version=PostgreSQL 8.4 JDBC3 (build 701)<br>
supportsGetGeneratedKeys=true<br>
true<br>
11:01:54,843 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback-test.xml] at [file:/C:/Bids_WrkSpace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/TIPS/WEB-INF/classes/logback-test.xml]<br>
11:01:55,015 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Setting ReconfigureOnChangeFilter scanning period to 30 seconds<br>
11:01:55,015 |-INFO in ch.qos.logback.classic.turbo.ReconfigureOnChangeFilter@17e845a - Will scan for changes in file [C:\Bids_WrkSpace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\TIPS\WEB-INF\classes\logback-test.xml] every 30 seconds.<br>
11:01:55,015 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - Adding ReconfigureOnChangeFilter as a turbo filter<br>
11:01:55,140 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.classic.db.DBAppender]<br>
11:01:55,140 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB]<br>
11:01:55,156 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Pushing component [connectionSource] on top of the object stack.<br>
11:01:55,296 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Popping appender named [DB] from the object stack<br>
11:01:55,296 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to DEBUG<br>
11:01:55,296 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[ROOT]<br>
11:01:55,312 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.<div><div></div><div class="h5"><br>
<br>
<br>
Ceki Gülcü wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Are you seeing any status messages?<br>
<br>
On 04/03/2010 3:49 PM, Mohammad Haider wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I have created three tables for logback according to documentation.<br>
<br>
I have the following config. file:<br>
<?xml version="1.0" encoding="UTF-8"?><br>
<configuration debug="true" scan="true" scanPeriod="30 seconds"><br>
<appender name="DB" class="ch.qos.logback.classic.db.DBAppender"><br>
<connectionSource<br>
class="ch.qos.logback.core.db.DriverManagerConnectionSource"><br>
<driverClass>org.postgresql.Driver</driverClass><br>
<url>jdbc:postgresql://localhost:5432/tips_log</url><br>
<user>postgres</user><br>
<password>test</password><br>
</connectionSource><br>
</appender><br>
<br>
<root level="debug"><br>
<appender-ref ref="DB"/><br>
</root><br>
</configuration><br>
<br>
In my code I have put simple logger.debug("DB test");.<br>
However, I did not see any log data in the tables.<br>
<br>
Can anyone please help about this issue? Why am I not getting any log<br>
data in the table?<br>
</blockquote>
<br>
_______________________________________________<br>
Logback-user mailing list<br>
<a href="mailto:Logback-user@qos.ch" target="_blank">Logback-user@qos.ch</a><br>
<a href="http://qos.ch/mailman/listinfo/logback-user" target="_blank">http://qos.ch/mailman/listinfo/logback-user</a><br>
</blockquote>
<br>
<br></div></div>
-- <br>
Thanks<br>
* Mohammad Firoj Haider*<br>
Software Developer<br>
LashPoint Inc <<a href="http://www.lashpoint.com" target="_blank">http://www.lashpoint.com</a>><br>
Email: <a href="mailto:mohammadh@lashpoint.com" target="_blank">mohammadh@lashpoint.com</a> <mailto:<a href="mailto:mohammadh@lashpoint.com" target="_blank">mohammadh@lashpoint.com</a>><br>
Blog: The Daily Programming <<a href="http://www.codinglogs.blogspot.com/" target="_blank">http://www.codinglogs.blogspot.com/</a>><br>
<br>
Lashpoint mini logo<div><div></div><div class="h5"><br>
<br>
<br>
_______________________________________________<br>
Logback-user mailing list<br>
<a href="mailto:Logback-user@qos.ch" target="_blank">Logback-user@qos.ch</a><br>
<a href="http://qos.ch/mailman/listinfo/logback-user" target="_blank">http://qos.ch/mailman/listinfo/logback-user</a><br>
</div></div></blockquote></div><br></div>