CodeGenerator 3.14.1 fails on Oracle Timestamp with precision

[Patrick Brunmayr]

Following DDL given

CREATE TABLE API_CLIENT 

(

  ID RAW(16) NOT NULL 

, API_CONSUMER_ID RAW(16) NOT NULL 

, APP_ID VARCHAR2(256 CHAR) NOT NULL 

, ACTIVE NUMBER(*, 0) DEFAULT 1 NOT NULL 

, LAST_MODIFIED TIMESTAMP(6) NOT NULL 

, PRICING_DOMAIN VARCHAR2(256 CHAR) NOT NULL 

, TRUSTED NUMBER(*, 0) DEFAULT 0 NOT NULL 

, NAME VARCHAR2(128 CHAR) 

, CREATED TIMESTAMP(6) NOT NULL 

) 

will create this field in the Table

public final TableField<ApiClientRecord, LocalDateTime> CREATED = createField(DSL.name("CREATED"), SQLDataType.LOCALDATETIME(6).nullable(false), this, "");

which leads to error

error: cannot find symbol

    public final TableField<ApiClientRecord, LocalDateTime> LAST_MODIFIED = createField(DSL.name("LAST_MODIFIED"), SQLDataType.LOCALDATETIME(6).nullable(false), this, "");

                                                                                                                              ^

  symbol:   method LOCALDATETIME(int)

  location: class SQLDataType

It seems there is no matching constructor with a precision. How to fix this?

[Patrick Brunmayr]

So it seems it got fixed in 3.14.3 ?

[Lukas Eder]

Hi Patrick,

Thanks for your message.

There hasn't been any such fix in jOOQ 3.14.3. But I don't think we have such a problem, currently. The most likely reason why you're seeing this kind of compilation error is because you're generating code with jOOQ version X and trying to compile it with an older jOOQ version Y. This can happen, for example, due to a transitive dependency that you might be using via Spring Boot or some other framework. If you're using Maven, please check "mvn dependency:tree" to see the jOOQ version, see also:

https://blog.jooq.org/2019/06/26/how-to-use-jooqs-commercial-distributions-with-spring-boot/

Thanks,

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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/58b1849d-a83f-4e05-baba-6ab0b550430an%40googlegroups.com.

[Patrick Brunmayr]

I downloaded the enterprise version, installed it in my local maven and tried to use it from gradle script so there is no other dependency

[Lukas Eder]

Can you show the gradle script?

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/949e6042-6745-4e0f-bb7d-47df66f3013en%40googlegroups.com.

[Patrick Brunmayr]

When i run it i get this

cvc-complex-type.2.4.a: Ung�ltiger Content wurde beginnend mit Element '{"http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":primaryKeyTypes}' gefunden. '{"http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":generatedAnnotationDate, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":constructorPropertiesAnnotation, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":constructorPropertiesAnnotationOnPojos, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":constructorPropertiesAnnotationOnRecords, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":pojosAsJavaRecordClasses, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":pojosAsScalaCaseClasses, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":pojosAsKotlinDataClasses, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":jpaVersion, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":globalDomainReferences, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":commentsOnEmbeddables, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":generatedSerialVersionUID, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":maxMembersPerInitialiser, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":newline, "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd":indentation}' wird erwartet.

i added this

configurations['classpath'].resolutionStrategy.eachDependency {
if (requested.group == 'org.jooq') {
useVersion '3.14.1'
}
}

[Patrick Brunmayr]

jooqGenerator - The classpath used to invoke the jOOQ code generator. Add your JDBC driver, generator extensions, and additional dependencies here.

+--- org.jooq:jooq-codegen -> org.jooq.pro:jooq-codegen:3.14.1

|    +--- org.jooq.pro:jooq:3.14.1

|    |    +--- org.reactivestreams:reactive-streams:1.0.2 -> 1.0.3

|    |    \--- javax.xml.bind:jaxb-api:2.3.1

|    |         \--- javax.activation:javax.activation-api:1.2.0

|    \--- org.jooq.pro:jooq-meta:3.14.1

|         \--- org.jooq.pro:jooq:3.14.1 (*)

[Patrick Brunmayr]

The gradle configuration

