https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2314906#M85620 Hi, <BR />Please stick to one topic: <A href="https://community.talend.com/t5/Design-and-Development/Problem-Unable-to-write-log-to-database-using-log4j/td-p/59547" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/Problem-Unable-to-write-log-to-database-using-log4j/td-p/59547</A> <BR />Best regards <BR />Sabrina Wed, 08 Oct 2014 04:10:18 GMT Anonymous 2014-10-08T04:10:18Z https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2314905#M85619 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 (From C:\Talend\5.4.2\runtime\etc folder) 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 Wed, 01 Oct 2014 10:49:15 GMT https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2314905#M85619 Anonymous 2014-10-01T10:49:15Z https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2314906#M85620 Hi, <BR />Please stick to one topic: <A href="https://community.talend.com/t5/Design-and-Development/Problem-Unable-to-write-log-to-database-using-log4j/td-p/59547" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/Problem-Unable-to-write-log-to-database-using-log4j/td-p/59547</A> <BR />Best regards <BR />Sabrina Wed, 08 Oct 2014 04:10:18 GMT https://community.qlik.com/t5/Talend-Studio/Problem-Unable-to-write-log-to-database-using-log4j/m-p/2314906#M85620 Anonymous 2014-10-08T04:10:18Z