Re: How to prevent addtional SELECT after INSERT to retrieve auto-assigned value of primary key with AUTO_INCREMENT (MySQL)?

Tue, 04 Sep 2018 23:42:39 -0700 

Hi Lukas,

no, none of the conditions are met.

I paste the full sample code including the table definition so that you can 
reproduce the behaviour on yourself.

/*
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 */
DSLContext database = applicationContext().getBean(DSLContext.class);
database.settings().setReturnAllOnUpdatableRecord(false);

TestRecord record = database.newRecord(Tables.TEST);
record.setName(UUID.randomUUID().toString());
record.store();
System.out.println(record.getId());


And here is the profile of the SQL statements executed by jOOQ:

[image: profiling.png] <about:invalid#zClosurez>


Hope this helps.

Marcus

-- 
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.

Reply via email to