Hello Bert, > But i also have to evaluate, if it is possible to get only the SQL > Statement out of the SQL Builder and execute the statement outside of > jooq, e.g. over Spring JDBC Template => so i used the getSQL() Method.
That's an interesting approach. I've seen that before, e.g. here: http://stackoverflow.com/questions/4474365/jooq-and-spring#6796688 > But here the schema mapping is not considered => is this the expected > behaviour ? That is not expected. Both SQLDialect and SchemaMapping should be considered in this case. I'll further analyse this potential bug: https://sourceforge.net/apps/trac/jooq/ticket/880 > is there any way/workaround to do this ? Does this work, in the mean time? Factory factory = new Factory(connection, dialect, mapping); String sql = factory.render(query); Cheers Lukas
