Hi Alex > I tried to debug the code following the execution within jOOQ classes and it > seems that the SchemaMapping classes in the Factory hold correct values but > something goes wrong during SQL statement generation. > > Can anyone confirm this?
Thanks for your report. I generally cannot confirm this. Note though, that there has been a change #1315 in jOOQ 2.3.0 setting the default schema in generated factories: https://sourceforge.net/apps/trac/jooq/ticket/1315 So if you have two schemata A and B, and you use AFactory, BFactory to generate your SQL, the schema name is no longer rendered. Other than that, there has also been #1286, a setting that allows for entirely omitting schema name rendering: https://sourceforge.net/apps/trac/jooq/ticket/1286 Does any of this match your observations?
