How to Enable SQL Statement Logging in JDBC Applications?

How to Enable Logging for SQL Statements in JDBC

Addressing Driver Exception

In your code, you encountered an exception related to oracle.dms.console.DMSConsole. This exception occurs when the Oracle DMS extension library (ojdbc6dms.jar) is present in the classpath. To resolve this, remove or exclude the ojdbc6dms.jar file from the build path or classpath.

Logging Framework Implementation

While log4jdbc is a popular logging framework, there are numerous options available. These frameworks offer various levels of control over logging behavior, such as filtering, formatting, and customization.

Here's an example using log4jdbc:

import net.sf.log4jdbc.DriverSpy;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

public class LoggingExample {

    public static void main(String[] args) throws SQLException {
        // Set the JDBC driver class and URL
        String jdbcDriverClass = "net.sf.log4jdbc.DriverSpy";
        String jdbcUrl = "jdbc:log4jdbc:oracle:thin:@host:port:database";

        // Register the logging driver class
        DriverManager.registerDriver(new DriverSpy());

        // Create a connection to the database
        Connection connection = DriverManager.getConnection(jdbcUrl);

        // Enable logging for internal JDBC calls and statements
        connection.setLogWriter(new java.io.PrintWriter(System.err));

        // Execute a SQL statement
        connection.createStatement().execute("SELECT * FROM table_name");

        // Close the connection
        connection.close();
    }
}

Configuration

Configure your chosen logging framework (e.g., log4j, logback) according to the documentation provided by the framework. This typically involves setting up loggers and appenders to control the output format and location.

Log Levels

Determine which log levels you need to enable. Common choices are:

• TRACE: Detailed information about internal operations
• DEBUG: Detailed information, but less verbose than TRACE
• INFO: High-level information about events
• WARN: Warning messages indicating potential problems
• ERROR: Error messages indicating failures

Output Destination

Specify the output destination for the logs. It can be a console, file, database, or any other supported destination based on the logging framework you're using.

The above is the detailed content of How to Enable SQL Statement Logging in JDBC Applications?. For more information, please follow other related articles on the PHP Chinese website!