Hello, There had been some fixes related to using DatabaseMetaData through jOOQ's DSLContext.meta(). This also positively affects the JDBCDatabase that you've been using. Here are the relevant fixes:
JDBCDatabase doesn't recognise Oracle's VARCHAR2 data type (and other vendor-specific data types) https://github.com/jOOQ/jOOQ/issues/2445 Tables collected through DSLContext.meta() return duplicate columns if multi-schema environments contain identical tables https://github.com/jOOQ/jOOQ/issues/2447 DSLContext.meta() returns Table objects for Oracle SYNONYMS, without providing columns https://github.com/jOOQ/jOOQ/issues/2448 JDBCDatabase doesn't use DataType.length(), precision(), and scale() https://github.com/jOOQ/jOOQ/issues/2449 Cannot set precision on TINYINT, SMALLINT, INT, BIGINT data types https://github.com/jOOQ/jOOQ/issues/2450 The above fixes will be included in jOOQ 3.1, and probably backported to jOOQ 3.0.1. A 3.1.0-SNAPSHOT for a preview of the fixes will be deployed shortly to the Sonatype SNAPSHOT repository: https://oss.sonatype.org/content/repositories/snapshots/org/jooq/ Any feedback welcome Cheers Lukas 2013/5/8 Lukas Eder <[email protected]> > > 2013/5/7 Philippe Colin <[email protected]> > >> Ok Lukas, the workaround with JDBCDatabase did its job ! >> jooq-codegen had generated the things I need to continue my work :-) >> > > Great, good to know. > > >> SQL 99 doesn't know VARCHAR2 and create Object Fields, but it's not a >> problem. >> > > Hmm, yes that is a problem, which should be fixed. I have registered #2445 > for this. Thanks for reporting. > https://github.com/jOOQ/jOOQ/issues/2445 > > I guess that with #2310, the SQLDialect could be auto-detected from the > JDBC connection: > https://github.com/jOOQ/jOOQ/issues/2310 > > >> I think I will try, if I hade some time, to create my own >> OraclePriorTo102Database.java dialect class and to see : >> - first, if I'm able to do that, >> - second, if there are no other problems for Oracle versions prior to >> 10.2 in the original OracleDatabase dialect class. >> > > That would be greatly appreciated. On the other hand, you might also > consider detecting the Oracle version dynamically. This is already done > today to distinguish 10g and 11g: > > https://github.com/jOOQ/jOOQ/blob/master/jOOQ-meta/src/main/java/org/jooq/util/oracle/OracleRoutineDefinition.java#L143 > > Of course, this could be improved, too, so I'm very open to suggestions. > > >> I'm very interested to participate in a manner or an other to this pretty >> good project. >> Please, let me know how I could do that ... >> > > Any contribution is greatly appreciated. Some information can be found > here: > http://www.jooq.org/community.php > > Note, there is a dedicated milestone for user contribution candidates here: > https://github.com/jOOQ/jOOQ/issues?milestone=20 > > Not all tasks are equially simple, though. What kind of work would you be > most interested in? > -- 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.
