<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Hi,</div>
<div>Db appender with logback access and weblogic sever is not insering the records into the database here is my configuration check out tell me the issue</div>
<div> </div>
<div>Logback.xml(appender configuration)</div>
<div><font face="Courier New" color="#008080"><<font color="#3F7F7F"><span style="background-color:#D4D4D4">appender</span></font><font color="#000000"> </font><font color="#7F007F">name</font><font color="#000000">=</font><font color="#2A00FF"><i>"DB"</i></font><font color="#000000">
</font><font color="#7F007F">class</font><font color="#000000">=</font><font color="#2A00FF"><i>"ch.qos.logback.classic.db.DBAppender"</i></font>></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">connectionSource</font> <font color="#7F007F">class</font>=<font color="#2A00FF"><i>"ch.qos.logback.core.db.JNDIConnectionSource"</i></font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"jndiLocation"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"saa_datasource"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"user"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"weblogic"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"password"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"weblogic"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"></</font><font color="#3F7F7F">connectionSource</font><font color="#008080">></font></font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> <font color="#008080"></</font><font color="#3F7F7F"><span style="background-color:#D4D4D4">appender</span></font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">appender</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"DB1"</i></font> <font color="#7F007F">class</font>=<font color="#2A00FF"><i>"ch.qos.logback.access.db.DBAppender"</i></font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">connectionSource</font> <font color="#7F007F">class</font>=<font color="#2A00FF"><i>"ch.qos.logback.core.db.JNDIConnectionSource"</i></font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"jndiLocation"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"saa_datasource"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"user"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"weblogic"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">param</font> <font color="#7F007F">name</font>=<font color="#2A00FF"><i>"password"</i></font> <font color="#7F007F">value</font>=<font color="#2A00FF"><i>"weblogic"</i></font>
<font color="#008080">/></font></font></div>
<div><font face="Courier New"> <font color="#008080"></</font><font color="#3F7F7F">connectionSource</font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"><</font><font color="#3F7F7F">insertHeaders</font><font color="#008080">></font>true<font color="#008080"></</font><font color="#3F7F7F">insertHeaders</font><font color="#008080">></font></font></div>
<div><font face="Courier New"> <font color="#008080"></</font><font color="#3F7F7F">appender</font><font color="#008080">></font></font></div>
<div><font face="Courier New" color="#008080"> </font></div>
<div><font face="Courier New" color="#008080"> </font></div>
<div><font face="Courier New" color="#008080">Datasource name :saa_datasource</font></div>
<div><font face="Courier New" color="#008080">Weblogic username:<font face="Courier New" color="#2A00FF"><i>weblogic</i></font></font></div>
<div><font face="Courier New" color="#008080">Weblogic password:<font face="Courier New" color="#2A00FF"><i>weblogic</i></font></font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> </font></div>
<div>I am also using jndi.properties</div>
<div> </div>
<div><font face="Courier New">java.naming.provider.url=<font color="#2A00FF">t3</font>:<font color="#2A00FF">//</font><font color="#2A00FF"><u>localhost</u></font><font color="#2A00FF">:7001</font></font></div>
<div><font face="Courier New">java.naming.factory.initial=<font color="#2A00FF"><u>weblogic</u></font><font color="#2A00FF">.</font><font color="#2A00FF"><u>jndi</u></font><font color="#2A00FF">.WLInitialContextFactory</font></font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> </font></div>
<div><font face="Courier New"> </font></div>
<div>All my configuration is fine and at the time of server startup it is initialising fine but it is not inserting the records(logging) into database tables (5 tables as described in logback manual)</div>
<div> </div>
<div> </div>
<div> </div>
<div>08:31:10,597 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.classic.db.DBAppe</div>
<div>08:31:10,613 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB]</div>
<div>08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - Driver name=Oracle JDBC driver</div>
<div>08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - Driver version=11.1.0.6.0-Production+</div>
<div>08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - supportsGetGeneratedKeys=true</div>
<div>08:31:10,800 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.access.db.DBAppen</div>
<div>08:31:10,800 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB1]</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - Driver name=Oracle JDBC driver</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - Driver version=11.1.0.6.0-Production+</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - supportsGetGeneratedKeys=true</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa] to false</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa level set to TRACE</div>
<div>08:31:10,925 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[com.sia.saa]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[com.sia.saa]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[com.sia.saa]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SAACOMPLETELOGS] to Logger[com.sia.saa]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.filter.PerfLoggingFil</div>
<div>o true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.filter.PerfLoggingFilter level set to TRACE</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.fil</div>
<div>rfLoggingFilter]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[com.sia.saa.common.filter.Pe</div>
<div>ingFilter]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[com.sia.saa.common.filter.P</div>
<div>gingFilter]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.util.PerfLoggingFlowE</div>
<div>onListener] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.util.PerfLoggingFlowExecutionListener level set to T</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.uti</div>
<div>LoggingFlowExecutionListener]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.logging.SIALoggingInt</div>
<div>or] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.logging.SIALoggingInterceptor level set to TRACE</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.log</div>
<div>IALoggingInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.krisflyer] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.krisflyer level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [KRISFLYER] to Logger[com.sia.saa.krisflyer</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.booking] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.booking level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [BOOKING] to Logger[com.sia.saa.booking]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.misc] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.misc level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [MISC] to Logger[com.sia.saa.misc]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.corporate] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.corporate level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [CORPORATE] to Logger[com.sia.saa.corporate</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [COMMON] to Logger[com.sia.saa.common]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.promotions] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.promotions level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PROMOTIONS] to Logger[com.sia.saa.promotio</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.admin] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.admin level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [ADMIN] to Logger[com.sia.saa.admin]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.payment] to true</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.payment level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PAYMENT] to Logger[com.sia.saa.payment]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org level set to ERROR</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[org]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[org]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.hibernate] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.hibernate level set to INFO</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[org.hibernate]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.springframework] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.springframework level set to INFO</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[org.springframework]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [net.sf.ehcache] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - net.sf.ehcache level set to INFO</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[net.sf.ehcache]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.googlecode.ehcache] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.googlecode.ehcache level set to DEBUG</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[com.googlecode.ehcache]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.cxf.interceptor.LoggingInInte</div>
<div>r] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.cxf.interceptor.LoggingInInterceptor level set to INFO</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org.apache.cxf.interceptor.L</div>
<div>InInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[org.apache.cxf.</div>
<div>eptor.LoggingInInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.cxf.interceptor.LoggingOutInt</div>
<div>or] to false</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.cxf.interceptor.LoggingOutInterceptor level set to INFO</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org.apache.cxf.interceptor.L</div>
<div>OutInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[org.apache.cxf.interceptor.</div>
<div>gOutInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[org.apache.cxf.</div>
<div>eptor.LoggingOutInterceptor]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to TRACE</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [BOOKING] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [COMMON] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [MISC] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [KRISFLYER] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [ADMIN] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PAYMENT] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SAACOMPLETELOGS] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[ROOT]</div>
<div>08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.</div>
<div> </div>
<div><Jan 6, 2011 8:31:53 AM IST> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Serv</div>
<div>ccessfully.></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Warning> <Server> <BEA-002611> <Hostname "blrhrayas84573.sapient.com", maps to multiple IP addresses: 10.209.220.1</div>
<div>7.0.0.1></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 127.0.0.1:7001 for protocols iiop, t3, lda</div>
<div>p, http.></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 10.209.220.194:7001 for protocols iiop, t3, l</div>
<div>nmp, http.></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Warning> <Server> <BEA-002611> <Hostname "localhost", maps to multiple IP addresses: 10.209.220.194, 127.0.0.1></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000331> <Started WebLogic Admin Server "AdminServer" for domain "harishdomaintrunk"</div>
<div>g in Development Mode></div>
<div><Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING></div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div>Can any one tell me the issue why it is not working</div>
<div> </div>
<div> </div>
<div> </div>
<div>With regards…</div>
<div>V.S.N.HARISH.RAYASAM</div>
<div> </div>
<div> </div>
</font>
</body>
</html>