Ignore this duplicate entry ;)
On 27 fév, 14:42, florian adler <[email protected]> wrote: > Hi Lukas, > > Thanks for your answer. > Definitively, using jooq meta instead of jdbc meta could provide > 'smart' reverse-engineering feature than couple of minuteproject could > benefit. > > For the list of limitations, minuteproject uses the first 3: > - column nullability > - column defaults > - column precision and scale > > Do you load comments for table and column? > > Cheers, > > Florian. > On 27 fév, 13:47, Lukas Eder <[email protected]> wrote: > > > > > > > > > Hi Florian, > > > I'm cc'ing this to the jooq-user group, as this might be of general > > interest... > > > > I am looking with interest to JOOQ in couple of way that can be useful for > > > Minuteproject. Not only Minuteproject 4 Jooq but Jooq 4 Minuteproject ;). > > > > The way you load master data native and then much more faster that with > > > jdbc > > > metadata and exhaustive (loading enums...). Impressive. > > > I am using DDLUtils that most of the time works fine but has limitations. > > > Ex > > > when the jdbc driver is not correctly implemented (ex: sqlite). > > > Indeed, I had thought about this before, too. The reason why I > > rejected using JDBC's DatabaseMetaData is the fact that part of the > > JDBC API is poorly implemented even by the best JDBC drivers (this > > includes Oracle's ojdbc). This is partially because the meta data API > > is very primitive itself and from an advanced SQL perspective rather > > useless compared to the SQL 1992 standard INFORMATION_SCHEMA - or for > > instance, Oracle's vendor-specific dictionary tables. Some insight can > > be found here: > > >http://lukaseder.wordpress.com/2011/09/11/database-schema-navigation-... > > > So, in essence, it might make perfect sense for you to create a > > dependency on jooq-meta to navigate essential database objects. Maybe, > > at the moment, you may be missing 1-2 features, though. I designed > > jooq-meta as a primary tool for jooq-codegen. So far, I had no need > > for any of these features: > > > - column nullability > > - column defaults > > - column precision and scale > > - check constraints > > - storage clauses (e.g. tablespace, index-organised tables, partitioning, > > etc) > > - non-unique indexes > > - grants and users/roles > > - synonyms > > > > On the other hand do you view case for managing the first set of JOOQ > > > templates? > > > I have yet to look at this. The recent release was quite exhaustive > > with the exciting new features added to the jOOQ core :-) > > > Cheers > > Lukas > > > 2012/2/27 florian adler <[email protected]>: > > > > Hi Lukas, > > > > I am looking with interest to JOOQ in couple of way that can be useful for > > > Minuteproject. Not only Minuteproject 4 Jooq but Jooq 4 Minuteproject ;). > > > > The way you load master data native and then much more faster that with > > > jdbc > > > metadata and exhaustive (loading enums...). Impressive. > > > I am using DDLUtils that most of the time works fine but has limitations. > > > Ex > > > when the jdbc driver is not correctly implemented (ex: sqlite). > > > > I have also to learn of your distribution aspects (maven/ant) and generic > > > design. > > > > Nice job! > > > > On the other hand do you view case for managing the first set of JOOQ > > > templates? > > > > Best regards, > > > > Florian.
