mybatis问题锦集（一）

最新推荐文章于 2021-02-25 17:42:06 发布
最新推荐文章于 2021-02-25 17:42:06 发布
阅读量5.1k 收藏
点赞数 1
分类专栏： mybatis 文章标签： mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/cwl421/article/details/52904544
版权

第一个问题：

如果数据库是mysql，进行批量增加和修改的时候，在jdbc连接数据库的配置文件上一定要加上&allowMultiQueries=true，因为mysql数据库是默认allowMultiQueries=false,
jdbc_url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true
批量修改语句： 
<span style="font-size:18px;"><update id="batchUpdate"  parameterType="java.util.List">
     
          <foreach collection="list" item="item" index="index" open="" close="" separator=";">
                update test
                <set>
                  studentNum = ${item.studentNum}
                </set>
                where teacherId= '${item.teacherId}'
         </foreach>
         
    </update>  </span>


第二个问题是：

我对一张表进行先进行批量修改和增加的时候，报错如下： 
[ INFO] HHH000010: On release of batch it still contained JDBC statements
[ WARN] SQL Error: 1205, SQLState: 41000
[ERROR] Lock wait timeout exceeded; try restarting transaction
[ERROR] HHH000315: Exception executing batch [could not execute batch]
2016-10-21 17:23:37.479 [http-bio-8080-exec-5] SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6a4f5d83]
2016-10-21 17:23:37.479 [http-bio-8080-exec-5] SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6a4f5d83]
2016-10-21 17:23:37.507 [http-bio-8080-exec-5] DataSourceTransactionManager - Initiating transaction rollback after commit exception
org.springframework.dao.CannotAcquireLockException: could not execute batch; SQL [insert into tb_tutorapprove (comment, isDelete, operator, versionEndTime, versionStartTime, create_time, update_time, applyStudentNum, state, studentNum, teacherId, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.LockTimeoutException: could not execute batch
	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:154) ~[spring-orm-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.orm.hibernate4.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:107) ~[spring-orm-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95) ~[spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:932) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:744) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) [spring-aop-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at com.dmsd.itoo.tutor.service.impl.TeacherSetServiceImpl$$EnhancerBySpringCGLIB$$269ce583.saveOrUpdate(<generated>) [dmsd-itoo-tutor-core-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
	at com.dmsd.itoo.tutor.controller.TeacherSetController.addStuNum(TeacherSetController.java:110) [classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_25]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_25]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222) [spring-web-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137) [spring-web-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) [servlet-api.jar:na]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845) [spring-webmvc-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) [servlet-api.jar:na]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [catalina.jar:7.0.67]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.67]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat7-websocket.jar:7.0.67]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.67]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.67]
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:200) [javamelody-core-1.58.0.jar:1.58.0]
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:178) [javamelody-core-1.58.0.jar:1.58.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.67]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.67]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121) [spring-web-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.67]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.67]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) [catalina.jar:7.0.67]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [catalina.jar:7.0.67]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [catalina.jar:7.0.67]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) [catalina.jar:7.0.67]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [catalina.jar:7.0.67]
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) [catalina.jar:7.0.67]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [catalina.jar:7.0.67]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) [catalina.jar:7.0.67]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) [tomcat-coyote.jar:7.0.67]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) [tomcat-coyote.jar:7.0.67]
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) [tomcat-coyote.jar:7.0.67]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_25]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_25]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-coyote.jar:7.0.67]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_25]
Caused by: org.hibernate.exception.LockTimeoutException: could not execute batch
	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:447) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:136) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	at org.springframework.orm.hibernate4.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:104) ~[spring-orm-4.2.4.RELEASE.jar:4.2.4.RELEASE]
	... 56 common frames omitted
Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2056) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467) ~[mysql-connector-java-5.1.26.jar:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_25]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_25]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
	at com.p6spy.engine.logging.P6LogPreparedStatementExecuteDelegate.invoke(P6LogPreparedStatementExecuteDelegate.java:42) ~[p6spy-2.1.4.jar:na]
	at com.p6spy.engine.proxy.GenericInvocationHandler.invoke(GenericInvocationHandler.java:116) ~[p6spy-2.1.4.jar:na]
	at org.p6spy.com.mysql.jdbc.Statement$$EnhancerByCGLIB$$b2d3c097.executeBatch(<generated>) ~[p6spy-2.1.4.jar:na]
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127) ~[hibernate-core-4.3.10.Final.jar:4.3.10.Final]
	... 65 common frames omitted
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460) ~[mysql-connector-java-5.1.26.jar:na]
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2008) ~[mysql-connector-java-5.1.26.jar:na]
	... 74 common frames omitted
