Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
XML meta data
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
jOOQ offers a JAXB serialisable XML representation of the standard SQL INFORMATION_SCHEMA: https://www.jooq.org/xsd/jooq-meta-3.16.0.xsd. This format can be imported and exported as org.jooq.util.xml.jaxb.InformationSchema, and converted to org.jooq.Meta:
// Using strings:
create.meta(
"<information_schema>...</information_schema>"
)
.getTables()
.forEach(System.out::println);
Alternatively:
// Using JAXB annotated API:
create.meta(informationSchema)
.getTables()
.forEach(System.out::println);
Assuming the following XML content:
<information_schema>
<tables>
<table>
<table_name>a</table_name>
<table_type>BASE TABLE</table_type>
</table>
<table>
<table_name>b</table_name>
<table_type>BASE TABLE</table_type>
</table>
<table>
<table_name>c</table_name>
<table_type>BASE TABLE</table_type>
</table>
</tables>
<columns>
<column>
<table_name>a</table_name>
<column_name>i</column_name>
<data_type>int</data_type>
<ordinal_position>1</ordinal_position>
<is_nullable>true</is_nullable>
</column>
<column>
<table_name>b</table_name>
<column_name>j</column_name>
<data_type>int</data_type>
<ordinal_position>1</ordinal_position>
<is_nullable>true</is_nullable>
</column>
<column>
<table_name>c</table_name>
<column_name>k</column_name>
<data_type>int</data_type>
<ordinal_position>1</ordinal_position>
<is_nullable>true</is_nullable>
</column>
</columns>
</information_schema>
The above prints all of the tables from the DDL scripts
a b c
All the meta data is available, including column names, types, constraints, etc.
XML can also be read from org.jooq.Source, which represents any string providing source, including files, input streams, etc.
Exporting XML
Any org.jooq.Meta implementation can be exported back to XML using Meta.informationSchema() (the JAXB annotated API, use JAXB to get the XML content).
Feedback
Do you have any feedback about this page? We'd love to hear it!