can anyone change this query to hibernate query:

INSERT INTO dbo.tbl_correspondence(receiptdate, duedate, document, status)
SELECT bat.batch_receipt_date , bat.batch_receipt_date+30 , DE.Image, 'Active' FROM dbo.Tbl_DataEntry DE INNER JOIN
dbo.tbl_batches bat ON bat.batch_batch_number = DE.BatchId INNER JOIN dbo.tbl_DataEntryFormType typ ON typ.Id = bat.FormId
WHERE (typ.Id IN (3, 4, 5, 13, 14, 15, 16, 17))

thanks,
Bharath
pepala_bharath@yahoo.com

i think the "insert into..select" paradimgm goes against the concept of ORM tools where you manage entities and not jsut do insert updates.

Also you have to keep in mind that for Hibernate to be efficient it needs to perisit idependently. For e.g. first and second level caching will be possible only if Hibernate is called for persisting the entities. In your case there's no direct Hibernate friendly way of doing a batch insert. You could however iterate over the result set and do a .save() and fush() respectively.

You might want to look at this posting too:

http://forum.hibernate.org/viewtopic.php?t=951350&highlight=