[logback-user] Db access with jndi connection source not workiing
Harish Kumar Rayasam
hrayasam at sapient.com
Thu Jan 6 05:15:28 CET 2011
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 at 262730 - Driver name=Oracle JDBC driver
08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource at 262730 - Driver version=11.1.0.6.0-Production+
08:31:10,784 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource at 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 at d6e551 - Driver name=Oracle JDBC driver
08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource at d6e551 - Driver version=11.1.0.6.0-Production+
08:31:10,925 |-INFO in ch.qos.logback.core.db.JNDIConnectionSource at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://qos.ch/pipermail/logback-user/attachments/20110106/00ee5bf9/attachment-0001.html>
More information about the Logback-user
mailing list