We had an odd one tonight.  We were finally in a good space to do an 
upgrade and be able to do a full regression test of our platform.  

Moving from jOOQ 3.7.4 to 3.9.1 causes all sorts of weird compile issues in 
Eclipse.  We did do a refresh of the project (gradle - buildship).  A few 
errors would came up about .eq() method no longer matching the String 
values in there.  Ok, easy enough to fix... but as soon as we touched the 
files 100+ error showed up saying that all of our staticly imported Tables 
are no longer available.   Odd! 

First the fix for the .eq() methods was that we were actually now 
generating .enum.TableEnum packages (which we were not before).  So the 
.eq("String") just changed to .eq(TableEnum.ENUM).  easy fix.  
For the odd compile and static errors we had to turn on 
globalTableReferences = true in our generator.  Another odd one since it's 
defaulted to true.  

Cleaned all of the projects, re-generated all of the jooq code and viola 
all worked perfect.  Still need to go through the tests which takes a week 
of on/off work but all of the automated tests worked. 

Below is a summary of the gradle build script changes in case anyone else 
runs into something similar:  We import the jooqBuilder.gradle script 
externally.

build.gradle:

plugins {
-    id 'nu.studer.jooq' version '1.0.6'
+    id 'nu.studer.jooq' version '2.0.3'
[...]
-    compile 'org.jooq:jooq:3.7.4'
+    compile 'org.jooq:jooq'
-    jooq 'org.jooq:jooq:3.7.4'
+    jooqRuntime 'mysql:mysql-connector-java:6.0.4'

jooqBuilder.gradle:

jooq {
+    version = '3.9.1'
+    edition = 'OSS'
     AP(sourceSets.main) {
         jdbc {
             driver = 'com.mysql.cj.jdbc.Driver'
@@ -113,6 +115,7 @@ jooq {
                 }
             }
             generate {
+                globalTableReferences = true
                 generatedAnnotation = true
                 relations = true
                 deprecated = false

-- 
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/d/optout.

Reply via email to