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