DLL code generation from oracle db

[Florent Bonamis]

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

[Lukas Eder]

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

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/6e2a08bb-7e4a-4e80-af84-e5903679cde2n%40googlegroups.com.