I'm looking into this again now, because someone else seems to have had the
same issue:
https://groups.google.com/g/jooq-user/c/pGuWEt-q8Es

The answer seems to be here:
https://github.com/etiennestuder/gradle-jooq-plugin#gradle-groovy-dsl-3

Things work when I add

buildscript {

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

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

I'll be happy to look into further issues, but again, showing what you did
*exactly* will be very helpful in helping you debug your issues.

Thanks,
Lukas

On Fri, Nov 6, 2020 at 6:25 PM Maurizio <[email protected]> wrote:

> I'm configuring jOOQ using the gradle plugin
>
> *id 'nu.studer.jooq' version '5.2'*
>
> It should be the latest version (
> https://plugins.gradle.org/plugin/nu.studer.jooq). Can it be used with
> 3.14.1?
>
> This is the XML configuration file that is generated.
>
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.13.0.xsd";>
> <logging>WARN</logging>
> <onError>FAIL</onError>
> <jdbc>
> <driver>org.postgresql.Driver</driver>
> <url>jdbc:postgresql://localhost:****/******************</url>
> <user>***********</user>
> <password>***********</password>
> <properties>
> <property>
> <key>ssl</key>
> <value>true</value>
> </property>
> <property>
> <key>sslmode</key>
> <value>require</value>
> </property>
> </properties>
> </jdbc>
> <generator>
> <name>org.jooq.codegen.DefaultGenerator</name>
> <strategy>
> <name>org.jooq.codegen.DefaultGeneratorStrategy</name>
> </strategy>
> <database>
> <name>org.jooq.meta.postgres.PostgresDatabase</name>
> <regexMatchesPartialQualification>true</regexMatchesPartialQualification>
> <sqlMatchesPartialQualification>true</sqlMatchesPartialQualification>
> <includes>.*</includes>
> <excludes></excludes>
> <includeExcludeColumns>false</includeExcludeColumns>
> <includeTables>true</includeTables>
> <includeEmbeddables>true</includeEmbeddables>
> <includeRoutines>true</includeRoutines>
> <includeTriggerRoutines>false</includeTriggerRoutines>
> <includePackages>true</includePackages>
> <includePackageRoutines>true</includePackageRoutines>
> <includePackageUDTs>true</includePackageUDTs>
> <includePackageConstants>true</includePackageConstants>
> <includeUDTs>true</includeUDTs>
> <includeSequences>true</includeSequences>
> <includeIndexes>true</includeIndexes>
> <includePrimaryKeys>true</includePrimaryKeys>
> <includeUniqueKeys>true</includeUniqueKeys>
> <includeForeignKeys>true</includeForeignKeys>
> <includeCheckConstraints>true</includeCheckConstraints>
> <includeSystemIndexes>false</includeSystemIndexes>
> <includeSystemCheckConstraints>false</includeSystemCheckConstraints>
> <includeInvisibleColumns>true</includeInvisibleColumns>
> <recordVersionFields></recordVersionFields>
> <recordTimestampFields></recordTimestampFields>
> <syntheticIdentities></syntheticIdentities>
> <syntheticPrimaryKeys></syntheticPrimaryKeys>
> <overridePrimaryKeys></overridePrimaryKeys>
> <dateAsTimestamp>false</dateAsTimestamp>
> <ignoreProcedureReturnValues>false</ignoreProcedureReturnValues>
> <unsignedTypes>true</unsignedTypes>
> <integerDisplayWidths>true</integerDisplayWidths>
> <inputCatalog></inputCatalog>
> <outputCatalogToDefault>false</outputCatalogToDefault>
> <inputSchema>public</inputSchema>
> <outputSchemaToDefault>false</outputSchemaToDefault>
> <schemaVersionProvider></schemaVersionProvider>
> <catalogVersionProvider></catalogVersionProvider>
> <orderProvider></orderProvider>
>
> <forceIntegerTypesOnZeroScaleDecimals>true</forceIntegerTypesOnZeroScaleDecimals>
> <logSlowQueriesAfterSeconds>5</logSlowQueriesAfterSeconds>
> <logSlowResultsAfterSeconds>5</logSlowResultsAfterSeconds>
> <forcedTypes>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ProjectId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidProjectIdConverter
> </converter>
> <includeExpression>.*\..*project_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.UserId</userType>
> <converter>x.y.z.studio.database_entities.converters.UuidUserIdConverter
> </converter>
> <includeExpression>.*\..*user_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ArrangementId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidArrangementIdConverter
> </converter>
> <includeExpression>.*\..*arrangement_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ArrangementVersionId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidArrangementVersionIdConverter
> </converter>
> <includeExpression>.*\..*arrangement_version_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.audio.rhythm.BarIndex</userType>
> <converter>
> x.y.z.studio.database_entities.converters.IntBarIndexConverter
> </converter>
> <includeExpression>.*\..*bar_index.*</includeExpression>
> <includeTypes>integer</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.RhythmicAnalysisId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidAnalyzedTrackIdConverter
> </converter>
> <includeExpression>.*\..*rhythmic_analysis_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ArrangementTrackId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidArrangementTrackIdConverter
> </converter>
> <includeExpression>.*\..*arrangement_track_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.audio.TrackId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidTrackIdConverter
> </converter>
> <includeExpression>.*\..*track_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.BeatsId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidBeatsIdConverter
> </converter>
> <includeExpression>.*\..*beats_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.BarsId</userType>
> <converter>x.y.z.studio.database_entities.converters.UuidBarsIdConverter
> </converter>
> <includeExpression>.*\..*bars_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ClipId</userType>
> <converter>x.y.z.studio.database_entities.converters.UuidClipIdConverter
> </converter>
> <includeExpression>.*\..*clip_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ClipFolderId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidClipFolderIdConverter
> </converter>
> <includeExpression>.*\..*clip_folder_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.studio.identifiers.ProcessingRequestId</userType>
> <converter>
> x.y.z.studio.database_entities.converters.UuidProcessingRequestIdConverter
> </converter>
> <includeExpression>.*\..*processing_request_id.*</includeExpression>
> <includeTypes>uuid</includeTypes>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>x.y.z.color.Color</userType>
> <converter>
> x.y.z.studio.database_entities.converters.StringColorConverter
> </converter>
> <includeExpression>.*\..*color.*</includeExpression>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> <forcedType>
> <userType>java.time.Instant</userType>
> <converter>
> x.y.z.studio.database_entities.converters.OffsetDateTimeInstantConverter
> </converter>
> <includeExpression>.*\..*creation_timestamp.*</includeExpression>
> <nullability>ALL</nullability>
> <objectType>ALL</objectType>
> </forcedType>
> </forcedTypes>
> </database>
> <generate>
> <indexes>true</indexes>
> <relations>true</relations>
> <sequenceFlags>true</sequenceFlags>
> <implicitJoinPathsToOne>true</implicitJoinPathsToOne>
> <deprecated>false</deprecated>
> <deprecationOnUnknownTypes>true</deprecationOnUnknownTypes>
> <instanceFields>true</instanceFields>
> <generatedAnnotation>false</generatedAnnotation>
> <generatedAnnotationType>DETECT_FROM_JDK</generatedAnnotationType>
> <nonnullAnnotation>false</nonnullAnnotation>
> <nonnullAnnotationType>javax.annotation.Nonnull</nonnullAnnotationType>
> <nullableAnnotation>false</nullableAnnotation>
> <nullableAnnotationType>javax.annotation.Nullable</nullableAnnotationType>
> <routines>true</routines>
> <sequences>true</sequences>
> <udts>true</udts>
> <queues>true</queues>
> <links>true</links>
> <keys>true</keys>
> <tables>true</tables>
> <embeddables>true</embeddables>
> <records>true</records>
> <recordsImplementingRecordN>true</recordsImplementingRecordN>
> <pojos>true</pojos>
> <pojosEqualsAndHashCode>false</pojosEqualsAndHashCode>
> <pojosToString>true</pojosToString>
> <immutablePojos>false</immutablePojos>
> <serializablePojos>true</serializablePojos>
> <interfaces>false</interfaces>
> <immutableInterfaces>false</immutableInterfaces>
> <serializableInterfaces>true</serializableInterfaces>
> <daos>false</daos>
> <jpaAnnotations>false</jpaAnnotations>
> <validationAnnotations>false</validationAnnotations>
> <springAnnotations>false</springAnnotations>
> <globalObjectReferences>true</globalObjectReferences>
> <globalCatalogReferences>true</globalCatalogReferences>
> <globalSchemaReferences>true</globalSchemaReferences>
> <globalTableReferences>true</globalTableReferences>
> <globalSequenceReferences>true</globalSequenceReferences>
> <globalUDTReferences>true</globalUDTReferences>
> <globalRoutineReferences>true</globalRoutineReferences>
> <globalQueueReferences>true</globalQueueReferences>
> <globalLinkReferences>true</globalLinkReferences>
> <globalKeyReferences>true</globalKeyReferences>
> <globalIndexReferences>true</globalIndexReferences>
> <javadoc>true</javadoc>
> <comments>true</comments>
> <commentsOnCatalogs>true</commentsOnCatalogs>
> <commentsOnSchemas>true</commentsOnSchemas>
> <commentsOnTables>true</commentsOnTables>
> <commentsOnColumns>true</commentsOnColumns>
> <commentsOnUDTs>true</commentsOnUDTs>
> <commentsOnAttributes>true</commentsOnAttributes>
> <commentsOnPackages>true</commentsOnPackages>
> <commentsOnRoutines>true</commentsOnRoutines>
> <commentsOnParameters>true</commentsOnParameters>
> <commentsOnSequences>true</commentsOnSequences>
> <commentsOnLinks>true</commentsOnLinks>
> <commentsOnQueues>true</commentsOnQueues>
> <commentsOnKeys>true</commentsOnKeys>
> <sources>true</sources>
> <sourcesOnViews>true</sourcesOnViews>
> <fluentSetters>true</fluentSetters>
> <javaBeansGettersAndSetters>false</javaBeansGettersAndSetters>
> <varargSetters>false</varargSetters>
> <fullyQualifiedTypes></fullyQualifiedTypes>
> <emptyCatalogs>false</emptyCatalogs>
> <emptySchemas>false</emptySchemas>
> <javaTimeTypes>true</javaTimeTypes>
> <primaryKeyTypes>false</primaryKeyTypes>
> <newline>\n</newline>
> </generate>
> <target>
> <packageName>x.y.z.studio.database_entities.jooq</packageName>
> <directory>
> /A/B/C/build/generated/source/jooq/main
> </directory>
> <encoding>UTF-8</encoding>
> <clean>true</clean>
> </target>
> </generator>
> </configuration>
>
> The namespace is xmlns="http://www.jooq.org/xsd/jooq-codegen-3.13.0.xsd";.
> Is this correct?
> This is the file that I found in tmp/generateJooq after trying to build
> with jOOQ 3.14.1 and getting that error message.
>
> Thanks,
>
> Maurizio
>
> On Friday, 6 November 2020 at 17:08:26 UTC+1 [email protected] wrote:
>
>> Thanks for your message
>>
>> On Fri, Nov 6, 2020 at 4:29 PM Maurizio <[email protected]> wrote:
>>
>>> I never was able to switch to 3.14, because I get this error message
>>> when running the code generation:
>>>
>>> *cvc-complex-type.2.4.a: Invalid content was found starting with element
>>> '{"http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":primaryKeyTypes}'. One
>>> of '{"http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":generatedAnnotationDate,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":constructorPropertiesAnnotation,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":constructorPropertiesAnnotationOnPojos,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":constructorPropertiesAnnotationOnRecords,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":pojosAsJavaRecordClasses,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":pojosAsScalaCaseClasses,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":pojosAsKotlinDataClasses,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":jpaVersion,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":globalDomainReferences,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":commentsOnEmbeddables,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":generatedSerialVersionUID,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":maxMembersPerInitialiser,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":newline,
>>> "http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd
>>> <http://www.jooq.org/xsd/jooq-codegen-3.14.0.xsd>":indentation}' is
>>> expected.*
>>>
>>> I could not google anything about it.
>>>
>>
>> This is an XSD validation error. Your configuration XML seems to be
>> invalid. Now, I'd have to see it in order to be able to help you to see
>> what's wrong...
>>
>>
>>> I had in mind to talk about this issue later. I, too, wanted to use 3.14
>>> in order to benefit from the dedicated Kotlin generator.
>>>
>>> Could you help me with that?
>>>
>>
>> If you help me help you :)
>>
>> 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].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/82181f3d-b692-440b-9fcb-9b950692bdb1n%40googlegroups.com
> <https://groups.google.com/d/msgid/jooq-user/82181f3d-b692-440b-9fcb-9b950692bdb1n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
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].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/CAB4ELO72cNpCMgP%2BZu3f3aCGeifmMdNKTpToiTTE8vd6LJEDNQ%40mail.gmail.com.

Reply via email to