Hello Ian, That is precisely what jooq-meta expects: "auto_increment". I'm afraid that everything looks ok to me. To further analyse this, you could try these two things:
- Debug jooq-meta and set a breakpoint around here to see what's happening: https://github.com/lukaseder/jOOQ/blob/master/jOOQ-meta/src/main/java/org/jooq/util/mysql/MySQLTableDefinition.java#L114 - Run jooq-codegen with log4j and log-level trace. You could post that log output somewhere, I could have a look. Here's a sample log4j configuration (change "debug" to "trace"): https://github.com/lukaseder/jOOQ/blob/master/jOOQ-test/src/log4j.xml Cheers Lukas 2012/3/25 Ian Clarke <[email protected]>: > Here we go: > > mysql> SELECT extra FROM information_schema.columns > -> WHERE lower(table_name) = 'campaigns' > -> AND lower(column_name) = 'id'; > +----------------+ > | extra | > +----------------+ > | auto_increment | > +----------------+ > 1 row in set (0.05 sec) > > Does this help? > > Ian. > > On Sun, Mar 25, 2012 at 11:07 AM, Lukas Eder <[email protected]> wrote: >> >> Hello Ian, >> >> > In case it's useful, here is the mysql dump of the campaigns table: >> > >> > https://gist.github.com/46e5fa5f5a768725eb7c >> >> I tried running the code generator on your table with my setup and it >> correctly generated an identity for campaigns.id. So the problem is >> not related to your JDBC driver. There's probably a bug in >> jooq-codegen's MySQL integration. >> >> >> - What version of MySQL are you using? jOOQ officially supports 5.1 and >> >> above >> > >> > I'm using 5.5.20 >> >> Maybe there is some feature in the MySQL dictionary views, that I am >> not aware of. What does the following query return on your system? >> >> SELECT extra FROM information_schema.columns >> WHERE lower(table_name) = 'campaigns' >> AND lower(column_name) = 'id' >> >> Cheers >> Lukas > > > > > -- > Ian Clarke > Blog: http://blog.locut.us/ >