2016-10-21 17:23:37.509 [http-bio-8080-exec-5] DataSourceTransactionManager - Rolling back JDBC transaction on Connection [com.mysql.jdbc.JDBC4Connection@18f9ce9d]
2016-10-21 17:23:37.517 [http-bio-8080-exec-5] DataSourceTransactionManager - Releasing JDBC Connection [com.mysql.jdbc.JDBC4Connection@18f9ce9d] after transaction
2016-10-21 17:23:37.518 [http-bio-8080-exec-5] DataSourceUtils - Returning JDBC Connection to DataSource
org.springframework.dao.CannotAcquireLockException: could not execute batch; SQL [insert into tb_tutorapprove (comment, isDelete, operator, versionEndTime, versionStartTime, create_time, update_time, applyStudentNum, state, studentNum, teacherId, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.LockTimeoutException: could not execute batch
	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:154)
	at org.springframework.orm.hibernate4.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:107)
	at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:932)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:744)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
	at com.dmsd.itoo.tutor.service.impl.TeacherSetServiceImpl$$EnhancerBySpringCGLIB$$269ce583.saveOrUpdate(<generated>)
	at com.dmsd.itoo.tutor.controller.TeacherSetController.addStuNum(TeacherSetController.java:110)
	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:483)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:200)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.LockTimeoutException: could not execute batch
	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:447)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:136)
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114)
	at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
	at org.springframework.orm.hibernate4.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:104)
	... 56 more
Caused by: java.sql.BatchUpdateException:<span style="color:#ff6666;"> Lock wait timeout exceeded; try restarting transaction</span>
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2056)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
	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:483)
	at com.p6spy.engine.logging.P6LogPreparedStatementExecuteDelegate.invoke(P6LogPreparedStatementExecuteDelegate.java:42)
	at com.p6spy.engine.proxy.GenericInvocationHandler.invoke(GenericInvocationHandler.java:116)
	at org.p6spy.com.mysql.jdbc.Statement$$EnhancerByCGLIB$$b2d3c097.executeBatch(<generated>)
	at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127)
	... 65 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2008)
	... 74 more
2016-10-21 17:23:37.538 [http-bio-8080-exec-5] DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'action': assuming HandlerAdapter completed request handling
2016-10-21 17:23:37.538 [http-bio-8080-exec-5] DispatcherServlet - Successfully completed request
重点错误： 
<span style="font-size:18px;color:#ff0000;">Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction</span>
是以下这个sql语句未执行完，然后又去执行insert语句，导致的锁的问题。
          <foreach collection="list" item="item" index="index" open="" close="" separator=";">
                update test
                <set>
                  studentNum = ${item.studentNum}
                </set>
                where teacherId= '${item.teacherId}'
         </foreach>
         
    </update>  

解决办法：对表中teacherid加索引。这个问题肯定不止一种解决方法，望大家提出意见。


小崔编程
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 33
    评论
