Oh, I see, you took inspiration from this issue here, then: https://github.com/jOOQ/jOOQ/issues/6489
But the feature hasn't been implemented yet, so you can't use that approach... You could run such a query with manual code generation configuration: https://www.jooq.org/doc/latest/manual/code-generation/codegen-programmatic/ On Mon, Jun 13, 2022 at 6:54 PM lubo mihailov <[email protected]> wrote: > Hi > this is my configuration > <executions> > <execution> > <id>generate-mysql-schemaName</id> > <phase>generate-sources</phase> > <goals> > <goal>generate</goal> > </goals> > <configuration> > <jdbc> > <driver>${driverName}</driver> > <url>${url}</url> > <user>${user}</user> > <password>${password}</password> > </jdbc> > <generator> > <database> > <includes>.*</includes> > <excludes>SQL [ > SELECT GROUP_CONCAT(table_schema,'.', > table_name,'|') > FROM information_schema.views; > <!-- > SELECT CONCAT(table_schema,'.', table_name,'|') > FROM information_schema.views > SELECT CONCAT(table_schema,'.', table_name,'|') > FROM information_schema.tables; > SELECT GROUP_CONCAT(table_schema,'.', table_name,'|') > FROM information_schema.tables; > --> > </excludes> > <inputSchema>inputSchema</inputSchema> > </database> > <target> > <packageName>com.inputSchema</packageName> > <directory>${someDir}</directory> > </target> > <generate> > <sources>true</sources> > <sourcesOnViews>false</sourcesOnViews> > </generate> > </generator> > </configuration> > </execution> > </executions> > > В 19:31:01 ч. UTC+3на понеделник, 13 юни 2022 г. [email protected] > написа: > >> Hello, >> >> Can you please share the exact code generation configuration? >> Also, please do check if you picked the correct name case (upper / lower) >> >> On Mon, Jun 13, 2022 at 6:22 PM lubo mihailov <[email protected]> wrote: >> >>> Hi >>> i want to exclude all the views when i generate the code >>> I tried this approach >>> https://jooq-user.narkive.com/QKDrg2rp/code-gen-skip-views >>> but with no result. >>> Probably i missed something but i cant make it to skip them >>> i even add them manually but i still generate all the views >>> Example:: >>> tabe_schema.viewname_1|tabe_schema.viewname_2|tabe_schema.viewname_2 ... >>> And i still cant make it work. >>> Where i do it wrong. >>> >>> -- >>> 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/ccb86645-a51b-461c-a55c-b07b161fe233n%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/ccb86645-a51b-461c-a55c-b07b161fe233n%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/5196f7ef-3f4a-4792-aceb-223a168307b4n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/5196f7ef-3f4a-4792-aceb-223a168307b4n%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/CAB4ELO7dPvSBBq_P4gzNgqy4pFD%3DzCOOve24PvQLumb1QN0OEw%40mail.gmail.com.
