-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
vitto
 Post subject: bloquer requete lors d'un traitement en cours
PostPosted: Mon Oct 09, 2006 4:03 am 
Newbie

Joined: Mon Oct 09, 2006 3:45 am
Posts: 3
Bonjour !
J'aimerais qu'une requete soit bloqués quand il y'en a une en cours !
Je p'explique, lors de multiple clic d'un bouton valider, au bout de quelques clic la page se raffrachit et une autre requete part(ainsi desactiver le bouton ne marche pas)!Ce qui me donne comme stacktrace :

Code:
java.sql.SQLException: Can't call rollback when autocommit=true
   at com.mysql.jdbc.Connection.rollback(Connection.java:1472)
   at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:535)
   at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:460)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at com.eurecia.hibernate.PersistentObjectDAO.rollback(PersistentObjectDAO.java:1018)
   at com.eurecia.hibernate.PersistentObjectDAO.update(PersistentObjectDAO.java:151)
   at com.eurecia.service.ServiceBase.updateEntity(ServiceBase.java:193)
   at com.eurecia.service.expensesReport.ExpensesReportService.updateEntity(ExpensesReportService.java:279)
   at com.eurecia.web.common.action.EureciaOpenAction.save(EureciaOpenAction.java:259)
   at com.eurecia.web.expensesReport.open.OpenExpensesReportAction.save(OpenExpensesReportAction.java:249)
   at com.eurecia.web.common.action.EureciaOpenAction.apply_onClick(EureciaOpenAction.java:209)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at com.cc.framework.adapter.struts.ActionUtil.handleFormAction(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.handleFormAction(Unknown Source)
   at com.cc.framework.adapter.struts.ActionUtil.execute(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
   at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
   at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
   at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
   at java.lang.Thread.run(Thread.java:534)
10:02:02,421 INFO  [STDOUT] Hibernate: select items0_.ID_COMPANY as ID1_0_, items0_.ID_USER as ID2_0_, items0_.ID_EXPENSES_REPORT as ID3_0_, items0_.ID_EXPENSES_REPORT_ITEM as ID4_0_, items0_.DATE as DATE0_, items0_.DESCRIPTION as DESCRIPT6_0_, items0_.COMMENT as COMMENT0_, items0_.REF as REF0_, items0_.TYPE as TYPE0_, items0_.AMOUNT_HT as AMOUNT10_0_, items0_.AMOUNT_VAT as AMOUNT11_0_, items0_.AMOUNT_TTC as AMOUNT12_0_, items0_.AMOUNT_CURRENCY as AMOUNT13_0_, items0_.KM as KM0_, items0_.ID_IMPUTATION_STRUCTURE_ITEM as ID15_0_, items0_.INVOICABLE as INVOICABLE0_, items0_.ID_ATTACHED_FILE as ID17_0_ from EXPENSES_REPORT_ITEM_EA items0_ where items0_.ID_COMPANY=? and items0_.ID_USER=? and items0_.ID_EXPENSES_REPORT=? order by DATE,items0_.REF
10:02:02,421 INFO  [STDOUT] org.hibernate.TransactionException: JDBC rollback failed
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
   at com.eurecia.hibernate.PersistentObjectDAO.rollback(PersistentObjectDAO.java:1018)
   at com.eurecia.hibernate.PersistentObjectDAO.update(PersistentObjectDAO.java:151)
   at com.eurecia.service.ServiceBase.updateEntity(ServiceBase.java:193)
   at com.eurecia.service.expensesReport.ExpensesReportService.updateEntity(ExpensesReportService.java:279)
   at com.eurecia.web.common.action.EureciaOpenAction.save(EureciaOpenAction.java:259)
   at com.eurecia.web.expensesReport.open.OpenExpensesReportAction.save(OpenExpensesReportAction.java:249)
   at com.eurecia.web.common.action.EureciaOpenAction.apply_onClick(EureciaOpenAction.java:209)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at com.cc.framework.adapter.struts.ActionUtil.handleFormAction(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.handleFormAction(Unknown Source)
   at com.cc.framework.adapter.struts.ActionUtil.execute(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
   at com.cc.framework.adapter.struts.FWAction.execute(Unknown Source)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
   at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
   at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
   at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
   at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
   at java.lang.Thread.run(Thread.java:534)


Pourriez vous m'en dire un peu plus ?
Merci pour votre attention, je ne sais plus comment faire!
Top
 Profile  
 
vitto
 Post subject:
PostPosted: Mon Oct 09, 2006 4:29 am 
Newbie

Joined: Mon Oct 09, 2006 3:45 am
Posts: 3
Pour infos ! j'obtiens l'erreur = 1062 (jdbcEcxception)
Top
 Profile  
 
titoudemtl
 Post subject:
PostPosted: Tue Oct 10, 2006 12:10 pm 
Newbie

Joined: Thu Aug 03, 2006 4:38 am
Posts: 6
JE ne sais pas si ça répond à ton probléme :
POurquoi pas rendre le bouton inactif quand une requête a été lancée et qu'il n'y a pas encore eu de résultat ?

Je sais que ça contourner le probléme, mais ça peut être une solution !
Top
 Profile  
 
vitto
 Post subject:
PostPosted: Wed Oct 11, 2006 4:37 am 
Newbie

Joined: Mon Oct 09, 2006 3:45 am
Posts: 3
Merci pour ta reponse !
Je l'avais essayé, mais au bout d'un moment mage se raffraichissait, et faisait donc des conflit avec la requete hibernate!
finalement j'ai trouvé une solution de bricolage :J'ai ajouter un Thread(200)
avant le update, ce qui empeche un conflit pour un ptit moment
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.