专栏目录
mybatis问题积累
qq_29422673的博客
05-22 155
1.Dialect的设置，在pageHelper中会控制数据的sql的是oracle或者mysql 2.插入数据的时候返回id，参见https://blog.csdn.net/weixin_43179996/article/details/85062405 核心就是oracle的数据库，查询需要这么 写useGeneratedKeys、keyProperty、selectKey 都带上，不加selectKey 只有前两部分会报错： <insert id="insertLangValue" p.
mybatis常遇问题
qq_40795687的博客
04-03 223
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 mybatis学习笔记 前言 以下实验环境均基于MYSQL 8.0，是我在学习mybatis时构建项目测试所遇到的问题，可能会有错误的理解，欢迎指出。 一、错误：org.apache.ibatis.exceptions.PersistenceException 原配置文件中链接数据库的URL如下： <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useS
Hibernate错误及解决办法集合
05-17
本人做系统时遇到的一些Hibernate问题及解决方案。
Hibernate报错：On release of batch it still contained JDBC statements
热门推荐
小康子的博客
02-21 2万+
On release of batch it still contained JDBC statements 错误。
hibernate save数据到 oracle 问题之一：On release of batch it still contained JDBC statements
alinekang的博客
10-23 2158
要读取某个文件的数据存储到oracle 数据库，真的是，各种问题频繁而出啊。 在save操作的时候，报错 “On release of batch it still contained JDBC statements” 网上搜了一下，说是 Hibernate的删除和更新操作，只对persistence对象有效，即这些对象已存在于数据库中（可以是你通过查找操作从数据库中刚取出的对象）。而不能用n...
on release of batch it still contained JDBC statements
zr_1877的博客
11-14 5555
在运行HIbernate工程中出现这个提示信息。发现自己用来测试的new示例并未使数据库中记录更新。突然想到刚才测试删除操作时所犯的错误。Hibernate的删除和更新操作，只对persistence对象有效，即这些对象已存在于数据库中（可以是你通过查找操作从数据库中刚取出的对象）。而不能用new出来的实例（即使这个实例的字段跟数据库中一条记录的完全相同）来作为测试用例。
Mybatis结果集自动映射的实例代码
08-31
在Mybatis中，结果集映射是用于将数据库查询的结果转换为Java对象的过程。自动映射功能使得这一过程更为便捷，无需显式地编写复杂的resultMap配置。在某些情况下，我们只需要简单地指定`resultType`属性，Mybatis就...
Java mybatis常见问题及解决方案
08-18
"Java MyBatis常见问题及解决方案" ...MyBatis是一个功能强大且灵活的持久层框架，但是如果不正确使用，可能会出现各种问题。通过了解这些常见问题和解决方案，我们可以更好地使用MyBatis来开发我们的Java项目。
Mybatis Update操作返回值问题
08-29
这个问题涉及到 Mybatis 如何处理数据库返回的结果以及数据库驱动的行为。 首先，当我们使用 Mybatis 的 update 语句执行更新操作时，返回的整数值实际上是数据库驱动提供的信息，而不是 Mybatis 自身计算的结果。...
mybatis的一个笔记
05-11
mybatis笔记
第一个Mybatis程序
11-22
本教程将带你一步步走进Mybatis的世界，通过“第一个Mybatis程序”的实例学习其基本概念和操作流程。 一、Mybatis简介 Mybatis是由Clinton Begin创建的开源项目，它是一个基于Java的持久层框架，专注于简化数据库...
On release of batch it still contained JDBC statements
y41992910的博客
11-12 1万+
最近用hiernate执行saveOrUpdate的时候，报错了。错误信息如下 2018-11-12 13:55:32,265 [WARN ] [http-bio-8080-exec-9] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1062, SQLState: 23000 2018-11-12 13:55:32,2...
关于On release of batch it still contained JDBC statements异常的疑问
笑看人生的专栏
04-12 1万+
在项目中.发现 Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 .................................... [org.hibernat
java抛出异常 sql_druid执行sql为什么抛出异常：java.sql.SQLException: statement is closed...
weixin_31869917的博客
02-25 2078
DEBUG SQL:104 :deletefromqdexam.dbo.tbl_interestwhereid=?[qdksService_log] 2016-01-28 18:19:57 INFO AbstractBatchImpl:195 : HHH000010: On release of batch it still contained JDBC statements[qdksServ...
JDBC batch
wzhsh90的专栏
04-14 507
直接用jdbc 进行批量删除    //批量删除分类对象     public void deleteBat(Integer[] catNo){   try {    Connection con=DBUtil.getInstance().getCon();    String sql="delete from cat where catno=?";    con.setAutoCom
Could not execute JDBC batch update
李双喆
08-15 7480
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
MySQL的Could not execute JDBC batch update解决方案，SQL脚本太长导致无法存入MySQL
Leemeea的博客
12-06 1698
mysql sql长度限制解决 错误提示： Could not execute JDBC batch update 通过发现原因是SQL语句长度大于1M，而机器上的mysql是默认配置为1M，也就是说mysql通讯的数据包大小设置是１M，这就造成sql语句执行失败。 将mysql的配置文件（my.ini）中的max_allowed_packet = 6M，就可以解决这样的问题。 ...
项目部年度员工培训计划.docx
最新发布
07-13
项目部年度员工培训计划.docx
mybatis一对一结果集映射
08-28
MyBatis 是一种开源的持久化框架，它提供了一套灵活的机制来映射数据库操作到 Java 对象。在 MyBatis 中，一对一和一对多关系可以通过不同的方式来实现。 对于一对一关系，可以使用嵌套查询或者嵌套结果映射来实现。嵌套查询是指在一个查询中嵌套执行另一个查询，并将结果映射到相应的对象中。嵌套结果映射则是将两个对象分别查询出来，并通过嵌套的方式将它们关联起来。 以下是一个示例，展示了如何在 MyBatis 中实现一对一关系： ```xml <!-- 定义一对一关联的映射 --> <resultMap id="userResultMap" type="User"> <id property="id" column="user_id" />

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 33
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值