Caused by: java.sql.SQLSyntaxErrorException: Unknown column name in field list

最新推荐文章于 2025-10-01 05:30:00 发布
原创 最新推荐文章于 2025-10-01 05:30:00 发布 · 3.4w 阅读 · 3 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了解决MyBatis开发过程中遇到的SQL语法错误的具体步骤。主要针对未知列名导致的问题，提供了检查XML配置文件、实体类及数据库字段的一系列方法。

开发中查询时  出现这种错误      Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'      

解决方法： mybatis 的xml文件中出现了与数据库表中的字段不匹配。没有匹配上，也就是mybatis没有找到某字段对应的映射关系，请大家仔细认真排查，xml文件或实体类，或数据库字段。提醒大家此情况在开发中注意！耐心解决。

 

【异常】MyBatis提示Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘forbid_time‘ in ‘field list‘
本本本添哥
04-28 1467
在ScenariosConfigMapper中定义了MySQL某表的forbid_time字段，但是在数据库中找不到就会报如上错误。直接在MySQL某表中添加forbid_time字段即可。
【异常】MySQL提示`java.sql.SQLSyntaxErrorException: Unknown column ‘id‘ in ‘field list‘
本本本添哥
05-16 298
文章摘要： 在Spring框架中执行SQL查询时，程序报错java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'field list'，表明查询的omo_pages表中不存在id列。可能原因包括表结构与查询语句不匹配、数据库与代码版本不一致、字段名拼写错误或连接了错误的数据库。解决方法包括：确认表结构、修改SQL查询语句、检查数据库连接配置以及同步数据库和代码。例如，若实际主键字段为page_id，需将查询语句中的id替换为page_id。若问题
java 数据可连接失败抛出异常_spring和mybatis结合，数据库连接池抛出异常
weixin_39895481的博客
02-16 380
org.mybatis.spring.MyBatisSystemException:nestedexceptionisorg.apache.ibatis.exceptions.PersistenceException:###Errorupdatingdatabase.Cause:org.springframework.jdbc.CannotGetJdbcConnectionEx...
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘*****‘
FZD的博客
10-01 992
从错误信息中的 SQL 语句可以看到，查询时尝试获取 `user_photo_url` 字段： ```sql SELECT ..., user_photo_url, ... FROM user WHERE ... ``` 但数据库提示 `Unknown column 'user_photo_url' in 'field list'`，说明这个字段**并未实际添加到数据库表中**。``` 如果结果中没有 `user_photo_url`，说明之前的 `ALTER TABLE` 语句未成功执行。
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'
A_Little_xu的博客
04-08 2560
Caused by: java.sql.SQLSyntaxErrorException: Unknown column ‘name’ in ‘field list’ 测试出现错误，我自己今天往数据库插入数据时发现一直报这个错误，数据库数据插不进去，找了半天才发现是数据库表字段有空格，把空格取消就行了。这个是我自己建数据库的空格问题，就是这个空格导致我插不如数据。如果有空格就会报上面这个错误，解决...
Cause: java.sql.SQLSyntaxErrorException: Unknown column
qq_35930739的博客
12-20 1万+
本地数据库版本是：8.0.30。线上数据库版本是：8.0.29。
java.sql.SQLSyntaxErrorException问题常见解决方案：比如Table xxx doesn‘t exist；Unknown column ‘xxx‘ in ‘where...
热门推荐
念兮为美
08-15 1万+
解决 bad SQL grammar [xxx]; nested exception is java.sql.SQLSyntaxErrorException: 1. Table xxx doesn't exist 2. You have an error in your SQL syntax；3. Unknown column x in x 4.Unknown column 'xxx' in 'where clause'。
springboot 集成activiti （Unknown column ‘VERSION_‘ in ‘field list‘）
weixin_44076260的博客
05-12 3385
目录 1.具体的错误 2.如果你的activiti-spring-boot-starter是7.1.0.M5的话，多半就会报错，很明显sql少字段，这个应该是一个官方的BUG，解决办法如下： 2.1.在 act_re_deployment中加两个字段就好了： VERSION_和 PROJECT_RELEASE_VERSION_ 然后重新运行就ok了 2.2.修改activiti-spring-boot-starter的版本，改为7.0.0.Beta2的 1.具体的错误 j...
OpenJDK 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' ### The error may exist in com/swt/spring_ssmp/dao/BookDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,type,name,descriptions FROM book WHERE id=? ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' ; bad SQL grammar [] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439) at jdk.proxy2/jdk.proxy2.$Proxy66.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:87) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at jdk.proxy2/jdk.proxy2.$Proxy69.selectById(Unknown Source) at com.swt.spring_ssmp.BookDaoTest.TestGetByID(BookDaoTest.java:20) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425) ... 10 more
06-14
具体错误信息：`Unknowncolumn'descriptions'in'fieldlist'`原因分析：这个异常通常发生在Spring执行SQL语句时，SQL语法与数据库不匹配。具体错误信息表明，在SQL语句中引用了一个不存在的列`descriptions`。解决...
==> Parameters: 11:04:30.956 [main] ERROR druid.sql.Statement - [statementLogError,148] - {conn-10005, pstmt-20005} execute error. select id,product_id,central_id, product_name, product_code, create_by, create_time, update_by, update_time, deleted, comp_id,central_id, ip_address,ip_port,tray_weight,database_type from cct_production_line where deleted = 0 java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy295.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy293.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) at com.sun.proxy.$Proxy146.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy167.selectProductionLineList(Unknown Source) at com.erp.product.service.impl.BasicDataServiceImpl.productionLineRedis(BasicDataServiceImpl.java:68) at com.erp.product.service.impl.BasicDataServiceImpl.basicDataRead(BasicDataServiceImpl.java:51) at com.erp.product.init.ClientInit.run(ClientInit.java:39) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749) at org.springframework.boot.SpringApplication.run(SpringApplication.java:314) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.erp.product.ErpProductApplication.main(ErpProductApplication.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a8e6e89] 11:04:31.244 [main] INFO c.a.c.n.r.NacosServiceRegistry - [deregister,95] - De-registering from Nacos Server now... 11:04:31.252 [main] INFO c.a.c.n.r.NacosServiceRegistry - [deregister,115] - De-registration finished. 11:04:31.685 [main] INFO c.b.d.d.DynamicRoutingDataSource - [destroy,211] - dynamic-datasource start closing .... 11:04:31.702 [main] INFO c.a.d.p.DruidDataSource - [close,2138] - {dataSource-1} closing ... 11:04:31.711 [main] INFO c.a.d.p.DruidDataSource - [close,2211] - {dataSource-1} closed 11:04:31.712 [main] INFO c.b.d.d.DynamicRoutingDataSource - [destroy,215] - dynamic-datasource all closed success,bye 11:04:31.796 [main] ERROR o.s.b.SpringApplication - [reportFailure,821] - Application run failed java.lang.IllegalStateException: Failed to execute ApplicationRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749) at org.springframework.boot.SpringApplication.run(SpringApplication.java:314) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.erp.product.ErpProductApplication.main(ErpProductApplication.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) Caused by: org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' ### The error may exist in class path resource [mapper/product/ProductionLineMapper.xml] ### The error may involve com.erp.product.mapper.ProductionLineMapper.selectProductionLineList-Inline ### The error occurred while setting parameters ### SQL: select id,product_id,central_id, product_name, product_code, create_by, create_time, update_by, update_time, deleted, comp_id,central_id, ip_address,ip_port,tray_weight,database_type from cct_production_line where deleted = 0 ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy146.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy167.selectProductionLineList(Unknown Source) at com.erp.product.service.impl.BasicDataServiceImpl.productionLineRedis(BasicDataServiceImpl.java:68) at com.erp.product.service.impl.BasicDataServiceImpl.basicDataRead(BasicDataServiceImpl.java:51) at com.erp.product.init.ClientInit.run(ClientInit.java:39) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759) ... 13 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy295.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy293.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 24 common frames omitted怎么解决这个错误
最新发布
10-18
我们面对的问题：Java程序执行SQL查询时报错'Unknown column 'product_id' in 'field list'。 这个错误表示在数据库表中不存在名为'product_id'的列。 根据引用[1][2][3][4]中的信息，我们可以总结出以下常见原因...
java.sql.SQLSyntaxErrorException: Unknown column name ‘ in ‘field list‘
qq_52563451的博客
07-05 2182
java.sql.SQLSyntaxErrorException: Unknown column name ‘ in ‘field list‘
Caused by: java.sql.SQLSyntaxErrorException: Unknown column ‘xxx‘ in ‘field list‘
m0_64284147的博客
11-19 3871
1、报错 2、不懂英文的可以用百度翻译、有道翻译、QQ在线翻译（快捷键Ctrl+Alt+O）等工具帮助翻译 大致意思是你写的sql语句的字段在数据库列表里没找到 3、原因 sql语句里的字段和数据库里的字段名字不匹配，有可能是你sql语句里的字段名写错了或写多了 4、解决办法 把你sql语句里的字段名改成与数据库里的字段名同名或把你sql语句里的字段名删了 ...
【问题解决】java.sql.SQLSyntaxErrorException: Unknown column ‘xxx‘ in ‘field list‘
JohnMin的博客
03-30 1万+
报错信息： Caused by: java.sql.SQLSyntaxEnnonException Create breakpoint : Unknown column 'xxx' in 'field list' Caused by: java.sql.SQLSyntaxEnnonException Create breakpoint : Unknown column ‘xxx’ in ‘field list’ 原因： sql语句里的字段和数据库里的字段名字不匹配，有可能是sql语句里的字段名写错了或写多
若依 Error querying database. Cause: java.sql.SQLSyntaxErrorException:
weixin_54048131的博客
07-29 4181
原因:Java . SQL . sqlsyntaxerrorexception:“字段列表”中的未知列“TPL _ web _ type”# # #错误可能存在于URL[jar:file:/home/my project/ruoyi-Java/ruoyi-admin . jar！嵌套异常是Java . SQL . sqlsyntaxerrorexception:“字段列表”中的未知列“tpl_web_type”
mybatisplus踩坑：Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column ....
君临天下tjm的博客
02-23 3311
【代码】mybatisplus踩坑：Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column ....
mybatis报错： Unknown column ‘name‘ in ‘field list‘
qq_45404035的博客
07-27 4685
org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'name' in 'field list' ### The error may involve com.itheima.dao.UserDao.updateUser-Inline ##..
评论 8
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值