How to call native SQL queries with JPA and Hibernate

JPQL is the most common way to query data from a database with JPA. It enables you to reuse your mapping definitions and is easier to use than SQL. But it supports only a small subset of the SQL standard, and it also provides no support for database-specific features.
So what shall you do if you need to use a database-specific query feature or your DBA gives you a highly optimized query that you can’t transform into JPQL? Just ignore it and do all the work in the Java code?
Of course not! JPA has its own query language, but it’s designed as a leaky abstraction and supports native SQL queries. You can create these queries in a similar way as JPQL queries, and they can even return managed entities if you want.
In this video, I will show you how to use native SQL queries, different options to map the query result to DTOs and entity objects and avoid a common performance pitfall.
Links mentioned in the video:
thorben-janssen.com/jpql/
thorben-janssen.com/dto-proje...
thorben-janssen.com/persist-p...
thorben-janssen.com/jpa-nativ...
thorben-janssen.com/jpa-2-2-r...
thorben-janssen.com/result-se...
thorben-janssen.com/result-se...
thorben-janssen.com/result-se...
thorben-janssen.com/result-se...
thorben-janssen.com/entities-...
thorben-janssen.com/hibernate...
thorben-janssen.com/hibernate...
thorben-janssen.com/tips-to-b...
Like my channel? Subscribe!
➜ bit.ly/2cUsid8
Read the accompanying post: thorben-janssen.com/jpa-nativ...
Want to connect with me?
Blog: thorben-janssen.com/
Twitter: / thjanssen123
Facebook: / thorbenjanssenofficial
Linkedin: / thorbenjanssen

[@pathummadhusanka2496]

No fancy stuff. Straight to the point. You always deliver quality and knowledge rich content. Thank you sir ❤

[@enfieldli9296]

Really enjoy your work here, keep up the good stuff!

[@sovrinfo]

BIG BIG Thanks you!!

[@orhankelesk2709]

nice new look by the way, stick with it.

[@jasper5016]

The most awaited video. Do we trade-off any performance with native queries? Can you pls share this source code on github?

[@diniscab]

Hi, I have quite a really specific problem that I wanted to find a solution for in this video. What is the best way, when using JPA with EclipseLink, to use the IN clause in a nativeQuery with EntityManager? I always have a lot of problems. Thanks in advance!

[@mohangabhale5555]

I am using Linux Ubuntu os, i want hibarnate external jar files for eclipse

[@nicholas1460]

JPA is bloatware.