標籤：
當懷疑是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‘
- ]
MyBatis 錯誤記錄檔檢索
