Is it possible to use Hibernate with only stored procedures? My organization does not allow SQLs outside of stored procs and I am trying to see if Hibernate will work with only stored procedures.

For basic CRUD operations, I can define custom SQLs/SPs with sql-insert/sql-update/loader/etc. But what about joins?

Thanks for any info!

I think I figured out the answer for joins. You can define custom loaders under the "set" tags.

I am still looking for a definitive answer to whether Hibernate can be configured to work without using any generated SQL. Anyone?

Replying to myself again... from the Hibernate product evaluation FAQs: (https://www.hibernate.org/263.html)

Does Hibernate support handwritten SQL?

In Hibernate 3.0, any generated SQL statement may be overridden in the Hibernate mapping metadata. Hibernate also supports queries expressed in the native SQL dialect of the underlying database and offers facilities to integrate them cleanly into your application without creating dependencies. In practice, most users find that they need these features much less often than they expect.

In addition, Hibernate allows definition of "derived" entities and derived attributes, where a class or property maps to a SQL select or SQL formula embedded in the mapping document