xxxxxxxxxx
@Component
public class MaterializedViewRefresher {
@Autowired
private EntityManager entityManager;
@Transactional
@Scheduled(fixedRate = 5000L)
public void refresh(){
this.entityManager.createNativeQuery("call refresh_mat_view();").executeUpdate();
}
}