Skip to Main Content
Java Persistence with Hibernate
book

Java Persistence with Hibernate

by Gavin King, Christian Bauer
October 2006
Intermediate to advanced content levelIntermediate to advanced
880 pages
22h 11m
English
Manning Publications
Content preview from Java Persistence with Hibernate

15.2. Using native SQL queries

HQL, JPA QL, or criteria queries should be flexible enough to execute almost any query you like. They refer to the mapped object schema; hence, if your mapping works as expected, Hibernate's queries should give you the power you need to retrieve data any way you like. There are a few exceptions. If you want to include a native SQL hint to instruct the database management systems query optimizer, for example, you need to write the SQL yourself. HQL, JPA QL, and criteria queries don't have keywords for this.

On the other hand, instead of falling back to a manual SQL query, you can always try to extend the built-in query mechanisms and include support for your special operation. This is more difficult to do with HQL ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Java Persistence with Hibernate, Second Edition

Java Persistence with Hibernate, Second Edition

Christian Bauer, Gary Gregory
Pro JPA 2 in Java EE 8: An In-Depth Guide to Java Persistence APIs

Pro JPA 2 in Java EE 8: An In-Depth Guide to Java Persistence APIs

Mike Keith, Merrick Schincariol, Massimo Nardone
Beginning Hibernate 6: Java Persistence from Beginner to Pro

Beginning Hibernate 6: Java Persistence from Beginner to Pro

Joseph B. Ottinger, Jeff Linwood, Dave Minter

Publisher Resources

ISBN: 9781932394887Publisher SupportOtherPublisher WebsiteSupplemental ContentPurchase Link