Requête | Temps moyen (ms) | Temps max (ms) | Ecart-type | Temps cpu moyen (ms) | % d'erreur système |
---|---|---|---|---|---|
ERROR [fr.spi4j.ui.gwt.server.SpiRemoteServiceImpl] Erreur racine : org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)" Value too long for column "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)"; SQL statement: insert into AW_PERSONNE (PERSONNE_ID, NOM, PRENOM, CIVIL, DATE_NAISSANCE, SALAIRE, VERSION, GRADE_ID, XDMAJ, XTOPSUP) values (AW_PERSONNE_SEQ.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-200] Erreur levée : Problème lors du create avec p_Entity=fr.appwhite1.persistence.impl_jdbc.annuaire.PersonneEntity@7255c573 : null, sadas, sadasd, true, Fri Aug 25 06:00:00 CEST 2023, 2.113123123123E12, Wed Aug 23 15:16:36 CEST 2023, 1001 Solution potentielle : ??? | -1 | 0 | 0 | 100,00 |
Stack-trace
Erreur racine : org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)"
Value too long for column "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)"; SQL statement:
insert into AW_PERSONNE (PERSONNE_ID, NOM, PRENOM, CIVIL, DATE_NAISSANCE, SALAIRE, VERSION, GRADE_ID, XDMAJ, XTOPSUP) values (AW_PERSONNE_SEQ.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-200]
Erreur levée : Problème lors du create avec p_Entity=fr.appwhite1.persistence.impl_jdbc.annuaire.PersonneEntity@7255c573 : null, sadas, sadasd, true, Fri Aug 25 06:00:00 CEST 2023, 2.113123123123E12, Wed Aug 23 15:16:36 CEST 2023, 1001
Solution potentielle : ???
at fr.spi4j.persistence.dao.jdbc.DaoJdbc_Abs.create(DaoJdbc_Abs.java:275)
at fr.spi4j.matching.Match_Abs.create(Match_Abs.java:44)
at fr.appwhite1.matching.Appli1Match_Abs.create(Appli1Match_Abs.java:41)
at fr.appwhite1.matching.annuaire.PersonneMatch.create(PersonneMatch.java:148)
at fr.appwhite1.matching.annuaire.PersonneMatch.create(PersonneMatch.java:32)
at fr.spi4j.business.Service_Abs.save(Service_Abs.java:47)
at jdk.internal.reflect.GeneratedMethodAccessor3657.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
at fr.spi4j.lib.security.SecurityProxy.invoke(SecurityProxy.java:47)
at com.sun.proxy.$Proxy6.save(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor3657.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
at fr.spi4j.persistence.TransactionProxy.invoke(TransactionProxy.java:70)
at com.sun.proxy.$Proxy6.save(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor3657.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at fr.spi4j.ReflectUtil.invokeMethod(ReflectUtil.java:39)
at fr.spi4j.business.ServiceLogProxy.invoke(ServiceLogProxy.java:169)
at com.sun.proxy.$Proxy6.save(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor3657.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at net.bull.javamelody.MonitoringProxy.invokeTarget(MonitoringProxy.java:182)
at net.bull.javamelody.MonitoringProxy.invoke(MonitoringProxy.java:164)
at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
at com.sun.proxy.$Proxy7.save(Unknown Source)
at fr.spi4j.ui.gwt.server.GwtRemoteServiceImpl.save(GwtRemoteServiceImpl.java:31)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at fr.spi4j.filter.HttpSessionFilter.doFilter(HttpSessionFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:199)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at fr.spi4j.lib.security.RemoteUserFilter.doFilter(RemoteUserFilter.java:92)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.h2.jdbc.JdbcSQLDataException: Valeur trop longue pour la colonne "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)"
Value too long for column "SALAIRE DECIMAL(14, 2)": "2113123123123.00 (15)"; SQL statement:
insert into AW_PERSONNE (PERSONNE_ID, NOM, PRENOM, CIVIL, DATE_NAISSANCE, SALAIRE, VERSION, GRADE_ID, XDMAJ, XTOPSUP) values (AW_PERSONNE_SEQ.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:457)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.value.TypeInfo.getValueTooLongException(TypeInfo.java:535)
at org.h2.value.TypeInfo.cast(TypeInfo.java:520)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:378)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:845)
at org.h2.command.dml.Insert.insertRows(Insert.java:187)
at org.h2.command.dml.Insert.update(Insert.java:151)
at org.h2.command.CommandContainer.executeUpdateWithGeneratedKeys(CommandContainer.java:272)
at org.h2.command.CommandContainer.update(CommandContainer.java:191)
at org.h2.command.Command.executeUpdate(Command.java:251)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:191)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:152)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at jdk.internal.reflect.GeneratedMethodAccessor3763.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at net.bull.javamelody.JdbcWrapper.doExecute(JdbcWrapper.java:422)
at net.bull.javamelody.JdbcWrapper$StatementInvocationHandler.invoke(JdbcWrapper.java:142)
at net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:300)
at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)
at fr.spi4j.persistence.dao.jdbc.DaoJdbc_Abs.create(DaoJdbc_Abs.java:244)
... 77 more