Hi all.
I'm using jOOQ as query builder for Spring, to build SQL string
[ generated with the getSQL() method ] with JdbcTemplate.
For example, insertions like this..
q = jooq.create.insertInto(TABLE)
.set(WBS_NODE.ONE, oneValue)
.set(WBS_NODE.TWO, twoValue)
.set(WBS_NODE.THREE, threeValue);
..generate SQL like this:
" .. ("one", "two", "three") values (?, ?, ?) .. "
The problem is that if the variable twoValue is null when the query is
created above, the SQL will be:
" .. ("one", "two", "three") values (?, null, ?) .. "
This is a problem for me, I want ALWAY the "?."
So, there's any way to avoid the "null optimization?"
P.S: there are other tricky optimizations in the generated SQL ??
