Hello,
I am trying to use the Jooq official codegen gradle plugin instead of a third party plugin, but I am having issues.
I am getting below error
```
* What went wrong:
A problem occurred evaluating script.
> Could not resolve all artifacts for configuration 'classpath'.
> Could not find org.jooq:jooq-codegen-gradle:3.18.17.
Searched in the following locations:
-
https://plugins.gradle.org/m2/org/jooq/jooq-codegen-gradle/3.18.17/jooq-codegen-gradle-3.18.17.pom Required by:
unspecified:unspecified:unspecified
* Try:
> If the artifact you are trying to retrieve can be found in the repository but without metadata in 'Maven POM' format, you need to adjust the 'metadataSources { ... }' of the repository declaration.
```
Here is my
jooq.gradle ```
import org.jooq.meta.jaxb.Logging
buildscript {
repositories {
gradlePluginPortal()
}
dependencies {
classpath "org.jooq:jooq-codegen-gradle:3.19.10"
}
ext {
// use jOOQ version defined in Spring Boot
jooqVersion = dependencyManagement.importedProperties['jooq.version']
}
configurations.classpath {
// Enforce the jOOQ configuration XML schema version
resolutionStrategy.eachDependency {
if (requested.group == 'org.jooq' && requested.name.startsWith('jooq')) {
useVersion jooqVersion
}
}
}
}
apply plugin: 'org.jooq.jooq-codegen'
// JOOQ dependencies
dependencies {
implementation 'org.springframework.boot:spring-boot-starter-jooq'
jooqGenerator 'com.mysql:mysql-connector-j'
jooqGenerator 'org.slf4j:slf4j-simple'
jooqGenerator 'com.fasterxml.jackson.core:jackson-databind'
jooqGenerator "org.testcontainers:mysql"
jooqGenerator 'org.testcontainers:jdbc'
}
jooq {
version = jooqVersion
configuration {
logging = Logging.WARN
jdbc {
driver = 'com.mysql.cj.jdbc.Driver'
}
generator {
name = 'org.jooq.codegen.DefaultGenerator'
database {
name = 'org.jooq.meta.mysql.MySQLDatabase'
inputSchema = 'lmsdb'
schemata {
schema {
inputSchema = 'lmsdb'
}
}
}
generate {
records = true
immutablePojos = true
fluentSetters = true
javaTimeTypes = false
}
target {
packageName = "com.chegg.${mainPackageName}.db"
}
strategy {
name = 'org.jooq.codegen.DefaultGeneratorStrategy'
}
}
}
}
```