Getting Started with jOOQ : Building SQL Queries in Java

Published: 19 April 2018
on channel: Thorben Janssen
32,063
428

JPA and Hibernate are a great fit to implement persist and update use cases, and simple queries. But most applications need a lot more than that. You need to be able to use the full feature set of SQL to implement your queries. That’s why JPA supports native queries. But it’s not comfortable to use. You probably don’t want to provide your query as a simple String or to handle the differences between the various database dialects yourself.
Other libraries are much better suited to implement complex SQL queries. One of them is jOOQ. It provides you with a Java DSL that enables you to build SQL queries in a comfortable and type-safe way. It abstracts the technical difficulties of plain JDBC and handles the subtle differences of the various SQL dialects.
In this video, I will give you a basic introduction to jOOQ so that you can start using it in your application. And in my next video, I will show you how to integrate it with Hibernate.
Before we get started, please make sure you subscribed to my channel and clicked the bell icon, so that you get new videos every week.

Download jOOQ- https://www.jooq.org/download

Configure jOOQ's code generator- https://www.jooq.org/doc/3.10/manual/...

If you like this video, please give me your thumbs up and share it with your friends and co-workers.

Like my channel? Subscribe!
➜ http://bit.ly/2cUsid8

Join the free Member Library:
https://goo.gl/dtyIIC

Read the accompanying post: https://www.thoughts-on-java.org/gett...

Want to connect with me?
Blog: http://www.thoughts-on-java.org/
Twitter:   / thjanssen123  
Facebook:   / thoughtsonjava  


On this page of the site you can watch the video online Getting Started with jOOQ : Building SQL Queries in Java with a duration of hours minute second in good quality, which was uploaded by the user Thorben Janssen 19 April 2018, share the link with friends and acquaintances, this video has already been watched 32,063 times on youtube and it was liked by 428 viewers. Enjoy your viewing!