Oracle 11g uses DML Error Logging to avoid bulk insert failure
Use DML Error Logging to avoid bulk insert failureIf an error occurs when an insert statement with a subquery is used to load data. the system terminates the statement and rolls back the entire operation. this operation consumes a lot of time and resources. if the insert statement is used, DML Error Logging
Reprint: http://www.cnblogs.com/goodhacker/p/3355660.htmlThe log system in the Python standard library is supported from Python2.3. As long as import logging This module can be used. If you want to Develop a log system, you need to output the log to the console and write to the log file, as long as you use:1ImportLogging23#Create a Logger4 Logger = Logging.getlogger (‘MyLogger‘)5Logger.setlevel (logging
Log (Logging) enables us to debug and track the behavior and state of an application at any time. Logging is an integral part of any larger application, so there are already a number of Third-party logging tools that eliminate the developer's own authoring of logging APIs. In fact, even the JDK has a constructed
--Logging mode (LOGGING, FORCE LOGGING, nologging)
--==================================================
First, logging mode (LOGGING, FORCE LOGGING, nologging)
1. Meaning of the three
LOGG
Recently wrote a crawler system, need to use the Python logging module, so they learned a bit.
The log system in the Python standard library is supported from Python2.3. As long as import logging This module can be used. If you want to develop a log system, you need to output the log to the console and write to the log file, as long as you use:
The code is as follows:
Import
1. Logging module# Python's logging module provides a standard log interface through which you can store logs in various formats, logging logs can be divided into # Debug (), info (), warning (), error () and critical () 5 levels # Level when it's used# DEBUG detailed information, typically of interest when diagnosing problem s.# INFO Confirmation that things is
Simple to use#!/usr/local/bin/python# -*- coding:utf-8 -*-import logginglogging.debug(‘debug message‘)logging.info(‘info message‘)logging.warn(‘warn message‘)logging.error(‘error message‘)logging.critical(‘critical message‘) Output:
WARNING:root:warn messageERROR:root:error messageCRITICAL:root:critical message
By default, the logging module prints the log to the screen (stdout) with a log level of warning (that is, only log information
Learn a new technique or language, we must first learn how to adapt to this new technology, which in the adaptation process, we have to learn how to debug the program and play the corresponding log information, is called "as long as the log is good, no bugs can not solve", in our well-known information technology, The Log4xxx series, as well as the Android.util.Log packages for Android apps, are all for developers to get a better log information service. In the language of Python, we can also pl
Many programs need to record logs, and the information contained in the logs has normal program access logs, and may also have errors, warnings, and other information output, the logging module of python provides a standard log interface. you can store logs in various formats. logging logs can be classified into debug, info, warning, error, and critical, next, let's take a look at how to use many programs t
The night is lazy, directly moved bricks.
1. Simply print the log to the screen
Import loggingLogging.debug (' This are debug message ')Logging.info (' This is info ')Logging.warning (' This are warning message ')Print on screen:WARNING:root:This is WARNING message
By default, logging prints the log to the screen with a log level of warning;The log level size relationship is: CRITICAL > ERROR > WARNING > INFO > DEBUG > NOTSET, a
Many programmers have the need to log, and the log contains information that has normal program access logs, there may be errors, warnings and other information output, Python logging module provides a standard log interface, you can store a variety of logs through it, you can store various forms of log , the logging log can be divided into five levels: Debug (), info (), warning (), error (), and Critical
For ease of debugging, the python logging module is encapsulated to support simultaneous output to the console and file, and log file rollback.(1) myloggingconfig. py
View code
# -*-Coding: UTF-8 -*- ''' Created on 2011-8-24Main purpose:PairProgramGeneral configuration of the loggong mode used in@ Author: jerrykwan ''' Import Logging Import Logging.
The recent writing of a reptile system required the use of Python's logging module, so I learned it.The log system in the Python standard library is supported from Python2.3. As long as the import logging this module can be used. If you want to develop a log system, both output the log to the console and write to the log file, as long as this is used:
Copy Code code as follows:
Import
python logging modules can be confusing placesfind some interesting phenomena by seeing the code of the Python logging module:1. The logging object is actually a tree structure, and each created logging object is the child node of the root logging object. When constructing
Make sure your Python version > Python 2.3 1 from a small case:Cat howto_logging.py #coding=utf8# file name: howto_logging# this file shows how to use logging# made by vasks, email:[emailprotected]import logging# 创建一个logger,级别:DEBUGlogger = logging.getLogger(‘Err_Logger‘)logger.setLevel(logging.DEBUG)# 创建一个handler,用于写入日志文件fh = logging.FileHandler(‘err.log‘)fh.setLevel(logging.DEBUG)# 再创建一个handler,用于输出到控制
Many programs have logging requirements, and the log contains information that has normal program access logs and may have errors, warnings and other information output, Python's logging module provides a standard log interface through which you can store logs in various formats, log level level: critical > Error > Warning > Info > DebugSee what each log level means:Simply tell the log to print to the scree
#!/usr/bin/env python# Encoding:utf-8import logging# defines the handler output format formatter=logging. The Formatter ('% (asctime) s--% (name) s--% (filename) s--% (message) s ') #创建一个handler to write to the log file, outputting only log fh=logging above the debug level. The Filehandler (' Test.log ') fh.setformatter (formatter) #再创建一个handler for output to the
1. Simply print the log to the screen
importlogginglogging.debug(‘This is debug message‘)logging.info(‘This is info message‘)logging.warning(‘This is warning message‘)屏幕上打印:WARNING:root:This is warning message
By default, logging prints the log to the screen with a log level of warning;Log level size relationships are: CRITICAL > ERROR > WARNING > INFO > DEBUG > NOTSET, and of course you can define the log level yourself.2.
1. Simple to use#!/usr/local/bin/python# -*- coding:utf-8 -*-import logginglogging.debug(‘debug message‘)logging.info(‘info message‘)logging.warn(‘warn message‘)logging.error(‘error message‘)logging.critical(‘critical message‘) Output:
WARNING:root:warn messageERROR:root:error messageCRITICAL:root:critical message
By default, the logging module prints the log to the screen (stdout) with a log level of warning (that is, only log informati
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.