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.
