Hello
I need to do some reporting on a rather complex domain model, and right now I've created some SQL views which collect the data. Then with a SQL query of the form:
Code:
SQLQuery query = session.createSQLQuery("SELECT foo, bar FROM example_view");
I collect that data and display.
The disadvantage is that I've now pushed some logic in the database (to construct the view). If the domain model changes, I'll have to update the view as well, etc.
Any thoughts about that? Should I try to do it with hibernate? The view is pretty complex right now, and if I did that with hibernate I would need many more queries.
thanks