Hi Joaquin, Thanks for your message. You shouldn't expect 100% coverage of all database specific SQL. jOOQ will implement more and more of these things, but you'll always run into limitations. For example, pg_timezone_abbrevs() is simply not supported, and I don't think that's something worth adding support for.
You can try to extend the parser using a ParseListener: https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-listener/ Or you could try your luck requesting new features in the parser or in jOOQ in general, if you think this is a generic enough vendor-specific feature whose translation / emulation could make sense: https://github.com/jOOQ/jOOQ/issues/new/choose I hope this helps, Lukas On Thu, Sep 4, 2025 at 1:56 PM 'Joaquin' via jOOQ User Group < [email protected]> wrote: > Hello! > > I'm trying to create "migrations"(there's no much documentation atm) from > an existent DB into a testcontainer one in another dialect without success, > @Lukas it's maybe not an intended use case, but would be an interesting one. > > don't know if I'm doing something wrong but I would appreciate any help! > > What I'm doing is: > - starting a test with spring (@JooqTest) + @Testcontainers > - jooq (for now) is using a real oracle database so let's call it "DSL" > - I'm creating a postgres container with testcontainers and creating a > DSLContext > with the jdbc url etc, let's call it postgresDsl > > so when the start up is ready I'm running: > > final Meta oracleMeta = dsl.meta(DefaultSchema.DEFAULT_SCHEMA); > final DDLExportConfiguration configuration = new DDLExportConfiguration(); > final Queries ddl = oracleMeta.ddl(configuration); > postgresDsl.meta().apply(ddl); > > > the apply method files miserably ( same thing when trying: > postgresDsl.meta().migrateTo(oracleMeta); > > some errors: > > org.jooq.impl.DDL : Cannot parse view source (to > skip parsing, use Settings.parseMetaViewSources): CREATE VIEW > "pg_timezone_abbrevs" AS SELECT abbrev, > utc_offset, > is_dst > FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, > is_dst); > > org.jooq.impl.ParserException: Keyword 'SELECT' expected: [4:29] > ...tc_offset, > is_dst > FROM pg_timezone_abbrevs([*]) pg_timezone_abbrevs(abbrev, utc_offset, > is_dst); > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/9c35d75c-aa4a-4814-b7f6-3e6df29a14dfn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/9c35d75c-aa4a-4814-b7f6-3e6df29a14dfn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5oL3kqhr3TDfwMAyHMG7K63U2zpUvKu6SJU-uLBqHpuA%40mail.gmail.com.
