Manuals, Documentation, Tutorials
3.x Documentation |
||
| Version | Javadoc | Manual |
|---|---|---|
| 3.9 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.8 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.7 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.6 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.5 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.4 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.3 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.2 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.1 | HTML | HTML HTML (multi-page) PDF EPUB |
| 3.0 | HTML | HTML HTML (multi-page) PDF EPUB |
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
jOOQ and JavaEE with Arun Gupta from Red Hat
10 SQL Tricks That You Didn't Think Were Possible / Devoxx FR
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:
 |
Markus Winand has created Use-The-Index-Luke.com. His book explains nicely how to achieve proper indexing and performance in popular RDBMS:
|
 |
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:
|
 |
Vlad Mihalcea, author of the Flexy Pool library has condensed his persistence tuning experience into a single book in the making. A must-read for everyone aiming for pushing their RDBMS to the limit with a Java application:
|
 |
Manuel Bernhardt has extensive experience in Scala and Reactive programming, showing how to go reactive with Play, Akka, and jOOQ in his book in the making:
|
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:
- Free Community Support through the official jOOQ User Group
- Free Community Support through Stack Overflow
Or, just drop us a message.
