Hello Mohit, 2014-03-31 22:51 GMT+02:00 Mohit Jaggi <[email protected]>:
> I am new to jooq and trying to start with the first step of using the DSL > to avoid SQL strings in my java code. I used the insertInto() API to create > an INSERT statement. I want to "cache" the statement but whenever I add a > values() to it, it adds a new VALUES to the statement instead of replacing > the existing one. Is there a clear() or reset() function? > Yes, this is how jOOQ manages multi-record insert statements. Why do you want to cache the INSERT statement? I suspect that you want to implement some memory optimisation, although I think that short-lived jOOQ statements shouldn't really be a problem. More info on that subject here: http://www.jooq.org/doc/latest/manual/sql-execution/performance-considerations/ > Also, doesn't jooq have create table and drop table in its DSL? > We're working on that for jOOQ 3.4: https://github.com/jOOQ/jOOQ/issues/883 Cheers Lukas -- 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.
