Hello again, Very nice, this is working and an acceptable workaround !
thanks for the quick response & keep up the great work cheers bert On 20 Okt., 09:34, Lukas Eder <[email protected]> wrote: > 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
