The jOOQ User Manual. Multiple Pages

This version of the manual is outdated. For the latest version, follow this link: http://www.jooq.org/doc/3.0/manual.

# Overview

This manual is divided into four main sections:

• jOOQ classes and their usage

  See these chapters for an overview of the jOOQ internal architecture and all types that are involved with jOOQ's query creation and execution. This is the important part for you, also, if you wish to extend jOOQ

• Meta model code generation

  See these chapters to understand how you can use jOOQ as a source code generator, and what type of artefacts are generated by jOOQ

• DSL or fluent API. Where SQL meets Java

  See these chapters to learn about how to use jOOQ in every day's work. The jOOQ DSL is the main way to create and execute jOOQ queries almost as if SQL was embedded in Java directly

• Advanced topics

  Some advanced topics including not-everyday functionality

# Table of contents

1. jOOQ classes and their usage
   1. The example database
   2. The Factory class
   3. Tables and Fields
   4. Results, Cursors and Records
   5. CRUD and Updatable Records
   6. The Query and its various subtypes
   7. ResultQuery and fetch() methods
   8. Bind values and parameters
   9. QueryParts and the global architecture
   10. Serializability of jOOQ objects
   11. Extend jOOQ with custom types
2. Meta model code generation
   1. Configuration and setup of the generator
   2. Advanced generator configuration
   3. The schema, top-level generated artefact
   4. Tables, views and their records
   5. Procedures and packages
   6. UDT's including ARRAY and ENUM types
   7. Sequences and Serials
3. DSL or fluent API. Where SQL meets Java
   1. Complete SELECT syntax
   2. Table sources
   3. Conditions
   4. Aliased tables and fields
   5. Nested SELECT using the IN operator
   6. Nested SELECT using the EXISTS operator
   7. Other types of nested SELECT
   8. UNION and other set operations
   9. Functions and aggregate operators
   10. Stored procedures and functions
   11. Arithmetic operations and concatenation
   12. The CASE clause
   13. Type casting
   14. When it's just easier: Plain SQL
4. Advanced topics
   1. Master data and enumeration tables
   2. Custom data types and type conversion
   3. Mapping generated schemata and tables
   4. Execute listeners and the jOOQ Console
   5. Adding Oracle hints to queries
   6. The Oracle CONNECT BY clause
   7. The Oracle 11g PIVOT clause
   8. jOOQ's relational division syntax
   9. Exporting to XML, CSV, JSON, HTML, Text
   10. Importing data from XML, CSV
   11. Using JDBC batch operations