org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

GitHub | aeburriel | 1 month ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    UpdateImage with platform=Paravirtualization failed

    GitHub | 2 years ago | youyk
    rg.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.DataException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement
  2. 0

    GitHub comment 14#270729416

    GitHub | 1 month ago | aeburriel
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  3. 0

    GitHub comment 14#270729556

    GitHub | 1 month ago | aeburriel
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception when rolling back flows after failing to connect VR

    GitHub | 1 year ago | zxwing
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  6. 0

    SQL0407:Null values not allowed in column or variable for JPA spring data insert operation

    Stack Overflow | 2 years ago | Nupin Pillai
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: llave duplicada viola restricción de unicidad «par_butacas_uk» Detail: Ya existe la llave (sesion_id, localizacion_id, ( CASE WHEN fila IS NULL THEN (id + 1000)::character varying ELSE fila END), ( CASE WHEN numero IS NULL THEN (id + 1000)::character varying ELSE numero END), ( CASE WHEN anulada = true THEN id + 1000 ELSE 1 END))=(919, 1, 12, 1, 1).

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    QueryExecutorImpl.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    3 frames
  3. org.postgresql.jdbc
    PgPreparedStatement.executeUpdate
    1. org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    2. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    3. org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    4. org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135)[postgresql-9.4.1212.jre7.jar:9.4.1212.jre7]
    4 frames
  4. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeUpdate
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)[c3p0-0.9.1.1.jar:0.9.1.1]
    1 frame
  5. Hibernate
    SessionImpl.flush
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    2. org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    3. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    4. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    5. org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    6. org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    7. org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    8. org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    9. org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    10. org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    10 frames
  6. org.hibernate.jpa
    AbstractEntityManagerImpl.flush
    1. org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)[hibernate-entitymanager-4.3.11.Final.jar:4.3.11.Final]
    1 frame
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_79]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_79]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_79]
    4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_79]
    4 frames
  8. Spring ORM
    SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke
    1. org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:241)[spring-orm-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  9. com.sun.proxy
    $Proxy324.flush
    1. com.sun.proxy.$Proxy324.flush(Unknown Source)[na:na]
    1 frame
  10. es.uji.apps
    ButacasDAO$AjcClosure17.run
    1. es.uji.apps.par.dao.ButacasDAO.reservaButacas_aroundBody16(ButacasDAO.java:210)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    2. es.uji.apps.par.dao.ButacasDAO$AjcClosure17.run(ButacasDAO.java:1)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    2 frames
  11. Spring Aspects
    AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2. org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2 frames
  12. Spring Tx
    TransactionAspectSupport.invokeWithinTransaction
    1. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)[spring-tx-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  13. Spring Aspects
    AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  14. es.uji.apps
    ComprasService$AjcClosure3.run
    1. es.uji.apps.par.dao.ButacasDAO.reservaButacas(ButacasDAO.java:178)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    2. es.uji.apps.par.services.ComprasService.registraCompra_aroundBody2(ComprasService.java:121)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    3. es.uji.apps.par.services.ComprasService$AjcClosure3.run(ComprasService.java:1)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    3 frames
  15. Spring Aspects
    AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2. org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2 frames
  16. Spring Tx
    TransactionAspectSupport.invokeWithinTransaction
    1. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)[spring-tx-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  17. Spring Aspects
    AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  18. es.uji.apps
    ComprasService$AjcClosure5.run
    1. es.uji.apps.par.services.ComprasService.registraCompra(ComprasService.java:118)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    2. es.uji.apps.par.services.ComprasService.registraCompra_aroundBody4(ComprasService.java:151)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    3. es.uji.apps.par.services.ComprasService$AjcClosure5.run(ComprasService.java:1)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    3 frames
  19. Spring Aspects
    AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:59)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2. org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:65)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2 frames
  20. Spring Tx
    TransactionAspectSupport.invokeWithinTransaction
    1. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)[spring-tx-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  21. Spring Aspects
    AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c
    1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:63)[spring-aspects-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    1 frame
  22. es.uji.apps
    CompraResource.compraEntrada
    1. es.uji.apps.par.services.ComprasService.registraCompra(ComprasService.java:143)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    2. es.uji.apps.par.services.ComprasService.registraCompraTaquilla(ComprasService.java:50)[uji-par-base-0.0.12-SNAPSHOT.jar:na]
    3. es.uji.apps.par.services.rest.CompraResource.compraEntrada(CompraResource.java:212)[classes/:na]
    3 frames
  23. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_79]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_79]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_79]
    4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_79]
    4 frames
  24. Jersey
    WebApplicationImpl.handleRequest
    1. com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)[jersey-server-1.17.1.jar:1.17.1]
    2. com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)[jersey-server-1.17.1.jar:1.17.1]
    3. com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)[jersey-server-1.17.1.jar:1.17.1]
    4. com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)[jersey-server-1.17.1.jar:1.17.1]
    5. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[jersey-server-1.17.1.jar:1.17.1]
    6. com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)[jersey-server-1.17.1.jar:1.17.1]
    7. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[jersey-server-1.17.1.jar:1.17.1]
    8. com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)[jersey-server-1.17.1.jar:1.17.1]
    9. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)[jersey-server-1.17.1.jar:1.17.1]
    10. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)[jersey-server-1.17.1.jar:1.17.1]
    11. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)[jersey-server-1.17.1.jar:1.17.1]
    12. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)[jersey-server-1.17.1.jar:1.17.1]
    12 frames
  25. Jersey
    ServletContainer.service
    1. com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)[jersey-servlet-1.17.1.jar:1.17.1]
    2. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)[jersey-servlet-1.17.1.jar:1.17.1]
    3. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)[jersey-servlet-1.17.1.jar:1.17.1]
    3 frames
  26. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:731)[tomcat-servlet-api-3.0.jar:na]
    1 frame
  27. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)[tomcat-catalina-7.0.73.jar:7.0.73]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[tomcat-catalina-7.0.73.jar:7.0.73]
    2 frames
  28. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)[tomcat7-websocket.jar:7.0.73]
    1 frame
  29. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[tomcat-catalina-7.0.73.jar:7.0.73]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[tomcat-catalina-7.0.73.jar:7.0.73]
    2 frames
  30. es.uji.apps
    AuthFilter.doFilter
    1. es.uji.apps.par.auth.AuthFilter.doFilter(AuthFilter.java:73)[classes/:na]
    1 frame
  31. Spring
    DelegatingFilterProxy.doFilter
    1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)[spring-web-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)[spring-web-3.2.17.RELEASE.jar:3.2.17.RELEASE]
    2 frames
  32. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[tomcat-catalina-7.0.73.jar:7.0.73]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[tomcat-catalina-7.0.73.jar:7.0.73]
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)[tomcat-catalina-7.0.73.jar:7.0.73]
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)[tomcat-catalina-7.0.73.jar:7.0.73]
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)[tomcat-catalina-7.0.73.jar:7.0.73]
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)[tomcat-catalina-7.0.73.jar:7.0.73]
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)[tomcat-catalina-7.0.73.jar:7.0.73]
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:958)[tomcat-catalina-7.0.73.jar:7.0.73]
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)[tomcat-catalina-7.0.73.jar:7.0.73]
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)[tomcat-catalina-7.0.73.jar:7.0.73]
    10 frames
  33. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087)[tomcat-coyote-7.0.73.jar:7.0.73]
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)[tomcat-coyote-7.0.73.jar:7.0.73]
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)[tomcat-coyote-7.0.73.jar:7.0.73]
    3 frames
  34. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_79]
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_79]
    2 frames
  35. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-coyote-7.0.73.jar:7.0.73]
    1 frame
  36. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)[na:1.7.0_79]
    1 frame