Le mercredi 8 mai 2013 19:49:13 UTC+2, Lukas Eder a écrit : > > > 2013/5/7 Philippe Colin <[email protected] <javascript:>> > >> 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. > In fact, I have improved the code of the OracleDatabase class and put it in my own java package (and then reference it in the classpath of jooq-codegen and in the xml file). I did something like it has been done in OracleRoutineDefinition (before you've suggested it, really :-), for I thought it was an elegant way to code). It was ok with the Oracle 10.1 database ! But then, I had another problem with an Oracle 9 database (a legacy application which doesn't want to die ... I need to access one Oracle 10.1 databases, one Oracle 9 database and one MS SQL Server -I"m not sure of its version- in my use-case). The ALL_MVIEW_COMMENTS view is not present in Oracle 9. I have to do some researches in Oracle documentation to find the good view to use, if it exists ... For the moment, I have no time to install Eclipse and configure all the things needed to do a good job for the jOOQ project, but I could send you the "improved" OracleDatabase.java code ... > >> 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? > That's a good question :D. I have to read more about the jOOQ project, to understand the milestones and goals. I think I will be more interested by improvements or new features, but I have to read more ... I'll stay you informed as soon as possible ;-) Kindest regards Philippe Colin -- 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.
