Sorry, I forgot to run that when you originally asked :) unfortunately, I've put everything *back* in terms of the .24 driver, and I can't duplicate the issue :( I'm usually pretty good at maintaining my scientific controls, but I must have affected something to cause this to be ok now..?
going to try to set up an isolated environment to try this again; I'll get back to you S On Mon, Apr 29, 2013 at 3:26 PM, Lukas Eder <[email protected]> wrote: > > > > 2013/4/29 Shan Syed <[email protected]> > >> Thanks Lukas - I just regenerated my code using the same driver version >> as you, and it worked! >> >> Note: there must be something amiss with version 5.1.24 of the driver >> (mysql-connector-java-5.1.24.jar). >> >> I am using mysql (community edition) 5.6.11.0. >> > > Interesting. What happens when you execute the JDBC code that I've shown > in my answer, using driver version 5.1.24? > > ------------------------------------------------ > PreparedStatement stmt = > connection.prepareStatement( > "insert into `greeting` ( `greetingText` ) VALUES ( 'text' )", > Statement.RETURN_GENERATED_KEYS); > > stmt.executeUpdate(); > // Use jOOQ to consume the generatedKeys ResultSet > create.fetch(stmt.getGeneratedKeys()); > ------------------------------------------------ > > Will this work? Maybe a regression in the JDBC driver? > > >> >> On Sun, Apr 28, 2013 at 4:46 PM, Lukas Eder <[email protected]> wrote: >> >>> Hello, >>> >>> I cannot reproduce the issue you're experiencing. Your first piece of >>> code yields "-> 36" on my instance, as expected. I'm using MySQL 5.5.27 >>> with mysql-connector-java-5.1.15-bin.jar >>> >>> 2013/4/26 <[email protected]> >>> >>>> Hey there - I'm new to JOOQ and playing around with it for possible use >>>> on my next project. >>>> >>>> I'm using MySQL + JOOQ 3.0.0-RC3 >>>> >>>> here's a quick snippet: >>>> >>>> DSLContext create = DSL.using(this.connection, SQLDialect.MYSQL); >>>>> >>>>> >>>>>> GreetingRecord record = create.newRecord(GREETING); >>>>> >>>>> record.setGreetingtext("blah"); >>>>> >>>>> >>>>>> record.store(); >>>>> >>>>> System.out.println("-> " + record.getId()); >>>>> >>>>> >>>> the ID isn't populated >>>> >>>> I've tried various permutations of this, with no luck: >>>> >>>> create.insertInto(GREETING, >>>>> GREETING.GREETINGTEXT).values(greeting.getGreetingText()).returning( >>>>> GREETING.ID).fetch().getValues(GREETING.ID); >>>>> >>>> >>>> here's the DDL of the table: >>>> >>>> CREATE TABLE `greeting` ( >>>>> >>>>> `id` bigint(20) NOT NULL AUTO_INCREMENT, >>>>> >>>>> `greetingText` text COLLATE utf8_bin NOT NULL, >>>>> >>>>> PRIMARY KEY (`id`) >>>>>> >>>>> ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 >>>>>> COLLATE=utf8_bin$$ >>>>> >>>>> >>>>>> >>>> the inserts succeed, but I can't seem to get the generated key back; >>>> I'd like to use JOOQ directly and not dive down into the JDBC statement >>>> layer >>>> >>>> I think I'm just misunderstanding how to use the API - is there a >>>> direct way to return the ID/key MySQL auto incremented for me? >>>> >>> >>> No, the way you're using the API is correct and is supposed to work with >>> MySQL. Can you execute the query using JDBC and >>> Statement.getGeneratedKeys() ? >>> >>> i.e. what happens when you run >>> >>> PreparedStatement stmt = >>> connection.prepareStatement( >>> "insert into `greeting` ( `greetingText` ) VALUES ( 'text' )", >>> Statement.RETURN_GENERATED_KEYS); >>> >>> stmt.executeUpdate(); >>> // Use jOOQ to consume the generatedKeys ResultSet >>> create.fetch(stmt.getGeneratedKeys()); >>> >>> -- >>> 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/groups/opt_out. >>> >>> >>> >> >> -- >> 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/groups/opt_out. >> >> >> > > -- > 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/groups/opt_out. > > > -- 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/groups/opt_out.
