java.sql.SQLSyntaxErrorException: Unknown column 'tiger' in 'field list'

最新推荐文章于 2023-11-06 21:12:23 发布

CWQ__xz__

最新推荐文章于 2023-11-06 21:12:23 发布

阅读量887

点赞数

分类专栏： mybatis 错误处理原创程序博客文章标签： mysql

本文链接：https://blog.youkuaiyun.com/CWQ__xz__/article/details/105280229

版权

原创程序博客同时被 3 个专栏收录

13 篇文章

订阅专栏

mybatis

11 篇文章

订阅专栏

错误处理

2 篇文章

订阅专栏

本文详细解析了使用MyBatis进行批量插入操作时出现的SQL语法错误，具体为未知列名导致的问题，并提供了正确的XML映射文件配置示例。

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

org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 'tiger' in 'field list'
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into employee(name,gender,email,d_id) values                         (tiger,M,tiger.com,1)          ,               (lion,M,lion.com,2)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'tiger' in 'field list'

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy7.addEmp(Unknown Source)
	at com.casey.mybatis.test.mybatisTest.DynamicSqlInsertTest(mybatisTest.java:308)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'tiger' in 'field list'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
	at com.sun.proxy.$Proxy10.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
	... 27 more


Process finished with exit code -1

错误原因： ( ${emp.name},$ {emp.gender}, ${emp.email},$ {emp.deptName.id})

 <insert id="addEmp">
        insert into employee(name,gender,email,d_id) values
        <foreach collection="list" item="emp" separator=",">
             (${emp.name},${emp.gender},${emp.email},${emp.deptName.id})
        </foreach>
    </insert>

改正： (#{emp.name},#{emp.gender},#{emp.email},#{emp.deptName.id})

<insert id="addEmp">
        insert into employee(name,gender,email,d_id) values
        <foreach collection="list" item="emp" separator=",">
             (#{emp.name},#{emp.gender},#{emp.email},#{emp.deptName.id})
        </foreach>
    </insert>