I am trying to use jooq to generate sql for an insert statement to be used
in a jdbc prepared statement.
For 'select' I can use StatementType.PREPARED_STATEMENT as a setting, but I
can not figure out how to get this to work with 'insert':
Settings settings = new Settings();
> settings.setStatementType(StatementType.PREPARED_STATEMENT);
> final Factory create = new OracleFactory(con,settings);
>
> System.out.println(create.insertInto(Factory.tableByName("test_table")).set(Factory.fieldByName("test_column"),Factory.val(1)));
Generates:
insert into "test_table" ("test_column") values (1)
I tried using several other things in set(...) but none generated a
statement with the correct ?
Any help would be greatly appreciated.
Thanks
Timm