I am doing a project that include generating invoices for subscription service.
I have the INVOICES table where these invoices are stored and I mapped my Invoice class to it. I have no problems there but my applications is also suppose to new customers, who weren't yet been invoiced.
I have a complex almost a page long SQL query that joins seven tables and retrieves all invoice fields for these new customers. I can easily do it in plain old JDBC but cannot figure out how to incorporate this query into my hibernate-mapping.
Please gimme a tip.
Thanks