Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,

    Check whether privilege has the "not null" restriction. If so it always has to have a value and can never be null.

    A different reason could be a wrong implementation of a foreign key. Check whether you always correctly insert/update in both tables.

  2. ,

    Nothing is wrong with the database. When it gives you those errors, it's telling you that you are trying to input "nothing" (null) into a column that doesn't allow it. Fix it by removing the not null constraint or by passing a value to that field.

Solutions on the web

via JIRA by Ramin Haeri Azad, 1 year ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
via JIRA by Ramin Haeri Azad, 2 years ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
via JIRA by Ramin Haeri Azad, 1 year ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
via JIRA by Ramin Haeri Azad, 2 years ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
via JIRA by Cédric Thiebault, 2 years ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
via JIRA by Cédric Thiebault, 1 year ago
org.hibernate.exception.ConstraintViolationException: could not execute statement
org.obiba.magma.MagmaRuntimeException: org.hibernate.exception.ConstraintViolationException: could not execute statement at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:18)[magma-api-1.8-SNAPSHOT.jar:1.8-SNAPSHOT] at org.obiba.opal.core.service.DefaultIdentifiersTableService.getDatasource(DefaultIdentifiersTableService.java:135)[opal-core-2.0-SNAPSHOT.jar:na] at org.obiba.opal.core.service.DefaultIdentifiersTableService.getValueTable(DefaultIdentifiersTableService.java:64)[opal-core-2.0-SNAPSHOT.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_45] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_45] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_45] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_45] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at com.sun.proxy.$Proxy31.getValueTable(Unknown Source)[na:na] at org.obiba.opal.web.FunctionalUnitsResource.getEntitiesTable(FunctionalUnitsResource.java:226)[opal-core-ws-2.0-SNAPSHOT.jar:na] at org.obiba.opal.web.FunctionalUnitsResource$$FastClassByCGLIB$$91182ae1.invoke(<generated>)[spring-core-3.2.5.RELEASE.jar:na] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)[spring-core-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)[spring-tx-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)[spring-aop-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.obiba.opal.web.FunctionalUnitsResource$$EnhancerByCGLIB$$5ffed1d9.getEntitiesTable(<generated>)[spring-core-3.2.5.RELEASE.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_45] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_45] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_45] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_45] at org.jboss.resteasy.core.ResourceLocatorInvoker.createResource(ResourceLocatorInvoker.java:81)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.core.ResourceLocatorInvoker.createResource(ResourceLocatorInvoker.java:60)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:102)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)[resteasy-jaxrs-3.0.5.Final.jar:na] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)[resteasy-jaxrs-3.0.5.Final.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)[javax.servlet-2.5.0.v201103041518.jar:na] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:652)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1329)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.obiba.opal.server.httpd.AuthenticationFilter.doFilterInternal(AuthenticationFilter.java:73)[opal-httpd-2.0-SNAPSHOT.jar:na] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.obiba.opal.server.httpd.OpalVersionFilter.doFilterInternal(OpalVersionFilter.java:39)[opal-httpd-2.0-SNAPSHOT.jar:na] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.5.RELEASE.jar:3.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1300)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:445)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1038)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:374)[jetty-servlet-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:972)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.Server.handle(Server.java:363)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:920)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:982)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)[jetty-http-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)[jetty-http-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)[jetty-server-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)[jetty-io-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)[jetty-io-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)[jetty-util-7.6.8.v20121106.jar:7.6.8.v20121106] at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)[jetty-util-7.6.8.v20121106.jar:7.6.8.v20121106] at java.lang.Thread.run(Thread.java:744)[na:1.7.0_45]Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2989)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3501)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:393)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:227)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:207)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:191)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:206)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:191)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:764)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.internal.SessionImpl.save(SessionImpl.java:756)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.hibernate.internal.SessionImpl.save(SessionImpl.java:752)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] at org.obiba.magma.datasource.hibernate.HibernateDatasource.onInitialise(HibernateDatasource.java:216)[magma-datasource-hibernate-1.8-SNAPSHOT.jar:1.8-SNAPSHOT] at org.obiba.magma.support.AbstractDatasource.initialise(AbstractDatasource.java:92)[magma-api-1.8-SNAPSHOT.jar:1.8-SNAPSHOT] at org.obiba.magma.support.Initialisables.initialise(Initialisables.java:14)[magma-api-1.8-SNAPSHOT.jar:1.8-SNAPSHOT] ... 66 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'opal-keys' for key 'UK_c270jcqlmvthpcasvusahxb7h' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.7.0_45] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[na:1.7.0_45] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.7.0_45] at java.lang.reflect.Constructor.newInstance(Constructor.java:526)[na:1.7.0_45] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2376)[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2360)[mysql-connector-java-5.1.27.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[commons-dbcp-1.4.jar:1.4] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)[hibernate-core-4.2.7.SP1.jar:4.2.7.SP1] ... 90 more