MyBatis 错误日志检索

最新推荐文章于 2024-09-23 08:45:55 发布

转载最新推荐文章于 2024-09-23 08:45:55 发布 · 290 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/olmlo/p/5454037.html

文章标签：

本文介绍了一种SQL执行错误的情况，具体表现为未知字段错误，并提供了具体的SQL语句和可能涉及的XML配置文件。通过分析错误日志，可以帮助读者理解并解决类似的SQL语法问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

当怀疑是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