Hi Michael, Thanks for trying 3 times. Good things come to those who wait ;)
I'll just reply to your first email. https://groups.google.com/forum/#!topic/jooq-user/eQn-Sz6UnvA Cheers, Lukas On Thu, Oct 4, 2018 at 2:37 PM Maverick Skywalker < [email protected]> wrote: > Hello Guys :) > > I'm new and still testing jOOQ how I can use it in the best way. (I don't > know why my second try was deleted!) > > I'am using jOOQ 3.11.5 with JDK 1.8. > > *1)* Is it intended that a CRUD insert also creates a select statement > after the insert? (*MariaDB.log* - red marked line) I personally would > say it's overhead especially because the update statement don't do that, > but what do say the professionals? > *2*) Is there any way to eliminate the "set autocommit" line? I want to > disable auto commit at all but don't found any option. (*MariaDB.log* - > orange marked line) > > session.transaction(configuration -> { > DSLContext tx = DSL.using(configuration); > > AuthorRecord author = tx.newRecord(AUTHOR); > > > //author = tx.newRecord(AUTHOR); > author.setId(13); > author.setFirstName("Bard"); > author.setLastName("Simpson"); > author.insert(); > > author.setId(11); > author.setFirstName("Homer"); > author.setLastName("Simpson"); > author.update(); > }); > > MariaDB.log > 181004 13:12:22 876 Query set autocommit=0 > 876 Query SET STATEMENT max_statement_time=60 FOR INSERT INTO > library.author (id, first_name, last_name) VALUES (13, 'Bard', 'Simpson') > 876 Query SET STATEMENT max_statement_time=60 FOR SELECT > library.author.id FROM library.author WHERE library.author.id = 13 > 876 Query SET STATEMENT max_statement_time=60 FOR UPDATE > library.author SET library.author.id = 11, library.author.first_name = > 'Homer', library.author.last_name = 'Simpson', library.author.date_of_birth > = NULL, library.author.year_of_birth = NULL, library.author.distinguished = > NULL WHERE library.author.id = 11 > 876 Query COMMIT > 876 Query set autocommit=1 > > -- > 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. > -- 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.
