hi All,

Am inserting objects in bulk using HQL as described in "DML style operation " here: http://docs.jboss.org/hibernate/core/3. ... tch-direct .

The inserted object is hibernate search enabled and has annotations for being indexed. Insertion is successful, yet Lucene search index are not updated. My questions are:

1. do DML style operations skip indexing ?
2. are these newly inserted objects loaded in memory ever? or Hibernate only executes the SQL?

HQL is:
Insert into EntityA(someDate, status, entityB, someOtherId, yetAnotherId)
select current_date(), '1', entityB , 24, 1 from EntityB entityB where entityB.id in (46271)

It will be great if someone could confirm DML style operations' behavior.

regards,
Rajeev

Hi,

Automatic indexing is based on entity change events. In the DML style bulk updates you don't have these events and the entities are never loaded in memory.
If you check the Hibernate Search documentation you can see examples on how to to bulk insertions which will update the index. In particular look at the MassIndexer API which is explicitly written for bulk index changes. It has many options helping you to tune its performance as well.

Hope this helps.

--Hardy

hi Hardy,

Thanks for the quick reply !
have a great day!

cheers,
Rajeev