I want to sum all incomes and outcomes (simplified problem). In ordinary SQL I would use UNION, but HQL doesn't support it. I fount the following alternatives:
1) using ordinary SQL query,
2) manually sum incomes and outcomes in java :-(
3) write super class of income and outcome class :-(

Did I miss any alternative? Why HQL doesn't support union? Is it going to?

Another similar question: If I update data via createSQLQuery(), is second level cache synchronized?

Thank you for your help!

Marko

I have not yet heard of a reasonable usecase for this. Your usecase is NOT reasonable, since it is not very OO. You get back a list of incomes and outcomes, which do not seem to share a baseclass or interface, and hence cannot be handled polymorphically.

(Hibernate3 has union-subclass, which uses a union to implement polymorphic queries, but that assumes the existence of a base class or interface.)

Thank you, Gavin, for your help and time.

I am begging for another answer: If I update data via createSQLQuery(), is second level cache synchronized (updated)?

Marko

You can't update via createSQLQuery.

Thanks.

Marko

Set operations are usefull, but not in this case, store things like "incomes" and "outcomes" in the same table:


If you can not change DB then use View.