| The jOOQ User Manual. Multiple Pages : SQL execution : Exporting to XML, CSV, JSON, HTML, Text : Exporting JSON | previous : next |
All versions: 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Development versions: 3.14 | Unsupported versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 2.6
Exporting JSON
Available in ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
// Fetch books and format them as JSON String json = create.selectFrom(BOOK).fetch().formatJSON();
The above query will result in a JSON document looking like the following one:
{"fields":[{"name":"field-1","type":"type-1"},
{"name":"field-2","type":"type-2"},
...,
{"name":"field-n","type":"type-n"}],
"records":[[value-1-1,value-1-2,...,value-1-n],
[value-2-1,value-2-2,...,value-2-n]]}
Note: This format has changed in jOOQ 2.6.0
