> > > Forcing the schema rendering on the Sch1Factory passing a > > new Settings().withRenderSchema(true) has no effect in my case. > > You don't have to use Sch1Factory. In fact, one of the features of the > generated [Schema-Name]Factory classes is the fact that it will omit > referencing [Schema-Name] in rendered SQL. Have you tried using just > PostgresFactory or Factory instead? >
That did the trick and solved all the issues! Using: Factory create=new PostgresFactory(conn); instead of Sch1Factory create=new Sch1Factory(conn); all the queries are correctly generated with schema prefixes. Now I better understand the purpose of the [Schema-Name]Factory classes with respect to the generic ones. Generating the classes for the whole db (no <inputSchema>) one can also conveniently make queries an tables of all schemas. Maybe this is worth mentioning in a clearer way in the docs. Thanks for your help. I will experiment some more in particular with geospatial usage and report any findings. Cheers > Lukas > Greets Alex
