MyBatis 错误日志检索

当怀疑是sql语句执行存在错误时，可以用一下关键字检索日志文件：

检索关键字：

Cause: 

SQLException 

 

 

sql原始报错内容：

• [DEBUG] [2016-05-03 09:37:05 908] [JSF-BZ-22000-9-T-1] (SQLErrorCodeSQLExceptionTranslator.java:399) Translating SQLException with SQL state '42S22', error code '1054', message [Unknown column 'warehouse_no' in 'field list']; SQL was [] for task [
• ### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'warehouse_no' in 'field list'
• ### The error may exist in sqlmap/Carrier.xml
• ### The error may involve com.jd.basic.dao.CarrierDao.selectEntryList-Inline
• ### The error occurred while setting parameters
• ### SQL: SELECT sysno,carrier_id AS carrierId,carrier_name AS carrierName,dc_id AS dcId,dc_name AS dcName,org_id AS orgId,org_name AS orgName,contact_name AS contactName,contact_phone AS contactPhone,carrier_type AS carrierType,carrier_status AS carrierStatus,carrier_integrity AS carrierIntegrity,sync_source AS syncSource,yn,ts,create_time AS createTime,create_pin AS createPin,update_pin AS updatePin,warehouse_no AS warehouseNo FROM carrier LIMIT ?,?
• ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'warehouse_no' in 'field list'
• ]

转载于:https://www.cnblogs.com/olmlo/p/5454037.html