jooq {

  version = project.ext.get('jooq.version')

  edition = nu.studer.gradle.jooq.JooqEdition.PRO

  configurations {

    main { // name of the jOOQ configuration

      generateSchemaSourceOnCompilation = true // default (can be omitted)

      generationTool {

        logging = org.jooq.meta.jaxb.Logging.WARN

        jdbc {

          driver = 'oracle.jdbc.driver.OracleDriver'

          url = 'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=atlogoracletest.pbs.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PRBPDE.db.logitek.at)))'

          user = 'PRICING_BPDE'

          password = 'PRICING_BPDE'

        }

        generator {

          name = 'org.jooq.codegen.DefaultGenerator'

          database {

            name = 'org.jooq.meta.oracle.OracleDatabase'

            inputSchema = 'PRICING_BPDE'

            outputSchemaToDefault = true

            includes = ['API_CLIENT', 'API_CLIENT_PRICE_TYPE', 'API_CLIENT_SCOPE', 'API_CONSUMER', 'API_SCOPE', 'CUSTOMER', 'CUSTOMER_ACE', 'CUSTOMER_PRICE_CONTAINER', 'CUSTOMER_PRICE_CONTAINER_ACE', 'CUSTOMER_PRICE_CONTAINER_URN', 'CUSTOMER_URN', 'DEALER', 'DEALER_ACE', 'DEALER_PRODUCT_CATALOG', 'DEALER_PRODUCT_CATALOG_ACE', 'DEALER_PRODUCT_CATALOG_URN', 'DEALER_URN', 'PRICE', 'PRICE_CALCULATION_TYPE', 'PRICE_CONTAINER', 'PRICE_CONTAINER_ACE', 'PRICE_CONTAINER_URN', 'PRICE_TYPE', 'PRICE_TYPE_URN', 'PRICE_URN', 'PRODUCT', 'PRODUCT_ACE', 'PRODUCT_CATALOG', 'PRODUCT_CATALOG_ACE', 'PRODUCT_CATALOG_PRODUCT', 'PRODUCT_CATALOG_PRODUCT_URN', 'PRODUCT_CATALOG_URN', 'PRODUCT_URN'].join("|")

          }

          generate {

            deprecated = false

            records = true

            immutablePojos = false

            fluentSetters = false

          }

          target {

            packageName = 'at.logitek.pricing.model.core.persistence.jooq'

            directory = 'build/generated-src/jooq/main' // default (can be omitted)

          }

          strategy.name = 'org.jooq.codegen.DefaultGeneratorStrategy'

        }

      }

    }

  }

}

[Patrick Brunmayr]

It seems its related to this plugin. Works with 3.13.5

[Lukas Eder]

Thanks for your update. That looks correct as far as the code generation is concerned. But how do you compile the generated output?

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/d6bda473-48f9-4d7d-8522-7b8dcd80155fn%40googlegroups.com.

[Patrick Brunmayr]

I just copy the generated sources into a project folder. Then when i wanted to compile it got those errors. 

Maybe a future version of this plugin will handle a newer jooq version?

[Lukas Eder]

From what I can tell from their documentation, there are two versions that you can specify. The one you specified affects only code generation (I think?)

The other one can be seen here:

https://github.com/etiennestuder/gradle-jooq-plugin#gradle-groovy-dsl-2

So, this one:

version = project.ext.get('jooq.version')  

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/375150ae-500b-4507-af08-f9b6ce7c0d4bn%40googlegroups.com.

[Patrick Brunmayr]

Yeah the  v5.2  is the plugin version. In their release they wrote ->  Upgrades to jOOQ 3.13.5   

I tried exactly this

version = project.ext.get('jooq.version')  // '3.14.1

but i think there is an issue with xml code generation. It complains the xml is not valid. Then i did

configurations['classpath'].resolutionStrategy.eachDependency {
if (requested.group == 'org.jooq') {
useVersion '3.14.1'
}
} 

Then the generation works but it generates the wrong java code. 

When i am using 3.15.3 without anything it works like a charme

[Lukas Eder]

I've had another go at trying this myself, and I could reproduce the XSD errors that you've seen. The third party plugin can load the JAXB classes from different jOOQ versions to map the Groovy/Kotlin configuration to. You seem to have been on the right track with your useVersion directive, which I believe you've taken from here?

https://github.com/etiennestuder/gradle-jooq-plugin/blob/master/example/specify_jooq_config_xml_schema_version/build.gradle

I don't know what may have gone wrong with version 3.14.1, but when I tried this with 3.14.3, things seem to work for me:

buildscript {

    configurations['classpath'].resolutionStrategy.eachDependency {
        if (requested.group == 'org.jooq') {

            useVersion '3.14.3'
        }
    }
}

plugins {
    id 'nu.studer.jooq' version '5.2'
    id 'java'
}

repositories {
    jcenter()
    mavenLocal()
}

dependencies {
    jooqGenerator 'com.h2database:h2:1.4.200'
}

jooq {
    version = '3.14.3'
    edition = nu.studer.gradle.jooq.JooqEdition.TRIAL_JAVA_8

    configurations {
        main {

            generationTool {
                logging = org.jooq.meta.jaxb.Logging.WARN
                jdbc {

                    driver = 'org.h2.Driver'
                    url = 'jdbc:h2:~/jooq-test-codegen-gradle;AUTO_SERVER=TRUE'
                    user = 'sa'
                    password = ''
                }
                generator {
                    database {
                        name = 'org.jooq.meta.h2.H2Database'
                        includes = '.*'
                        excludes = ''
                    }
                    target {
                        packageName = 'nu.studer.sample'
                    }
                }
            }
        }
    }
}

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/96316444-15b1-49a6-bb8b-058ae8605e19n%40googlegroups.com.