You can wrap syntax that jOOQ's parser doesn't understand with a special
comment syntax explained here:
https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-parser/
On Fri, Aug 22, 2025 at 11:55 AM tuk wrote:
> Thanks for replying.
>
> I am using Jooq 3.19.25
Thanks for replying.
I am using Jooq 3.19.25 Open source edition. I tried something like below
class TableExtractorTest {
@Test
@SneakyThrows
void test() {
String sql = new
String(Files.readAllBytes(Paths.get("/tmp/create_db.sql")));
Parser parser = DSL.using(SQLDi
Hello,
You can use jOOQ's query object model API to extract all tables from your
parsed queries:
https://www.jooq.org/doc/latest/manual/sql-building/model-api/
It will be easiest to achieve using Traversers:
https://www.jooq.org/doc/latest/manual/sql-building/model-api/model-api-traversal/
https:
We are using JOOQ with MySQL 8 for generating Java code.
Can someone let me know if it is possible to also use JOOQ as a parser to
extract all table names referenced in a MySQL .sql file? The .sql file can
contain both DDL, DML statements.
--
You received this message because you are subscrib