mySql批量更新失败报The error occurred while setting parameters

最新推荐文章于 2024-07-25 11:02:19 发布
最新推荐文章于 2024-07-25 11:02:19 发布
阅读量3.5k 收藏 4
点赞数 1
分类专栏： java exception
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_42255763/article/details/100150872
版权

mapper xml配置情况

  <update id="updateUserBatch" parameterType="java.util.List">
    <foreach collection="users" index="index" item="item" separator=";">
      update user
      set name = #{item.name,jdbcType=VARCHAR},
      age = #{item.age,jdbcType=INTEGER},
      address = #{item.address,jdbcType=VARCHAR},
      country = #{item.country,jdbcType=VARCHAR}
      where id = #{item.id,jdbcType=INTEGER}
    </foreach>
  </update>

测试java

package com.skindow;

import com.skindow.mapper.UserMapper;
import com.skindow.pojo.User;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.ArrayList;
import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class SkindowProviderApplicationTests {
	@Autowired
	UserMapper userMapper;
	@Test
	public void contextLoads() {
		List<User> list = new ArrayList<>(100);
		User user = null;
		for (int i = 0 ; i < 100 ; i++)
		{
			user = new User();
			user.setId(i);
			user.setAddress("武汉" + i);
			user.setAge(i);
			user.setCountry("中国");
			user.setName("skindow" + i);
			list.add(user);
			user = null;
		}
		int i = userMapper.updateUserBatch(list);
		log.info("总共批量更新了{}条用户信息",i);
	}

}

报错信息如下：

2019-08-30 09:35:03.309  INFO 16948 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2019-08-30 09:35:04.455  INFO 16948 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user
      set name = 'skindow1',
      age = 1,
      address = '武汉1' at line 8
### The error may involve com.skindow.mapper.UserMapper.updateUserBatch-Inline
### The error occurred while setting parameters
### SQL: update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?      ;        update user       set name = ?,       age = ?,       address = ?,       country = ?       where id = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user
      set name = 'skindow1',
      age = 1,
      address = '武汉1' at line 8
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user
      set name = 'skindow1',
      age = 1,
      address = '武汉1' at line 8

	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy69.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy70.updateUserBatch(Unknown Source)
	at com.skindow.SkindowProviderApplicationTests.contextLoads(SkindowProviderApplicationTests.java:36)
	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.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
	at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
	at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
	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.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
	at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:51)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user
      set name = 'skindow1',
      age = 1,
      address = '武汉1' at line 8
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	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.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 36 more

原因是mysql配置没有配置允许批量更新的属性，mysql默认是不允许批量更新的

&allowMultiQueries=true

在这里插入图片描述
加完我们在重新测试一下
在这里插入图片描述
ok 测试成功

skindow
关注
  • 1
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql学习小计2
nshk1031的博客
06-21 316
mysql学习小计
java 锁超时_数据库锁等待超时
weixin_42128393的博客
02-21 759
231.035 [pool-4-thread-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task.org.springframework.dao.CannotAcquireLockException:Error updating database. Cause: ...
MyBatis批量更新：报错The error occurred while setting parameters
最新发布
sinat_36891648的博客
07-25 434
MyBatis批量更新：报错The error occurred while setting parameters
The error occurred while setting parameters数据库查询时的设置异常
热门推荐
new_caicai的博客
04-01 2万+
项目场景： 进行数据库查询时报错，具体错误信息如下： Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' in field list is ambiguous The error may exist in com/xxx/workbench/dao/ActivityDao.xml The error may involv
The error occurred while setting parameters
weixin_43337555的博客
01-11 267
mybatis批量更新注意！！！ 加上allowMultiQueries=true
SSM The error occurred while setting parameters
尚未佩妥剑 转眼便江湖
04-26 1万+
最近用到了mybatis，对数据库进行处理，遇到了一个问题，The error occurred while setting parameters，后来发现问题的原因是，在写sql语句的时候，少加了一个and的问题。在使用mybatis还应该注意： （1）检查sql语句，最好的检查方法就是将sql语句复制到查询器中执行下 （2）检查Mapper接口，参数名一定对应 （3）检查字段是否出现sql关键...
5.7版本mysql如何解决The error may involve defaultParameterMap ### The error occurred while setting parameters
07-20
对于5.7版本的MySQL，在解决"The error may involve defaultParameterMap ### The error occurred while setting parameters"的问题时，你可以尝试以下几种方法： 1. 检查SQL语句是否正确：确保SQL语句中的参数与...
### The error may involve defaultParameterMap ### The error occurred while setting parameters
09-08
根据第一个引用中的信息，“### The error may involve defaultParameterMap ### The error occurred while setting parameters”是一个错误信息，它可能与参数映射有关，而在设置参数时发生了错误。这个错误信息...
The error may involve defaultParameterMap\r\n### The error occurred while setting parameters
08-19
- *3* [### The error may involve defaultParameterMap ### The error occurred while setting parameters](https://blog.csdn.net/qq_53636944/article/details/129151983)[target="_blank" data-report-click={...
【mybatis-plus】【error】批量xml非主键方式更新失败
harbor_lee的博客
03-14 948
【mybatis-plus】【error】批量xml非主键方式更新失败 背景 将项目core层使用的mybatis改为mybatis-plus，并使用java代码代替xml mapper。mybatis-plus有按主键批量更新的api，有按queryWrapper条件更新的api，但没有按queryWrapper条件批量更新的api，因此采用xml方式在不能使用api或跨表场景。 问题及解决 问题 报错如下： Error updating database. Cause: java.sql.SQLSynt
The error occurred while settingparameters
08-16
- *3* [mySql批量更新失败报The error occurred while setting parameters](https://blog.csdn.net/qq_42255763/article/details/100150872)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630",...
The error occurred while setting parameters，Communications The error may involve defaultParameterMap
qq_43436117的博客
06-02 2546
The error occurred while setting parameters，Communications link failure
MyBatis：The error occurred while setting parameters；foreach语句不生效
weixin_39417324的博客
09-11 7577
这条语句拿出来放到执行器中执行，没有任何毛病，但是在mybatis中就不行。刚开始以为是foreach循环写的有问题，然后尝试了各种形式的foreach循环都不行，故排除foreach循环的问题。该条语句的参数是list，list中存着试卷对象，然后遍历试卷对象，挨个更新数据库的数据。1.sql语句中的传的参数类型和数据库中不一致。3.也有说是在sql语句后加了“；2.#{}写成${}
Mybatis：The error occurred while setting parameters 参数设置错误
YYQ_QYY的专栏
10-31 1万+
我的SQL的目的是查询出指定指导老师下的第一个学生信息： SELECT * FROM student WHERE `expired` = 0 AND teacher_id = 160278 ORDER BY id ASC LIMIT 1 大部分数据能查询成功，但是极少部分查询就会报以下错误信息： content: org.springframework.dao.QueryTimeo...
记一次项目上线报错The error occurred while setting parameters
weixin_43817620的博客
01-31 821
报错原因，项目已发布，实体类中新增了字段，数据库中还没新增；操作数据库添加字段后，运行中的项目就会报这个错误。解决办法，先修改数据库添加字段，后发布项目。
seata 导致insert语句出现 The error occurred while setting parameters
qq_43026148的博客
02-17 3566
我是seata RM端，被调用端，被业务发起方调用时，insert语句出现以下错误。日志放在最下方 一开始我一直在查The error occurred while setting parameters等等错误的原因，但是毫无所获，因为我本地运行是没问题的。 我新写了一个测试方法，单纯的就是一个insert，并且参数写死，谁调都一样，这样排除参数的影响，还是一样的结果我自己调就成功，业务发起方调我就报错。怀疑是seata的原因。 我一直在看上面的报错，浪费了很多时间，应该直接看最下方的NullPoint
记录一个sql问题， The error occurred while setting parameters
十一逐星的博客
06-11 4744
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Error querying database. Cause: java.sql.SQLExc...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值