TL;DL; How to get inserted keys (.getReturnedRecords()) from custom built insert query executed using context.resultQuery()?
Hi, for selecting rows from db I use jooq query builder. In the end I export sql string using* query.getSQL(ParamType.INLINED). *Then I can do some regexp "fixing" on resulting SQL and pass it back to the *context.resultQuery()* and iterate over resultset. It works well for SELECT statements. However I need to INSERT data but I unfortunately still need to manually fix generated SQL. After passing fixed SQL into context.resultQuery() I cannot call .getResult().getReturnedRecords() because its result is not InsertQuery anymore. Casting seems not possible. Thanks. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
