I want to asynchronous update the index at regular time intervals, e.g. 1 time every day,
so I have to disable the automatic index after the transaction is committed, how can i do that?

I don't think Hibernate has any control over when an index in the database is updated. Your best bet is to check your database documentation to see if that is possible.

I'm not sure why you would want that, anyway. If an index is not updated when the data is inserted/updated/deleted in the table, then the index is unusable. The index wouldn't know about new/changed rows that were inserted/updated, or worse, point to rows that no longer exist.

I think he is asking about the Lucene search index...

Depends what you want to do:
- if you want to index changes made by hibernate but apply them only once a day, your best bet is to use the JMS back end. You just have to enable your Message Driven Bean to process the messages once a day. There is virtually no overhead in using this method for your front end.
- if you want to read data from the database and index what has changed once a day, you can implement a method that retrieve the appropriate data and run session.index(object) (check batch index in the doc). I expect to enhance this area in 3.1 (ie having the ability to do this automatic indexing for you)

But once again, unless the Db is updated behind Hibernate's back, 1 is preferable to 2, I think.

Ooops. Nevermind :)