Hi All,

I have created index on an hibernate entity mapped to a database view. How Can I handle/update index when view refresh. Is there any event when view reloads

Is this related to Hibernate Search or is it an index in the database and you're referring to ORM?

It is regarding hibernate search indexing only

Hibernate Search has no way of knowing when your DB view has been refreshed.

One option would be to start the mass indexer to rebuild the index after the view has been refreshed: https://docs.jboss.org/hibernate/search ... batchindex. Or, if you can narrow down the affected entities/records, manually index these entities: https://docs.jboss.org/hibernate/search ... _the_index

Depending on which database you use, you may find a way to automatically trigger re-indexing through Hibernate Search after the view has been refreshed. For instance in Oracle DB, there is the Advanced Queueing API which allows you to enqueue messages into a persistent JMS queue from triggers/PL-SQL scripts which you then can consume in your Java application and trigger re-indexing. It may be doable similarly for other databases.

Hth,

--Gunnar