Hi Philippe, I'm sorry, this mail got lost in my inbox...
2013/6/6 <[email protected]> > Hello Lukas, > I'm still there. > I have starded to read as many things as I can to understand jOOQ (official > documentation, some very interesting discussions on the user group about > pro > and cons for some design decisions, ...). > I'm impatient to have a view of the "BNF" used to design the DSL. > Yes, I'm a bit impatient as well. However, I haven't had time to fully delve into this area in a way for it to be ready to be published in jOOQ 3.1... > I'm currently very busy, professionaly and privately ... but I'm still very > interested in participating in a manner or an other to your project : > perhaps on > the parsing of sql text to construct jOOQ DSL objects. For sure, it's a big > challenge and, in a certain point a view, more complex than constraining > SQL in > java by the jOOQ DSL. But, it's exciting, isn't it ? :D > Yes, it is exciting! However, at first, this only serves for documentation purposes, when we'll generate API -> BNF -> Railroad diagrams with Christopher's RRDiagram tool: https://github.com/Chrriis/RRDiagram Writing a parser for jOOQ SQL is another story. You could even write a JDBC driver, if you want (and dare) ;-) > Concerning the problem with codegen, I really improved the OracleDatabase > class, > by using an auto detection of the database capabilities (testing for > existence > of certain views or columns as in OracleRoutineDefinition), and my version > is > compatible with all three versions of Oracle (9, 10 and 11). No older > version > to test :D > If you want, I can send you the code (after readaptation for the jOOQ java > package hierarchy - I have coded the improved class in my own package). > Just > tell me ! > Sure! You can send any code snippets to the user group, or provide a pull request if you prefer Cheers Lukas > > Friendly > > Philippe > > > Selon Lukas Eder <[email protected]>: > > > Hi Philippe, > > > > Just checking back with you... > > > > 2013/5/13 Philippe Colin <[email protected]> > > > > > > > > > > > Le mercredi 8 mai 2013 19:49:13 UTC+2, Lukas Eder a écrit : > > >> > > >> > > >> 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< > 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< > 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< > 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 < > 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< > 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 ;-) > > > > > > > ... were you able to make some progress with your attempts of fixing > Oracle > > 10g1 support? Is there anything I can help you with? > > > > Cheers > > Lukas > > > > > -- 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.
