Thanks Lukas. What happens if I call execute() on the insertInto stmt? Does that "clear" the previous values? Yes, I agree that this level of optimization is probably not needed for my application.
On Mon, Mar 31, 2014 at 11:01 PM, Lukas Eder <[email protected]> wrote: > 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 a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/jooq-user/YIGSzwInQkE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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.
