Hi Florent, I'll just guess what happened, because you didn't show:
- Your code generation configuration - Your SQL script - The exact error message / stack trace You're using an Oracle specific syntax that the DDLDatabase cannot parse. Supporting only a "reasonable" amount of SQL syntax is a known limitation of the DDLDatabase, it will never be able to parse everything vendor specific, see also the manual: https://www.jooq.org/doc/latest/manual/code-generation/codegen-ddl/ You can either use our special comment syntax to let the jOOQ parser ignore unsupported stuff (e.g. storage clauses): https://www.jooq.org/doc/latest/manual/code-generation/codegen-ddl/#ignoring-unsupported-content Or switch to a more reliable approach for complex vendor-specific feature support, e.g. using testcontainers: https://blog.jooq.org/using-testcontainers-to-generate-jooq-code/ I hope this helps, Lukas On Fri, Sep 6, 2024 at 1:30 PM Florent Bonamis <[email protected]> wrote: > I found the example on how to generate code starting from a sql file > It works very well with the provide file but when I tried to add a table > with a schema it does not like it > I am using the trial version to be sure that oracle is supported: > > Your SQL string could not be parsed or interpreted. This may have a > variety of reasons, including: > - The jOOQ parser doesn't understand your SQL > - The jOOQ DDL simulation logic (translating to H2) cannot simulate your > SQL > > > -- > 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 on the web visit > https://groups.google.com/d/msgid/jooq-user/6e2a08bb-7e4a-4e80-af84-e5903679cde2n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/6e2a08bb-7e4a-4e80-af84-e5903679cde2n%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 on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6a9HEpaVhjFh0Jhd5qgzEhhVSxs__15Jfz3ddG1CJ6xA%40mail.gmail.com.
