oracle 上的实体化视图日志比上次刷新后的内容新 解决方案

本文介绍了在Oracle数据库中遇到实体化视图日志比上次刷新后的内容旧的问题,提出通过删除并重新创建Materialized views来解决此问题的方法。
摘要由CSDN通过智能技术生成
016-09-27 14:36:09,802 ERROR [500.jsp] - Could not commit JDBC transaction; nested exception is java.sql.SQLException: ORA-12048: 刷新实体化视图 "REPORT"."CHECK_FORM" 时出错
ORA-12034: "TEENAGERS"."CH_TASK" 上的实体化视图日志比上次刷新后的内容新


org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException: ORA-12048: 刷新实体化视图 "REPORT"."CHECK_FORM" 时出错
ORA-12034: "TEENAGERS"."CH_TASK" 上的实体化视图日志比上次刷新后的内容新


at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:275)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:478)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:272)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644)
at com.neusoft.modules.check.service.chtask.ChTaskService$$EnhancerBySpringCGLIB$$c94a6a55.save(<generated>)
at com.neusoft.modules.check.web.chtask.ChTaskController.save(ChTaskController.java:438)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
at org.springframework.web.servlet
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值