Available in versions: Dev (3.16) | Latest (3.15) | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | 3.7

JDBC meta data

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

This is the default implementation of Database meta data, which is backed by JDBC's java.sql.DatabaseMetaData. If you configure your DSLContext with a JDBC Connection or DataSource, you can access its meta data like this:

create.meta()
      .getTables()
      .forEach(System.out::println);

The above may print the tables from our sample database.

AUTHOR
BOOK
BOOK_STORE
BOOK_TO_BOOK_STORE
LANGUAGE

Beware that by default, the entire catalog might be loaded to ensure referential integrity of all tables and their constraints. If you're only interested in a limited subset of your schema, you can use the various filter methods:

create.meta()
      .filterSchema(s -> s.getName().equals("PUBLIC"))
      .getTables()
      .forEach(System.out::println);

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo