Erro ao dar update no Hibernate

1 resposta
S

Galera estou com um problema que ocorre ao tentar atualizar ou inserir um registro, gostaria da ajuda de vcs!

Obrigado!

2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:997)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1142)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.dao.DispositivoVeiculoDAO.pesquisarPPR(DispositivoVeiculoDAO.java:38)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.service.DispositivoVeiculoService.pesquisarPPR(DispositivoVeiculoService.java:194)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.utils.ppr.PPR.salvarTabelaEstadoPosicao(PPR.java:1370)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.utils.ppr.PPR.insereRecebidos(PPR.java:1230)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at sun.reflect.GeneratedMethodAccessor420.invoke(Unknown Source)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at java.lang.reflect.Method.invoke(Method.java:597)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:57)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.interceptor.NoCacheInterceptor.intercept(NoCacheInterceptor.java:38)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.interceptor.HibernateTransactionInterceptor.intercept(HibernateTransactionInterceptor.java:51)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
2011-09-15 00:00:11,453 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at br.com.kage.clog.outros.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:59)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
2011-09-15 00:00:11,500 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at java.lang.Thread.run(Thread.java:619)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
2011-09-15 00:00:11,531 ERROR [STDERR] (http-187.45.219.39-8080-5) 	... 69 more

1 Resposta

fernandopaiva

veja isto…http://forums.pentaho.com/showthread.php?68747-Error-Lock-wait-timeout-exceeded-try-restarting-transaction-How-to-solve

t+ e boa sorte.

Criado 15 de setembro de 2011
Ultima resposta 15 de set. de 2011
Respostas 1
Participantes 2