______________________________________________ From: Harish Kumar Rayasam Sent: Thursday, January 06, 2011 9:51 AM To: 'corrections@qos.ch' Subject: FW: Db access with jndi connection source not workiing Is logback access only for tomcat and jetty servers is there not any built in support for integrating weblogic server with logback access ______________________________________________ From: Harish Kumar Rayasam Sent: Thursday, January 06, 2011 9:45 AM To: 'logback-user@qos.ch'; 'logback-user-owner@qos.ch' Subject: Db access with jndi connection source not workiing Hi, 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 Logback.xml(appender configuration) <appender name="DB" class="ch.qos.logback.classic.db.DBAppender"> <connectionSource class="ch.qos.logback.core.db.JNDIConnectionSource"> <param name="jndiLocation" value="saa_datasource" /> <param name="user" value="weblogic" /> <param name="password" value="weblogic" /> </connectionSource> </appender> <appender name="DB1" class="ch.qos.logback.access.db.DBAppender"> <connectionSource class="ch.qos.logback.core.db.JNDIConnectionSource"> <param name="jndiLocation" value="saa_datasource" /> <param name="user" value="weblogic" /> <param name="password" value="weblogic" /> </connectionSource> <insertHeaders>true</insertHeaders> </appender> Datasource name :saa_datasource Weblogic username:weblogic Weblogic password:weblogic I am also using jndi.properties java.naming.provider.url=t3://localhost:7001 java.naming.factory.initial=weblogic.jndi.WLInitialContextFactory 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) 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 08:31:10,613 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB] 08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - Driver name=Oracle JDBC driver 08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - Driver version=11.1.0.6.0-Production+ 08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@262730 - supportsGetGeneratedKeys=true 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 08:31:10,800 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [DB1] 08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - Driver name=Oracle JDBC driver 08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - Driver version=11.1.0.6.0-Production+ 08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource@d6e551 - supportsGetGeneratedKeys=true 08:31:10,925 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa] to false 08:31:10,925 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa level set to TRACE 08:31:10,925 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[com.sia.saa] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[com.sia.saa] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[com.sia.saa] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SAACOMPLETELOGS] to Logger[com.sia.saa] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.filter.PerfLoggingFil o true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.filter.PerfLoggingFilter level set to TRACE 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.fil rfLoggingFilter] 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 ingFilter] 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 gingFilter] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.util.PerfLoggingFlowE onListener] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.util.PerfLoggingFlowExecutionListener level set to T 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.uti LoggingFlowExecutionListener] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common.logging.SIALoggingInt or] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common.logging.SIALoggingInterceptor level set to TRACE 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PERFLOGS] to Logger[com.sia.saa.common.log IALoggingInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.krisflyer] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.krisflyer level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [KRISFLYER] to Logger[com.sia.saa.krisflyer 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.booking] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.booking level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [BOOKING] to Logger[com.sia.saa.booking] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.misc] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.misc level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [MISC] to Logger[com.sia.saa.misc] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.corporate] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.corporate level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [CORPORATE] to Logger[com.sia.saa.corporate 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.common] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.common level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [COMMON] to Logger[com.sia.saa.common] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.promotions] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.promotions level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PROMOTIONS] to Logger[com.sia.saa.promotio 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.admin] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.admin level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [ADMIN] to Logger[com.sia.saa.admin] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.sia.saa.payment] to true 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.sia.saa.payment level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PAYMENT] to Logger[com.sia.saa.payment] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org level set to ERROR 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[org] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[org] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.hibernate] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.hibernate level set to INFO 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[org.hibernate] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.springframework] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.springframework level set to INFO 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[org.springframework] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [net.sf.ehcache] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - net.sf.ehcache level set to INFO 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[net.sf.ehcache] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [com.googlecode.ehcache] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - com.googlecode.ehcache level set to DEBUG 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[com.googlecode.ehcache] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.cxf.interceptor.LoggingInInte r] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.cxf.interceptor.LoggingInInterceptor level set to INFO 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org.apache.cxf.interceptor.L InInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[org.apache.cxf. eptor.LoggingInInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.cxf.interceptor.LoggingOutInt or] to false 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.cxf.interceptor.LoggingOutInterceptor level set to INFO 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[org.apache.cxf.interceptor.L OutInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[org.apache.cxf.interceptor. gOutInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[org.apache.cxf. eptor.LoggingOutInterceptor] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to TRACE 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [BOOKING] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [COMMON] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [MISC] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [KRISFLYER] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [ADMIN] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [PAYMENT] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [EXCEPTION] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SAACOMPLETELOGS] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SOAPENVELOPLOGS] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [SYSTEM] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [DB1] to Logger[ROOT] 08:31:10,940 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration. <Jan 6, 2011 8:31:53 AM IST> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Serv ccessfully.> <Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN> <Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING> <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 7.0.0.1> <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 p, http.> <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 nmp, http.> <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> <Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000331> <Started WebLogic Admin Server "AdminServer" for domain "harishdomaintrunk" g in Development Mode> <Jan 6, 2011 8:51:30 AM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING> Can any one tell me the issue why it is not working With regards... V.S.N.HARISH.RAYASAM