刷新Spring Data Repository中的Oracle实体化视图 [英] Refresh an Oracle Materialized view in a Spring Data Repository

问题描述

在查询Spring Data Repository之前，我需要刷新Oracle数据库中的物化视图。我试图通过存储库中的函数使用本地查询来完成此操作，如下所示。

I need to refresh a materialized view in an Oracle database before I query the Spring Data Repository. I'm attempting to do this via a function in the Repository with a native query, like the following.

@Query("BEGIN DBMS_SNAPSHOT.REFRESH('MY_VIEW', 'C'); END;", nativeQuery = true)
fun refreshMaterializedView()

但是，在调用此方法时，我得到了 java.lang.NegativeArraySizeException ，但它在直接在数据库上运行时工作正常。我在这里做错了什么？是否有另一种方法来强制物化视图刷新？

However, I am getting java.lang.NegativeArraySizeException when calling this method, although it works fine when being run directly on the database. What am I doing wrong here? Is there an alternative way to force the materialized view to refresh?

推荐答案

您需要使用 @Modifying 。它是真正用于DML语句，但也适用于此。

You need to annotate your method with @Modifying. It is really intended for DML statements but works for this as well.

@Modifying
@Query("BEGIN DBMS_SNAPSHOT.REFRESH('MY_VIEW', 'C'); END;", nativeQuery = true)
fun refreshMaterializedView()

这篇关于刷新Spring Data Repository中的Oracle实体化视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！