Simon Martinelli Do you really need Hibernate? 

• 30 years of Software Engineering • Java for 25 years • Self-employed since 2009 • University teacher for 18 years • JUG Switzerland, Location Bern About Me 

JTAF - Track and Field - https://jtaf.ch 

No content

• Most conceptual differences between JPA and jOOQ are not technology-specific, but a matter of how you think about your database interactions • There are two approaches • Working with entity state transitions • Working with data set transformations • Neither approach is "the best" one! Both approaches are better suited to particular use cases JPA vs jOOQ 

No content

• Example Project • https://github.com/simasch/jooq-examples • Official Documentation • https://jooq.org • jOOQ Demo • https://github.com/jOOQ/demo Where to Start? 

• jOOQ assumes your database already exists • But it does not assume your database follows any rules imposed by jOOQ regarding the design Database First 

DB jOOQ Generator Java Classes jOOQ DSL How does jOOQ work? 

• jOOQ can be used in projects of any size • It was inspired by the requirements of software running on thousands of tables, views, and stored procedures. Queries there were so complex they generated up to 500 lines of Oracle execution plan • I’ve used jOOQ in an ERP product with • ~ 2000 Tables and Views • ~ 5000 Stored Procedures and Functions Does jOOQ scale? 

No content

jOOQ and JPA 

• jOOQs superpower • Querying • Reading nested objects • Calling functions/stored procedures • Bulk updates and deletes • JPAs superpower • Entity state transition • Cascading insert, update, delete, and orphan removal And now? Which one to use? 

Thank you! • Web martinelli.ch • EMail [email protected] • Bluesky @martinelli.ch • LinkedIn https://linkedin.com/in/ simonmartinelli