Hi all,
Hibernate is a good tool. But in my project, some query is so complex, so I decided to use SQL directly for these query. I am using Hibernate 3.6.10. It provides a Work interface, we can execute my sql inside the doWork() method of Session interface. But I found my sql query return nothing even thought I added a record just before this query using Hibernate session save() method. I check hibernate source codes, and found no flush occurs before Work execution. So, I think I must call session flush() method manually before executing my sql query. Flush frequently will cause performance issues. So my question is if hibernate provide a graceful method for user to execute sql query directly and keep the sql query consistent with hibernate session?

Can anyone give some advice?

Hello,
Have a look at that link:
http://www.mkyong.com/hibernate/hiberna ... -examples/
Hope it helps.

Thanks fsouleil. Your reply is so important for me. I have checked the source codes, the native sql can resolve my problem.

I had tested this case again, and I found hibernate could not flush the add action to the database. My code is as below:


The above getNamedQuery() method return a empty list. I don't know why hibernate does not flush the insert action to the database.

Any one has good ideas?

I guess you've got trouble with the first level cache.
You can try:
- Flush session explicitidly
- Implement hashcode and equals method for your bo Quotation based on a functional key (not the id field)
Regards

Hi fsouleil, thanks for your reply. I had addressed this issue by specifying the flush-mode of the sql-query, just like following:


When I tracked the source codes, I found hibernate use quereySpaces and flush-mode to decide whether to flush before sql-query execution or not. But I could not find where to specify the querySpaces for sql-query. sql-query could be locate inside or outside the CLASS elemnt in the *.hbm.xml file. So I tried to move the sql-query inside the CLASS element, but hibernate throwed exception when executed the sql-query. It could not find the sql-query. This confused me.