Examples of JDBCAppender

org.apache.log4j.varia.JDBCAppender
This JDBCAppender is intended to provide a convinent base clas or default class for sending log messages to a database. Each append call adds to an ArrayList buffer. When the buffer is filled (set by the BUFFER_OPTION or setBufferSize(int buffer), default is 1) each log event is placed in a sql statement (configurable) and executed. BufferSize, db URL, User, & Password are configurable options in the standard Log4J methods. DB driver is also configurable -- setting the DRIVER_OPTION automaticaly loads the driver The SQL_OPTION sets the SQL statement to be used for logging -- by default all the conversion patterns in PatternLayout can be used inside of the statement. (see the test cases for examples) if a layout is explicitely attached it's output will replace the first instance of "%m" in the SQL statement. Overriding the getSQL method allows more explicit control of the statement used for logging. For use as a base class: Override executeSQL(String sql) to modify connection/statement behavior The default implementation creates a new connection from the Driver for every statement. Override getSQL(LoggingEvent event) to produce specialized or dynamic statements The default uses the sql option value @author : Kevin Steppe (ksteppe@pacbell.net)
org.apache.turbine.services.logging.jdbc.JDBCAppender
The JDBCAppender, writes messages into a database. The JDBCAppender is configurable at runtime by setting options in two alternatives : @author Thomas Fenner @author Jason van Zyl

Examples of org.apache.log4j.varia.JDBCAppender

        }




     Category rootLog = Category.getRoot();
        Layout layout = new PatternLayout("%p [%t] %c - %m%n");
        JDBCAppender appender = new JDBCAppender();
        appender.setLayout(layout);
        appender.setOption(JDBCAppender.URL_OPTION, "jdbc:odbc:someDB");




        appender.setOption(JDBCAppender.USER_OPTION, "auser");
        appender.setOption(JDBCAppender.PASSWORD_OPTION, "thepassword");






        rootLog.addAppender(appender);




        try {
            Category log = Category.getInstance("main");
            log.debug("Debug 1");
            Thread.sleep(500);
            log.info("info 1");
            Thread.sleep(500);
            log.warn("warn 1");
            Thread.sleep(500);
            log.error("error 1");
            Thread.sleep(500);
            log.fatal("fatal 1");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "5");
            log.debug("Debug 2");
            Thread.sleep(500);
            log.info("info 2");
            Thread.sleep(500);
            log.warn("warn 2");
            Thread.sleep(500);
            log.error("error 2");
            Thread.sleep(500);
            log.fatal("fatal 2");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "2");
            appender.setThreshold(Priority.WARN);
            log.debug("Debug 3");
            Thread.sleep(500);
            log.info("info 3");
            Thread.sleep(500);
            log.warn("warn 3");

View Full Code Here

Examples of org.apache.log4j.varia.JDBCAppender

        }




     Category rootLog = Category.getRoot();
        Layout layout = new PatternLayout("%p [%t] %c - %m%n");
        JDBCAppender appender = new JDBCAppender();
        appender.setLayout(layout);
        appender.setOption(JDBCAppender.URL_OPTION, "jdbc:odbc:someDB");




        appender.setOption(JDBCAppender.USER_OPTION, "auser");
        appender.setOption(JDBCAppender.PASSWORD_OPTION, "thepassword");






        rootLog.addAppender(appender);




        try {
            Category log = Category.getInstance("main");
            log.debug("Debug 1");
            Thread.sleep(500);
            log.info("info 1");
            Thread.sleep(500);
            log.warn("warn 1");
            Thread.sleep(500);
            log.error("error 1");
            Thread.sleep(500);
            log.fatal("fatal 1");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "5");
            log.debug("Debug 2");
            Thread.sleep(500);
            log.info("info 2");
            Thread.sleep(500);
            log.warn("warn 2");
            Thread.sleep(500);
            log.error("error 2");
            Thread.sleep(500);
            log.fatal("fatal 2");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "2");
            appender.setThreshold(Priority.WARN);
            log.debug("Debug 3");
            Thread.sleep(500);
            log.info("info 3");
            Thread.sleep(500);
            log.warn("warn 3");

View Full Code Here

Examples of org.apache.log4j.varia.JDBCAppender

        }




     Category rootLog = Category.getRoot();
        Layout layout = new PatternLayout("%p [%t] %c - %m%n");
        JDBCAppender appender = new JDBCAppender();
        appender.setLayout(layout);
        appender.setOption(JDBCAppender.URL_OPTION, "jdbc:odbc:someDB");




        appender.setOption(JDBCAppender.USER_OPTION, "auser");
        appender.setOption(JDBCAppender.PASSWORD_OPTION, "thepassword");






        rootLog.addAppender(appender);




        try {
            Category log = Category.getInstance("main");
            log.debug("Debug 1");
            Thread.sleep(500);
            log.info("info 1");
            Thread.sleep(500);
            log.warn("warn 1");
            Thread.sleep(500);
            log.error("error 1");
            Thread.sleep(500);
            log.fatal("fatal 1");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "5");
            log.debug("Debug 2");
            Thread.sleep(500);
            log.info("info 2");
            Thread.sleep(500);
            log.warn("warn 2");
            Thread.sleep(500);
            log.error("error 2");
            Thread.sleep(500);
            log.fatal("fatal 2");
            Thread.sleep(500);




            appender.setOption(JDBCAppender.BUFFER_OPTION, "2");
            appender.setThreshold(Priority.WARN);
            log.debug("Debug 3");
            Thread.sleep(500);
            log.info("info 3");
            Thread.sleep(500);
            log.warn("warn 3");

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

Examples of org.apache.turbine.services.logging.jdbc.JDBCAppender

        if (dbLogger == null || dbLogger.trim().equals(""))
        {
            return;
        }


        JDBCAppender appender = new JDBCAppender();
        appender.setOption(JDBCAppender.LOGGER_CLASS_OPTION, dbLogger);


        /*
         * This sucks, but we are stuck with setOption(String, String).
         * I want people to be able to specify their own db logger
         * implementation and the options without having to touch
         * anything else, but log4j doesn't really make it that easy.
         */
        //appender.setOption(JDBCAppender.LOGGER_OPTION, "pool:" + dbPool);
        appender.setLayout(layout);
        appender.activateOptions();
        logger.addAppender(appender);
    }

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.