Hi Volodymyr, Hmm, I'm not 100% sure if I understand your use-case, but I believe you're looking for the runtime schema mapping feature, right? http://www.jooq.org/doc/3.7/manual/sql-building/dsl-context/runtime-schema-mapping
With this, you can modify the schema name while you generate a query... Let me know if this helps, Lukas 2016-02-09 16:41 GMT+01:00 Volodymyr Mudryk <[email protected]> : > Hi Lukas. > > Thanks for the quick response. > > I have multiple schemas, so I'm using "renderSchema = true". > And I wish dynamically generate SQL without relation to the some schema. > After when SQL was generated, I wish execute on some existing schema (the > decision on which schema will execute query will made after generation of > the query) and, in the some cases, I wish execute query on a new schema, > that will created after generation of the query. > > Volodymyr. > > On Tuesday, February 9, 2016 at 5:25:20 PM UTC+2, Lukas Eder wrote: >> >> Hi Volodymyr. >> >> Thank you very much for your enquiry. >> >> Would you mind explaining the rationale behind your idea? I mean, why >> would you want to do the exact opposite of what the flag says? :) >> >> Best Regards, >> Lukas >> >> 2016-02-09 16:13 GMT+01:00 Volodymyr Mudryk <[email protected]>: >> >>> Hi. >>> >>> If we have "renderSchema = false" (in the JOOQ settings) - then the >>> "getSql()" method will return query without the schema alias. For example: >>> "SELECT * FROM `ACCOUNT`" >>> If we have "renderSchema = true" - then the "getSql()" method will >>> return query with the schema alias. For example: "SELECT * FROM >>> `<SOME_SCHEMA_NAME>`.`ACCOUNT`" >>> and it's ok. >>> >>> Would it be possible to, for example, when we're using the "getSql()" >>> method will return query without the schema alias if we have "renderSchema >>> = true" and vice versa ? >>> >>> Thanks, >>> Volodymyr Mudryk. >>> >>> -- >>> 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]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
