Hi

I'm evaluating Hibernate 3.2 CR for a project where all database access must be via stored procedures. If any non-SP SQL is used to query the DB, I'm gonna be in a lot of trouble!

So, is it possible to use Hibernate and map associations to sets without any SQL being generated by Hibernate. I've tried using <loader query-ref> to load a class, but the SQL (SELECT ...) is generated anyway. Its quite likely that I'm using <loader query-ref> wrong, but I need to ask this question because if its not possible to configure / use Hibernate to only use SPs and never generate its own SQL in any circumstance, then it might not be the product for us. Which would be a crying shame.

Cheers

Patrick.

I've exactly the same problem. More of this, the queries generated by Hibernate are somewhat *huge* (union-mapping), so that all the memory is used up by static strings...

Any solution to this one, anyone?

Patric