Thanks for the quick reply.
> There should indeed be a generated Tables class within the > test.generated package, so the import should be correct. I have to > admit, though, that I have never actually executed this tutorial, as > it was contributed in a similar form by Ikai Lan: > http://ikaisays.com/2011/11/01/getting-started-with-jooq-a-tutorial/ > > Maybe I should review it for integrity... I have registered #1997 for > this: > https://github.com/jOOQ/jOOQ/issues/1997 > > I think I now know the issue here - the problem is with the way that eclipse lists in it's proposal window for import statements. It does not seem able to handle having 2 options that only differ in case ('Table' for the class and 'table' for the package) so I missed the case issue and ended up importing 'table' instead of 'Table'. Something else I now come across in the docs that may not be as clear as it could is as follows - or I could be getting it all wrong(again). In section "4.4.10 Date and time functions" a number of available functions are listed, I hit 2 issues a) In the docs there is no clear example for how they are used. b) The SQL functions are listed, which do not have the same case or layout as the Java functions. After a bit of searching around I was able to resolve the issue, but I need to gain a wider understanding of things first. So as way of an example here is a code snip for others // insert a record into a table called Importfiles with the following columns and get back the allocated PK // // PK - autoincrement - so 0 is inserted and it's final result is requested back // DETAILS - text // TIMEADDED - timestamp - to be set by executing the current_timestamp() function at the database server // // coded with jOOQ 2.6 Result<ImportfilesRecord> result1 = create.insertInto(IMPORTFILES, IMPORTFILES.PK, IMPORTFILES.DETAILS, IMPORTFILES.TIMEADDED) .values(0, "some text", currentTimestamp()) .returning(IMPORTFILES.PK) .fetch(); One nice thing to report is that all your logging seems to work fine with the log4j 2.0 betas Roger
