https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2312429#M83380 Hi,<BR />Are you using Service Locator server logs? Have you checked document&nbsp;<A href="https://help.talend.com/search/all?query=Logging" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:Logging</A>?<BR />Best regards<BR />Sabrina Wed, 08 Oct 2014 04:09:21 GMT Anonymous 2014-10-08T04:09:21Z https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2312428#M83379 Hi, <BR />I am able to get the log info written to a file (When I run my Talend job, I can see the info such as time, payload etc. in the text file) but I am unable get that info logged into my mssql database. <BR />I have a Logs database table: <BR />lLogKey (bigint, not null) <BR />dt (datetime, null) <BR />Logger (nvarchar(100), null) <BR />Lvl (nvarchar(100), null) <BR />Msg(nvarchar(max), null) <BR />AND <BR />I have created the DB database appender in my org.ops4j.pax.logging configuration file as shown below. <BR /># Root logger <BR />log4j.rootLogger=INFO, out, DB, osgi:VmLogAppender, osgi:eventloglistener <BR />log4j.throwableRenderer=org.apache.log4j.OsgiThrowableRenderer <BR /># CONSOLE appender not used by default <BR />log4j.appender.stdout=org.apache.log4j.ConsoleAppender <BR />log4j.appender.stdout.layout=org.apache.log4j.PatternLayout <BR />log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} | %-5.5p | %-16.16t | %-32.32C %4L | %X{bundle.id} - %X{bundle.name} - %X{bundle.version} | %m%n <BR /># File appender <BR />log4j.appender.out=org.apache.log4j.RollingFileAppender <BR />log4j.appender.out.layout=org.apache.log4j.PatternLayout <BR />log4j.appender.out.layout.ConversionPattern=%d{ABSOLUTE} | %-5.5p | %-16.16t | %-32.32C %4L | %X{bundle.id} - %X{bundle.name} - %X{bundle.version} | %m%n <BR />log4j.appender.out.file=${karaf.home}/log/mylog.log <BR />log4j.appender.out.append=true <BR />log4j.appender.out.maxFileSize=1MB <BR />log4j.appender.out.maxBackupIndex=10 <BR /># DB logging appender <BR />log4j.appender.DB=org.apache.log4j.jdbc.JDBCAppender <BR />log4j.appender.DB.URL=jdbc:sqlserver://testserver:1433;instanceName=testserver;databaseName=LogDB;schema=dbo <BR />log4j.appender.DB.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver <BR />log4j.appender.DB.user=TestUser <BR />log4j.appender.DB.password=TestPass <BR />log4j.appender.DB.layout=org.apache.log4j.PatternLayout <BR />log4j.appender.DB.layout.OutputHeader=false <BR />log4j.appender.DB.sql=INSERT INTO Logs (dt, Logger, Lvl, Msg) VALUES('%d','%C','%p','%m') <BR />Please advice me on how I can get my log info written to my database table using log4j - I greatly appreciate your help. <BR />Thanks Sat, 16 Nov 2024 11:29:10 GMT https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2312428#M83379 Anonymous 2024-11-16T11:29:10Z https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2312429#M83380 Hi,<BR />Are you using Service Locator server logs? Have you checked document&nbsp;<A href="https://help.talend.com/search/all?query=Logging" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:Logging</A>?<BR />Best regards<BR />Sabrina Wed, 08 Oct 2014 04:09:21 GMT https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2312429#M83380 Anonymous 2014-10-08T04:09:21Z