У меня есть запрос на выборку в Hibernate, который выдает исключение ConstraintViolationException.
Метод:
public RfaSchoolWorkflow findViaCasePrepForm(CasePrepForm model) {
TypedQuery query = createQuery("select rfa from RfaSchoolWorkflow rfa where rfa.schoolCasePrepForm.casePrepForm = :cpf");
query.setParameter("cpf", model);
return QueryUtil.single(query);
}
Исключение:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_B"."ID")
В этом запросе нет триггера. Как запрос SELECT может вернуть ConstraintViolationException?
Здесь я прочитал это это может быть связано с тем, что Hibernate кэшировал ранее созданный оператор, но по какой-то причине еще не выполнил оператор вставки. Прежде чем выполнить мой оператор SELECT, Hibernate каким-то образом видит необходимость выполнить кэшированный оператор INSERT. Выполнение INSERT приводит к исключению ConstraintViolationException, поэтому программа не получает изменений для выполнения моего SELECT.
Также здесь у людей, похоже, есть аналогичная проблема.
Я просмотрел весь код, но не нашел ничего, что могло бы попытаться вставить данные в TABLE_A. Есть ли способ запретить спящему режиму выполнять операторы в кеше и, следовательно, решить проблему?
Полная трассировка стека:
09:17:33.042 [http-nio-8080-exec-5] ERROR a.e.w.e.b.d.RfaStudentWorkflowDaoImpl - An error occurred while finding RfaStudentWorkflow for CasePrepForm: CasePrepForm:343014
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.Query.getResultList(Query.java:165) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at com.gsu.de.eddept.guice.util.QueryUtil.single(QueryUtil.java:78) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.dao.RfaStudentWorkflowDaoImpl.findViaCasePrepForm(RfaStudentWorkflowDaoImpl.java:346) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.RfaStudentWorkflowServiceImpl.findViaCasePrepForm(RfaStudentWorkflowServiceImpl.java:64) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.getDelegate(CasePrepFormAccessControlServiceImpl.java:114) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.canRead(CasePrepFormAccessControlServiceImpl.java:74) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.canRead(CasePrepFormAccessControlServiceImpl.java:19) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.checkReadAccess(ExternalIdManagerImpl.java:587) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.decodePublicId(ExternalIdManagerImpl.java:122) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.decodeKey(ExternalIdManagerImpl.java:65) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.resolver.PersistentEntityResolver.getModel(PersistentEntityResolver.java:82) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.resolver.PersistentEntityResolver.getModel(PersistentEntityResolver.java:12) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.getModel(AbstractCommonModelMapper.java:133) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:142) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.mapper.RfaStudentWfModelMapper.populateModelFields(RfaStudentWfModelMapper.java:161) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.mapper.RfaStudentWfModelMapper.populateModelFields(RfaStudentWfModelMapper.java:35) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.ssta.mapper.AbstractAuditedEntityModelMapper.populateModel(AbstractAuditedEntityModelMapper.java:123) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.ssta.mapper.AbstractAuditedEntityModelMapper.populateModel(AbstractAuditedEntityModelMapper.java:25) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:153) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:94) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$SaveProcessor.prepare(RfaStudentServiceImpl.java:229) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl.saveStudentRfa(RfaStudentServiceImpl.java:493) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5.CGLIB$saveStudentRfa$6() ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5$$FastClassByGuice$$50bbf3ee.invoke() ~[bes-server-3.0.0.jar:?]
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) ~[guice-4.2.3.jar:?]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76) ~[guice-4.2.3.jar:?]
at com.gsu.de.eddept.guice.GwtServiceMethodInterceptor.invoke(GwtServiceMethodInterceptor.java:61) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78) ~[guice-4.2.3.jar:?]
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54) ~[guice-4.2.3.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5.saveStudentRfa() ~[bes-server-3.0.0.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) ~[gwt-servlet-2.10.0.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) ~[servlet-api.jar:4.0.FR]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) ~[servlet-api.jar:4.0.FR]
at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.IndexPageCacheFilter.doFilter(IndexPageCacheFilter.java:39) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.guice.UserNameScopingFilter.doFilter(UserNameScopingFilter.java:33) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.GwtCacheFilter.doFilter(GwtCacheFilter.java:121) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.AjaxSecurityFilter.doFilter(AjaxSecurityFilter.java:59) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.BookmarkFilter.doFilter(BookmarkFilter.java:58) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.common.hibernate.HibernateFilter.doFilter(HibernateFilter.java:187) ~[common-hibernate-core-3.0.36-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.appreg.impl.SecurityFilterImpl.doSecurityFilter(SecurityFilterImpl.java:557) ~[?:?]
at com.gsu.de.eddept.appreg.servlet.SecurityFilter.doHttpFilterChain(SecurityFilter.java:99) ~[appreg-client-2.6.1.jar:?]
at com.gsu.de.eddept.appreg.client.error.ErrorPageFilter.doFilter(ErrorPageFilter.java:61) ~[appreg-client-2.6.1.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133) ~[guice-servlet-4.2.3.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[catalina.jar:9.0.81]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) ~[catalina.jar:9.0.81]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[catalina.jar:9.0.81]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.81]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:9.0.81]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) ~[tomcat-coyote.jar:9.0.81]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-coyote.jar:9.0.81]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.81]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.81]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.81]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1367) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1447) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
... 83 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_B"."ID")
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:628) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3735) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3910) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3889) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:992) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1367) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1447) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
... 83 more
Подробнее здесь: https://stackoverflow.com/questions/785 ... hed-insert
Hibernate ConstraintViolationException в запросе SELECT из-за кэшированного оператора INSERT ⇐ JAVA
Программисты JAVA общаются здесь
1716351795
Anonymous
У меня есть запрос на выборку в Hibernate, который выдает исключение ConstraintViolationException.
Метод:
public RfaSchoolWorkflow findViaCasePrepForm(CasePrepForm model) {
TypedQuery query = createQuery("select rfa from RfaSchoolWorkflow rfa where rfa.schoolCasePrepForm.casePrepForm = :cpf");
query.setParameter("cpf", model);
return QueryUtil.single(query);
}
Исключение:
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_B"."ID")
В этом запросе [b]нет триггера[/b]. Как запрос SELECT может вернуть ConstraintViolationException?
Здесь я прочитал это это может быть связано с тем, что Hibernate кэшировал ранее созданный оператор, но по какой-то причине еще не выполнил оператор вставки. Прежде чем выполнить мой оператор SELECT, Hibernate каким-то образом видит необходимость выполнить кэшированный оператор INSERT. Выполнение INSERT приводит к исключению ConstraintViolationException, поэтому программа не получает изменений для выполнения моего SELECT.
Также здесь у людей, похоже, есть аналогичная проблема.
Я просмотрел весь код, но не нашел ничего, что могло бы попытаться вставить данные в TABLE_A. Есть ли способ запретить спящему режиму выполнять операторы в кеше и, следовательно, решить проблему?
Полная трассировка стека:
09:17:33.042 [http-nio-8080-exec-5] ERROR a.e.w.e.b.d.RfaStudentWorkflowDaoImpl - An error occurred while finding RfaStudentWorkflow for CasePrepForm: CasePrepForm:343014
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.Query.getResultList(Query.java:165) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at com.gsu.de.eddept.guice.util.QueryUtil.single(QueryUtil.java:78) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.dao.RfaStudentWorkflowDaoImpl.findViaCasePrepForm(RfaStudentWorkflowDaoImpl.java:346) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.RfaStudentWorkflowServiceImpl.findViaCasePrepForm(RfaStudentWorkflowServiceImpl.java:64) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.getDelegate(CasePrepFormAccessControlServiceImpl.java:114) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.canRead(CasePrepFormAccessControlServiceImpl.java:74) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.service.accesscontrol.CasePrepFormAccessControlServiceImpl.canRead(CasePrepFormAccessControlServiceImpl.java:19) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.checkReadAccess(ExternalIdManagerImpl.java:587) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.decodePublicId(ExternalIdManagerImpl.java:122) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.service.ExternalIdManagerImpl.decodeKey(ExternalIdManagerImpl.java:65) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.resolver.PersistentEntityResolver.getModel(PersistentEntityResolver.java:82) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.resolver.PersistentEntityResolver.getModel(PersistentEntityResolver.java:12) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.getModel(AbstractCommonModelMapper.java:133) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:142) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.mapper.RfaStudentWfModelMapper.populateModelFields(RfaStudentWfModelMapper.java:161) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.mapper.RfaStudentWfModelMapper.populateModelFields(RfaStudentWfModelMapper.java:35) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.ssta.mapper.AbstractAuditedEntityModelMapper.populateModel(AbstractAuditedEntityModelMapper.java:123) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.ssta.mapper.AbstractAuditedEntityModelMapper.populateModel(AbstractAuditedEntityModelMapper.java:25) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:153) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.guice.mapper.AbstractCommonModelMapper.applyToModel(AbstractCommonModelMapper.java:94) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$SaveProcessor.prepare(RfaStudentServiceImpl.java:229) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl.saveStudentRfa(RfaStudentServiceImpl.java:493) ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5.CGLIB$saveStudentRfa$6() ~[bes-server-3.0.0.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5$$FastClassByGuice$$50bbf3ee.invoke() ~[bes-server-3.0.0.jar:?]
at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228) ~[guice-4.2.3.jar:?]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76) ~[guice-4.2.3.jar:?]
at com.gsu.de.eddept.guice.GwtServiceMethodInterceptor.invoke(GwtServiceMethodInterceptor.java:61) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78) ~[guice-4.2.3.jar:?]
at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54) ~[guice-4.2.3.jar:?]
at com.gsu.de.eddept.bes.gwtservice.RfaStudentServiceImpl$$EnhancerByGuice$$68491dc5.saveStudentRfa() ~[bes-server-3.0.0.jar:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373) ~[gwt-servlet-2.10.0.jar:?]
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) ~[gwt-servlet-2.10.0.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) ~[servlet-api.jar:4.0.FR]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) ~[servlet-api.jar:4.0.FR]
at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.IndexPageCacheFilter.doFilter(IndexPageCacheFilter.java:39) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.guice.UserNameScopingFilter.doFilter(UserNameScopingFilter.java:33) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.GwtCacheFilter.doFilter(GwtCacheFilter.java:121) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.AjaxSecurityFilter.doFilter(AjaxSecurityFilter.java:59) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.filter.BookmarkFilter.doFilter(BookmarkFilter.java:58) ~[gwt-guice-server-2.0.0-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.common.hibernate.HibernateFilter.doFilter(HibernateFilter.java:187) ~[common-hibernate-core-3.0.36-SNAPSHOT.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.gsu.de.eddept.appreg.impl.SecurityFilterImpl.doSecurityFilter(SecurityFilterImpl.java:557) ~[?:?]
at com.gsu.de.eddept.appreg.servlet.SecurityFilter.doHttpFilterChain(SecurityFilter.java:99) ~[appreg-client-2.6.1.jar:?]
at com.gsu.de.eddept.appreg.client.error.ErrorPageFilter.doFilter(ErrorPageFilter.java:61) ~[appreg-client-2.6.1.jar:?]
at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121) ~[guice-servlet-4.2.3.jar:?]
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133) ~[guice-servlet-4.2.3.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[catalina.jar:9.0.81]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) ~[catalina.jar:9.0.81]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[catalina.jar:9.0.81]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) ~[catalina.jar:9.0.81]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.81]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:9.0.81]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) ~[tomcat-coyote.jar:9.0.81]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-coyote.jar:9.0.81]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-coyote.jar:9.0.81]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.81]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.81]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.81]
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1367) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1447) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
... 83 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_B"."ID")
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:628) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3735) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3910) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3889) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:992) ~[ojdbc8-21.1.0.0.jar:21.1.0.0.0]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502) ~[c3p0-0.9.5.5.jar:0.9.5.5]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3375) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3908) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1367) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1447) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617) ~[hibernate-core-5.6.4.Final.jar:5.6.4.Final]
... 83 more
Подробнее здесь: [url]https://stackoverflow.com/questions/78515003/hibernate-constraintviolationexception-on-select-query-because-of-cached-insert[/url]
-
- Похожие темы
- Ответы
- Просмотры
- Последнее сообщение
-
-
Как я могу позволить Hibernate объединить последовательные операторы INSERT в многозначный INSERT
Anonymous » » в форуме JAVAУ меня есть объект JPA, который выглядит следующим образом:
@Entity
@Table(name = timeseries_data )
public class TimeseriesDataEntry implements Serializable {
@Id
@Column(name = timeseries_id , nullable = false)
private String timeseriesID;
@Id... - 0 Ответы
- 63 Просмотры
-
Последнее сообщение Anonymous
-
-
-
Как я могу позволить Hibernate объединить последовательные операторы INSERT в многозначный INSERT
Anonymous » » в форуме JAVAУ меня есть объект JPA, который выглядит следующим образом:
@Entity
@Table(name = timeseries_data )
public class TimeseriesDataEntry implements Serializable {
@Id
@Column(name = timeseries_id , nullable = false)
private String timeseriesID;
@Id... - 0 Ответы
- 45 Просмотры
-
Последнее сообщение Anonymous
-
-
-
Исключение в потоке «основной» org.hibernate.Exception.ConstraintViolationException: не удалось выполнить оператор
Anonymous » » в форуме JAVAВ чем причина моей ошибки?
У меня есть сущности. Их отношение – многие ко многим.
препод:
@Entity(name = prepod )
public class Prepod {
private Long id;
List students = new ArrayList();
@ManyToMany
public List getStudents() {
return students;... - 0 Ответы
- 45 Просмотры
-
Последнее сообщение Anonymous
-
-
-
Org.hibernate.Exception.ConstraintViolationException при регистрации пользователя
Anonymous » » в форуме JAVAЯ пытаюсь создать процесс регистрации, вот мой код:
public class UserRegistrationDto {
private String firstName;
private String lastName;
private String password;
private String confirmPassword;
private String email;
private String confirmEmail;... - 0 Ответы
- 16 Просмотры
-
Последнее сообщение Anonymous
-
-
-
Исключение в потоке «основной» org.hibernate.Exception.ConstraintViolationException: не удалось выполнить оператор
Anonymous » » в форуме JAVAВ чем причина моей ошибки?
У меня есть сущности. Их отношение - многие ко многим.
препод:
@Entity(name = prepod )
public class Prepod {
private Long id;
List students = new ArrayList();
@ManyToMany
public List getStudents() {
return students;... - 0 Ответы
- 20 Просмотры
-
Последнее сообщение Anonymous
-
Перейти
- Кемерово-IT
- ↳ Javascript
- ↳ C#
- ↳ JAVA
- ↳ Elasticsearch aggregation
- ↳ Python
- ↳ Php
- ↳ Android
- ↳ Html
- ↳ Jquery
- ↳ C++
- ↳ IOS
- ↳ CSS
- ↳ Excel
- ↳ Linux
- ↳ Apache
- ↳ MySql
- Детский мир
- Для души
- ↳ Музыкальные инструменты даром
- ↳ Печатная продукция даром
- Внешняя красота и здоровье
- ↳ Одежда и обувь для взрослых даром
- ↳ Товары для здоровья
- ↳ Физкультура и спорт
- Техника - даром!
- ↳ Автомобилистам
- ↳ Компьютерная техника
- ↳ Плиты: газовые и электрические
- ↳ Холодильники
- ↳ Стиральные машины
- ↳ Телевизоры
- ↳ Телефоны, смартфоны, плашеты
- ↳ Швейные машинки
- ↳ Прочая электроника и техника
- ↳ Фототехника
- Ремонт и интерьер
- ↳ Стройматериалы, инструмент
- ↳ Мебель и предметы интерьера даром
- ↳ Cантехника
- Другие темы
- ↳ Разное даром
- ↳ Давай меняться!
- ↳ Отдам\возьму за копеечку
- ↳ Работа и подработка в Кемерове
- ↳ Давай с тобой поговорим...