1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
|
Hibernate: select utilisateu0_.id_user as id1_0_, utilisateu0_.nom as nom18_0_, utilisateu0_.prenom as prenom18_0_, utilisateu0_.login as login18_0_, utilisateu0_.mdp as mdp18_0_ from utilisateur utilisateu0_ where utilisateu0_.id_user=?
Hibernate: select declaratio0_.id_user as id3_2_, declaratio0_.id_declaration as id1_2_, declaratio0_.id_declaration as id1_1_, declaratio0_.ninea as ninea12_1_, declaratio0_.id_user as id3_12_1_, declaratio0_.identifiant as identifi4_12_1_, declaratio0_.num_fact as num5_12_1_, declaratio0_.date_declaration as date6_12_1_, declaratio0_.date_imposition as date7_12_1_, declaratio0_.date_cotisation_deb as date8_12_1_, declaratio0_.date_cotisation_fin as date9_12_1_, declaratio0_.date_exig_depot as date10_12_1_, declaratio0_.date_exig_paiement as date11_12_1_, declaratio0_.type_impot as type12_12_1_, declaratio0_.val_tbsd_mois as val13_12_1_, declaratio0_.vente_exo as vente14_12_1_, declaratio0_.vente_taxe_o as vente15_12_1_, declaratio0_.exportation as exporta16_12_1_, declaratio0_.total_vente_nt as total17_12_1_, declaratio0_.total_vente_tax as total18_12_1_, declaratio0_.tva_vente_tax as tva19_12_1_, declaratio0_.tva_importation as tva20_12_1_, declaratio0_.tva_achat_locaux as tva21_12_1_, declaratio0_.tva_paye as tva22_12_1_, declaratio0_.tva_net_due_credit_r as tva23_12_1_, declaratio0_.credit_reporte_ma as credit24_12_1_, declaratio0_.tva_ret_srce_minecofin as tva25_12_1_, declaratio0_.total_tva_du_credit_p as total26_12_1_, declaratio0_.tva_r as tva27_12_1_, declaratio0_.tva_due as tva28_12_1_, entreprise1_.ninea as ninea0_, entreprise1_.nom_entreprise as nom2_1_0_, entreprise1_.sigle as sigle1_0_, entreprise1_.forme as forme1_0_, entreprise1_.compte as compte1_0_, entreprise1_.adresse as adresse1_0_, entreprise1_.rue as rue1_0_, entreprise1_.quartier as quartier1_0_, entreprise1_.localite as localite1_0_, entreprise1_.bp as bp1_0_, entreprise1_.renseigne as renseigne1_0_, entreprise1_.extenso as extenso1_0_, entreprise1_.activite as activite1_0_, entreprise1_.tel as tel1_0_, entreprise1_.num_secu as num15_1_0_, entreprise1_.num_registre as num16_1_0_, entreprise1_.email as email1_0_, entreprise1_.description as descrip18_1_0_, entreprise1_.adresse_stable as adresse19_1_0_, entreprise1_.comptable as comptable1_0_, entreprise1_.bp_comptable as bp21_1_0_, entreprise1_.tel_comptable as tel22_1_0_, entreprise1_.forme_societe as forme23_1_0_, entreprise1_.profession as profession1_0_, entreprise1_.unite_secteur as unite25_1_0_, entreprise1_.centre_fiscal as centre26_1_0_, entreprise1_.centre_perception as centre27_1_0_ from declaration declaratio0_ left outer join entreprise entreprise1_ on declaratio0_.ninea=entreprise1_.ninea where declaratio0_.id_user=?
Hibernate: select entreprise0_.identifiant as identifi1_1_, entreprise0_.ninea as ninea23_1_, entreprise0_.date_declaration as date3_23_1_, entreprise0_.agent_autorise as agent4_23_1_, entreprise0_.penalite_du as penalite5_23_1_, entreprise0_.interet_du as interet6_23_1_, entreprise0_.total_du as total7_23_1_, entreprise0_.date as date23_1_, entreprise0_.noms_complets as noms9_23_1_, entreprise0_.titre as titre23_1_, entreprise0_.telephone as telephone23_1_, entreprise1_.ninea as ninea0_, entreprise1_.nom_entreprise as nom2_1_0_, entreprise1_.sigle as sigle1_0_, entreprise1_.forme as forme1_0_, entreprise1_.compte as compte1_0_, entreprise1_.adresse as adresse1_0_, entreprise1_.rue as rue1_0_, entreprise1_.quartier as quartier1_0_, entreprise1_.localite as localite1_0_, entreprise1_.bp as bp1_0_, entreprise1_.renseigne as renseigne1_0_, entreprise1_.extenso as extenso1_0_, entreprise1_.activite as activite1_0_, entreprise1_.tel as tel1_0_, entreprise1_.num_secu as num15_1_0_, entreprise1_.num_registre as num16_1_0_, entreprise1_.email as email1_0_, entreprise1_.description as descrip18_1_0_, entreprise1_.adresse_stable as adresse19_1_0_, entreprise1_.comptable as comptable1_0_, entreprise1_.bp_comptable as bp21_1_0_, entreprise1_.tel_comptable as tel22_1_0_, entreprise1_.forme_societe as forme23_1_0_, entreprise1_.profession as profession1_0_, entreprise1_.unite_secteur as unite25_1_0_, entreprise1_.centre_fiscal as centre26_1_0_, entreprise1_.centre_perception as centre27_1_0_ from entreprise_dec entreprise0_ left outer join entreprise entreprise1_ on entreprise0_.ninea=entreprise1_.ninea where entreprise0_.identifiant=?
Hibernate: select declaratio0_.identifiant as identifi4_2_, declaratio0_.id_declaration as id1_2_, declaratio0_.id_declaration as id1_1_, declaratio0_.ninea as ninea12_1_, declaratio0_.id_user as id3_12_1_, declaratio0_.identifiant as identifi4_12_1_, declaratio0_.num_fact as num5_12_1_, declaratio0_.date_declaration as date6_12_1_, declaratio0_.date_imposition as date7_12_1_, declaratio0_.date_cotisation_deb as date8_12_1_, declaratio0_.date_cotisation_fin as date9_12_1_, declaratio0_.date_exig_depot as date10_12_1_, declaratio0_.date_exig_paiement as date11_12_1_, declaratio0_.type_impot as type12_12_1_, declaratio0_.val_tbsd_mois as val13_12_1_, declaratio0_.vente_exo as vente14_12_1_, declaratio0_.vente_taxe_o as vente15_12_1_, declaratio0_.exportation as exporta16_12_1_, declaratio0_.total_vente_nt as total17_12_1_, declaratio0_.total_vente_tax as total18_12_1_, declaratio0_.tva_vente_tax as tva19_12_1_, declaratio0_.tva_importation as tva20_12_1_, declaratio0_.tva_achat_locaux as tva21_12_1_, declaratio0_.tva_paye as tva22_12_1_, declaratio0_.tva_net_due_credit_r as tva23_12_1_, declaratio0_.credit_reporte_ma as credit24_12_1_, declaratio0_.tva_ret_srce_minecofin as tva25_12_1_, declaratio0_.total_tva_du_credit_p as total26_12_1_, declaratio0_.tva_r as tva27_12_1_, declaratio0_.tva_due as tva28_12_1_, entreprise1_.ninea as ninea0_, entreprise1_.nom_entreprise as nom2_1_0_, entreprise1_.sigle as sigle1_0_, entreprise1_.forme as forme1_0_, entreprise1_.compte as compte1_0_, entreprise1_.adresse as adresse1_0_, entreprise1_.rue as rue1_0_, entreprise1_.quartier as quartier1_0_, entreprise1_.localite as localite1_0_, entreprise1_.bp as bp1_0_, entreprise1_.renseigne as renseigne1_0_, entreprise1_.extenso as extenso1_0_, entreprise1_.activite as activite1_0_, entreprise1_.tel as tel1_0_, entreprise1_.num_secu as num15_1_0_, entreprise1_.num_registre as num16_1_0_, entreprise1_.email as email1_0_, entreprise1_.description as descrip18_1_0_, entreprise1_.adresse_stable as adresse19_1_0_, entreprise1_.comptable as comptable1_0_, entreprise1_.bp_comptable as bp21_1_0_, entreprise1_.tel_comptable as tel22_1_0_, entreprise1_.forme_societe as forme23_1_0_, entreprise1_.profession as profession1_0_, entreprise1_.unite_secteur as unite25_1_0_, entreprise1_.centre_fiscal as centre26_1_0_, entreprise1_.centre_perception as centre27_1_0_ from declaration declaratio0_ left outer join entreprise entreprise1_ on declaratio0_.ninea=entreprise1_.ninea where declaratio0_.identifiant=?
Hibernate: select nextval ('seq_declaration')
Hibernate: select entreprise_.ninea, entreprise_.nom_entreprise as nom2_1_, entreprise_.sigle as sigle1_, entreprise_.forme as forme1_, entreprise_.compte as compte1_, entreprise_.adresse as adresse1_, entreprise_.rue as rue1_, entreprise_.quartier as quartier1_, entreprise_.localite as localite1_, entreprise_.bp as bp1_, entreprise_.renseigne as renseigne1_, entreprise_.extenso as extenso1_, entreprise_.activite as activite1_, entreprise_.tel as tel1_, entreprise_.num_secu as num15_1_, entreprise_.num_registre as num16_1_, entreprise_.email as email1_, entreprise_.description as descrip18_1_, entreprise_.adresse_stable as adresse19_1_, entreprise_.comptable as comptable1_, entreprise_.bp_comptable as bp21_1_, entreprise_.tel_comptable as tel22_1_, entreprise_.forme_societe as forme23_1_, entreprise_.profession as profession1_, entreprise_.unite_secteur as unite25_1_, entreprise_.centre_fiscal as centre26_1_, entreprise_.centre_perception as centre27_1_ from entreprise entreprise_ where entreprise_.ninea=?
Hibernate: insert into declaration (ninea, id_user, identifiant, num_fact, date_declaration, date_imposition, date_cotisation_deb, date_cotisation_fin, date_exig_depot, date_exig_paiement, type_impot, val_tbsd_mois, vente_exo, vente_taxe_o, exportation, total_vente_nt, total_vente_tax, tva_vente_tax, tva_importation, tva_achat_locaux, tva_paye, tva_net_due_credit_r, credit_reporte_ma, tva_ret_srce_minecofin, total_tva_du_credit_p, tva_r, tva_due, id_declaration) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
WARN : JDBCExceptionReporter.java -> SQL Error: 0, SQLState: null
ERROR : JDBCExceptionReporter.java -> L'élément du batch 0 insert into declaration (ninea, id_user, identifiant, num_fact, date_declaration, date_imposition, date_cotisation_deb, date_cotisation_fin, date_exig_depot, date_exig_paiement, type_impot, val_tbsd_mois, vente_exo, vente_taxe_o, exportation, total_vente_nt, total_vente_tax, tva_vente_tax, tva_importation, tva_achat_locaux, tva_paye, tva_net_due_credit_r, credit_reporte_ma, tva_ret_srce_minecofin, total_tva_du_credit_p, tva_r, tva_due, id_declaration) values (54671892E1, 18, 0, , 2008-08-27 00:00:00.000000+00:00, Juillet 2008, 01 Juillet 2008, 31 Juillet 2008, 2008-08-15 00:00:00.000000+00:00, 2008-08-15 00:00:00.000000+00:00, , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1234567967) a été annulé. Appeler getNextException pour en connaître la cause.
WARN : JDBCExceptionReporter.java -> SQL Error: 0, SQLState: 23503
ERROR : JDBCExceptionReporter.java -> ERROR: insert or update on table "declaration" violates foreign key constraint "fk_declaration_entreprise_dec"
ERROR : AbstractFlushingEventListener.java -> Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at com.tva.dao.imp.DeclarationDao.saveDeclaration(DeclarationDao.java:98)
at com.tva.manager.imp.DeclarationMg.saveDeclaration(DeclarationMg.java:59)
at com.tva.struts.action.declaration.EnregistrerDeclarationAction.executeAction(EnregistrerDeclarationAction.java:256)
at com.tva.struts.action.ActionBase.execute(ActionBase.java:155)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at com.tva.struts.servlets.ServletBase.doPost(ServletBase.java:38)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
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.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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: L'élément du batch 0 insert into declaration (ninea, id_user, identifiant, num_fact, date_declaration, date_imposition, date_cotisation_deb, date_cotisation_fin, date_exig_depot, date_exig_paiement, type_impot, val_tbsd_mois, vente_exo, vente_taxe_o, exportation, total_vente_nt, total_vente_tax, tva_vente_tax, tva_importation, tva_achat_locaux, tva_paye, tva_net_due_credit_r, credit_reporte_ma, tva_ret_srce_minecofin, total_tva_du_credit_p, tva_r, tva_due, id_declaration) values (54671892E1, 18, 0, , 2008-08-27 00:00:00.000000+00:00, Juillet 2008, 01 Juillet 2008, 31 Juillet 2008, 2008-08-15 00:00:00.000000+00:00, 2008-08-15 00:00:00.000000+00:00, , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1234567967) a été annulé. Appeler getNextException pour en connaître la cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2439)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:345)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2501)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
... 31 more
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:63)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at com.tva.dao.imp.DeclarationDao.saveDeclaration(DeclarationDao.java:98)
at com.tva.manager.imp.DeclarationMg.saveDeclaration(DeclarationMg.java:59)
at com.tva.struts.action.declaration.EnregistrerDeclarationAction.executeAction(EnregistrerDeclarationAction.java:256)
at com.tva.struts.action.ActionBase.execute(ActionBase.java:155)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at com.tva.struts.servlets.ServletBase.doPost(ServletBase.java:38)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
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.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.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: L'élément du batch 0 insert into declaration (ninea, id_user, identifiant, num_fact, date_declaration, date_imposition, date_cotisation_deb, date_cotisation_fin, date_exig_depot, date_exig_paiement, type_impot, val_tbsd_mois, vente_exo, vente_taxe_o, exportation, total_vente_nt, total_vente_tax, tva_vente_tax, tva_importation, tva_achat_locaux, tva_paye, tva_net_due_credit_r, credit_reporte_ma, tva_ret_srce_minecofin, total_tva_du_credit_p, tva_r, tva_due, id_declaration) values (54671892E1, 18, 0, , 2008-08-27 00:00:00.000000+00:00, Juillet 2008, 01 Juillet 2008, 31 Juillet 2008, 2008-08-15 00:00:00.000000+00:00, 2008-08-15 00:00:00.000000+00:00, , 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1234567967) a été annulé. Appeler getNextException pour en connaître la cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2439)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:345)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2501)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
... 31 more |
Partager