How to print Log4j java sql logger

Question

I want to use log4j for java and sql. i want to print the java and sql logs without using "logger.debug("log4j logger")" in my class.

Below are the class and log4j properties used

package com.log4j;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
public class LogTest {

public static void main(String[] args) throws Exception{
      final  Logger logger = Logger.getLogger(LogTest.class);
      PropertyConfigurator.configure("log4j.properties");
    try {
        Class.forName("oracle.jdbc.OracleDriver");
        Connection   conn = DriverManager.getConnection("XXX", "YYY", "ZZZ");          
       String inserQuery = "insert into table1 (name,id) values (?,?)";
       PreparedStatement prestat = conn.prepareStatement(inserQuery);
       prestat.setString(1, "Test");
       prestat.setString(2, "2");
       prestat.executeUpdate();
    }
    catch (Exception ex)
    {
        System.out.println("Exception: " + ex.getMessage() + "");

    }
}

}

Below is the log4j properties

log4j.rootLogger=DEBUG,CA
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.appender.CA=org.apache.log4j.ConsoleAppender
log4j.appender.CA.layout=org.apache.log4j.PatternLayout
log4j.appender.CA.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n

Please advise.

Any help will be appreciated

Thanks

Saying you want to use log4j without using logger.debug() is like saying you want to use a gun without using any bullets. I suppose there are many other methods to log with, logger.trace() and logger.info() but you haven't made your reason for not using debug clear. Having System.out.println() in here as well is like adding a bow and arrow. Please explain WHY you don't want to use logger.debug() — candied_orange, Nov 04 '14 at 04:54
SQL statements have to print like below without using logger.debug() and by enabling it in the log4j properties. log4j.logger.java.sql=DEBUG log4j.logger.java.sql.ResultSet=DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG — Nisha, Nov 05 '14 at 02:43
Below is the sql logs ,DEBUG [main] - {conn-100003} Connection DEBUG [main] - {conn-100003} Preparing Statement: INSERT INTO USERINFO (ID,NAME,EMAIL,PASSWORD,STATUS) VALUES(?,?,?,?,?); DEBUG [main] - {pstm-100004} Executing Statement: INSERT INTO USERINFO (ID,NAME,EMAIL,PASSWORD,STATUS) VALUES(?,?,?,?,?); — Nisha, Nov 05 '14 at 02:43

score 3 · Accepted Answer · answered Nov 04 '14 at 05:25

3

Its like u created a variable which is never used then why create it, it would be better if you use

logger.error("Exception: " + ex.getMessage() + "");

instead of

System.out.println("Exception: " + ex.getMessage() + "");

answered Nov 04 '14 at 05:25

Naresh kumar

1,069
1
7
21

SQL statements have to print like below without using logger.debug() and by enabling it in the log4j properties. log4j.logger.java.sql=DEBUG log4j.logger.java.sql.ResultSet=DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG – Nisha Nov 05 '14 at 02:37
Below is the sql logs ,DEBUG [main] - {conn-100003} Connection DEBUG [main] - {conn-100003} Preparing Statement: INSERT INTO USERINFO (ID,NAME,EMAIL,PASSWORD,STATUS) VALUES(?,?,?,?,?); DEBUG [main] - {pstm-100004} Executing Statement: INSERT INTO USERINFO (ID,NAME,EMAIL,PASSWORD,STATUS) VALUES(?,?,?,?,?); – Nisha Nov 05 '14 at 02:41
1

jdbc library will print this log any how, you dont have to do anything for this. – Naresh kumar Nov 05 '14 at 04:54

score 1 · Answer 2 · answered Nov 04 '14 at 05:18

If java.sql has a logger interface it will probably be java.util.logging rather than LOG4J or SLF4J. I've looked at a few of the java.sql.* classes and it looks as if they have no logging at all. Your scheme would have worked had any of these classes used 4J logging but they don't so you'll just have to put the logging in your code.

Paul Vargas · Answer 3 · 2014-11-06T16:44:05.020

0

If you want to print the SQL sent to the database, you might want to use log4jdbc-log4j2. This acts as a proxy:

Proxy

If you use log4j.jar, you will require add slf4j-api.jar and slf4j-log4j12.jar.

log4jdbc configuration

Notes

* Images were obtained from JPA - Tracer les requêtes SQL avec Log4jdbc

edited Nov 06 '14 at 16:44

answered Nov 06 '14 at 03:47

Paul Vargas

41,222
15
102
148

How to print Log4j java sql logger

3 Answers3