Share jOOQ on Facebook
Share jOOQ on Twitter

Manuals, Documentation, Tutorials

3.x Documentation

Version Javadoc Manual
3.5 HTML HTML HTML (multi-page) PDF
3.4 HTML HTML HTML (multi-page) PDF
3.3 HTML HTML HTML (multi-page) PDF
3.2 HTML HTML HTML (multi-page) PDF
3.1 HTML HTML HTML (multi-page) PDF
3.0 HTML HTML HTML (multi-page) PDF

2.x Documentation

Version Javadoc Manual
2.6 HTML HTML HTML (multi-page) PDF
2.5 HTML HTML HTML (multi-page) PDF
2.4 HTML
2.3 HTML

Getting started with the tutorial

Your simplest entry point is probably to get the tutorial running. It shows how to use jOOQ and its code generator with a simple MySQL database

Our jOOQ Presentation at GeeCON

Our "NoSQL? No, SQL!" Presentation at JavaZone

FAQ

Before you go on and read the whole manual, there are a couple of interesting questions that you might want to consider:

Portability

Q: When I generate source code from MySQL, can I also use it on another database?

A: Yes! The generated Java code will work for all supported databases, not only for the database driver that you used when you generated the code.

Multi-Tenancy

Q: When I generate source code from my developer database, can I also use it on production?

A: Yes! You can map your schema at code generation time or at run time. See the manual for details.

Plain SQL

Q: Can I use jOOQ without code generation?

A: Yes! You can define tables, fields, conditions using Strings. See the manual for details.

Spring

Q: Can I use jOOQ as a query builder and execute queries with Spring?

A: Yes! This has been done by other users and will be documented soon. See this Stack Overflow question for details.

Transactions

Q: Does jOOQ manage transactions?

A: No, it doesn't and that's good! There are so many competing transaction models, jOOQ wouldn't choose the right one for you. See this Stack Overflow question for details.

NoSQL

Q: Does jOOQ support MongoDB?

A: No, jOOQ wouldn't be so good at modelling SQL in Java, if NoSQL elements had to be supported in the API. In return, our engineers have become SQL and JDBC pros.

Further Reading

jOOQ is about SQL. We recommend you also read these excellent resources, which talk about SQL in general:

SQL Performance Explained by Markus Winand, author of Use-The-Index-Luke.com Markus Winand has created Use-The-Index-Luke.com. His book explains nicely how to achieve proper indexing and performance in popular RDBMS:

Author Markus Winand
Title SQL Performance Explained
Languages English, German, French
SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he’s sharing his collection of antipatterns—the most common errors he’s identified in those thousands of requests for help:

Author Bill Karwin
Title SQL Antipatterns
Languages English

Convince Your Manager

Are you a developer, architect? Are you conviced by jOOQ, but now need to convince your manager? We have assembled a couple of good reasons explaining how your business unit will get a high ROI with jOOQ quickly.

Any other questions?

Do you still have open questions? Do not hesitate to contact us through our various support channels:

Or, just drop us a message.

The jOOQ Logo