Liquibase and Jooq against MySql testcontainer In Gradle SpringBoot Project
383 views
Skip to first unread message
Debapriya Patra
Jun 11, 2024, 1:28:21 AM6/11/24
to jOOQ User Group
Hi,
Does anyone integrated Liquibase in a mysql testcontainer to apply DB migrations and use Jooq to connect to the MySql test container DB to generate java files?
I wanted to do this inside a gradle Spring Boot application. Can someone help me on this ?
Any example or reference might be helpful ?
I am trying to go in the following sequence.
- Spinup MySql test container
- Apply DB migrations using Liquibase against MySql test container.
- Generate Java files from the DB against MySql testcontainer DB.
Also I wanted to have the code separated in three .gradle files.
Here is what I have started with
mysqltc.gradle
------------------------
```
liquibase.gradle
```
jooq.gradle
-------------------
```/**
I am stuck with an error.
Does anyone integrated Liquibase in a mysql testcontainer to apply DB migrations and use Jooq to connect to the MySql test container DB to generate java files?
I wanted to do this inside a gradle Spring Boot application. Can someone help me on this ?
Any example or reference might be helpful ?
I am trying to go in the following sequence.
- Spinup MySql test container
- Apply DB migrations using Liquibase against MySql test container.
- Generate Java files from the DB against MySql testcontainer DB.
Also I wanted to have the code separated in three .gradle files.
Here is what I have started with
mysqltc.gradle
------------------------
```
// mysql-tc.gradle
import org.testcontainers.containers.MySQLContainer
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath "org.testcontainers:testcontainers:${testcontainersVersion}"
classpath "org.testcontainers:mysql:${testcontainersVersion}"
classpath "com.mysql:mysql-connector-j:8.4.0"
}
}
tasks.register('startMySQLContainer') {
println("----Stating MySql DB TC----")
doLast {
def mysqlContainer = new MySQLContainer("mysql:latest")
.withDatabaseName("lmsdb")
.withUsername("test")
.withPassword("test")
mysqlContainer.start()
project.ext.dbUrl = mysqlContainer.getJdbcUrl()
project.ext.dbUsername = mysqlContainer.getUsername()
project.ext.dbPassword = mysqlContainer.getPassword()
project.ext.dbDriver = mysqlContainer.getDriverClassName()
println "MySQL container started with URL: ${project.ext.dbUrl}"
}
}
tasks.register('stopMySqlContainer') {
doLast {
if (mysqlContainer) {
mysqlContainer.stop()
}
}
}
```import org.testcontainers.containers.MySQLContainer
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath "org.testcontainers:testcontainers:${testcontainersVersion}"
classpath "org.testcontainers:mysql:${testcontainersVersion}"
classpath "com.mysql:mysql-connector-j:8.4.0"
}
}
tasks.register('startMySQLContainer') {
println("----Stating MySql DB TC----")
doLast {
def mysqlContainer = new MySQLContainer("mysql:latest")
.withDatabaseName("lmsdb")
.withUsername("test")
.withPassword("test")
mysqlContainer.start()
project.ext.dbUrl = mysqlContainer.getJdbcUrl()
project.ext.dbUsername = mysqlContainer.getUsername()
project.ext.dbPassword = mysqlContainer.getPassword()
project.ext.dbDriver = mysqlContainer.getDriverClassName()
println "MySQL container started with URL: ${project.ext.dbUrl}"
}
}
tasks.register('stopMySqlContainer') {
doLast {
if (mysqlContainer) {
mysqlContainer.stop()
}
}
}
liquibase.gradle
```
println("----Configuring Liquibase----")
dependencies {
implementation 'org.liquibase:liquibase-core:4.24.0'
}
liquibase {
activities {
main {
changeLogFile 'src/main/resources/db/changelog/changelog-master.sql'
url project.ext.has('d') ? project.ext.jdbcUrl : 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
username project.ext.has('username') ? project.ext.username : 'test'
password project.ext.has('password') ? project.ext.password : 'test'
}
}
runList = 'main'
}
tasks.named('update') {
dependsOn ':startMySQLContainer'
}
```dependencies {
implementation 'org.liquibase:liquibase-core:4.24.0'
}
liquibase {
activities {
main {
changeLogFile 'src/main/resources/db/changelog/changelog-master.sql'
url project.ext.has('d') ? project.ext.jdbcUrl : 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
username project.ext.has('username') ? project.ext.username : 'test'
password project.ext.has('password') ? project.ext.password : 'test'
}
}
runList = 'main'
}
tasks.named('update') {
dependsOn ':startMySQLContainer'
}
jooq.gradle
-------------------
```/**
* This gradle file is used to generate JOOQ DAO, POJOs and fluent API for writing SQL queries using
* generated classes. The default configuration below should work in most cases, but it can be
* modified as needed based on the plugin documentation:
*
* https://github.com/etiennestuder/gradle-jooq-plugin
*/
import nu.studer.gradle.jooq.JooqGenerate
buildscript {
repositories {
gradlePluginPortal()
}
dependencies {
classpath "nu.studer:gradle-jooq-plugin:${jooqPluginVersion}"
}
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: nu.studer.gradle.jooq.JooqPlugin
println("Configuring JOOQ dependencies and code generation plugin...")
// 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 'software.aws.rds:aws-mysql-jdbc:1.+'
implementation 'org.testcontainers:jdbc'
}
// Configure JOOQ
jooq {
version = jooqVersion
configurations {
main {
generationTool {
logging = org.jooq.meta.jaxb.Logging.WARN
jdbc {
driver = 'org.testcontainers.jdbc.ContainerDatabaseDriver'
}
generator {
name = 'org.jooq.codegen.DefaultGenerator'
database {
name = 'org.jooq.meta.mysql.MySQLDatabase'
inputSchema = 'lmsdb'
}
generate {
records = true
immutablePojos = true
fluentSetters = true
javaTimeTypes = false
}
target {
packageName = "com.chegg.${mainPackageName}.db"
}
strategy.name = 'org.jooq.codegen.DefaultGeneratorStrategy'
}
}
}
}
}
// Add database-specific JDBC driver dependencies for JOOQ code generation and plugin configuration
String databaseType = findProperty("databaseType") as String
if (databaseType == "aurora-mysql") {
ext.jooqSecrets = project.getSecretsById(project.getPropertyValue("app.db.app-secret-id"))
jooq.configurations.main {
generationTool {
jdbc {
//url = "jdbc:mysql://" + (project.getPropertyValue("spring.datasource.url") as String).split("://", 2)[1]
//user = jooqSecrets.get("username")
//password = jooqSecrets.get("password")
url = project.ext.has('jdbcUrl') ? project.ext.jdbcUrl : 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
}
}
}
} else if (databaseType == "mysql") {
jooq.configurations.main {
generationTool {
jdbc {
url = project.getPropertyValue("spring.datasource.url")
user = project.getPropertyValue("spring.datasource.username")
password = project.getPropertyValue("spring.datasource.password")
}
}
}
}
// Configure the JVM used for the JOOQ code generation process
tasks.withType(JooqGenerate).configureEach {
javaExecSpec = { JavaExecSpec s ->
s.systemProperties System.properties
}
}
tasks.named('generateJooq') {
dependsOn ':startMySQLContainer', ':update'
}```
In my build.gradle I am applying from those three .gradle files.* generated classes. The default configuration below should work in most cases, but it can be
* modified as needed based on the plugin documentation:
*
* https://github.com/etiennestuder/gradle-jooq-plugin
*/
import nu.studer.gradle.jooq.JooqGenerate
buildscript {
repositories {
gradlePluginPortal()
}
dependencies {
classpath "nu.studer:gradle-jooq-plugin:${jooqPluginVersion}"
}
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: nu.studer.gradle.jooq.JooqPlugin
println("Configuring JOOQ dependencies and code generation plugin...")
// 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 'software.aws.rds:aws-mysql-jdbc:1.+'
implementation 'org.testcontainers:jdbc'
}
// Configure JOOQ
jooq {
version = jooqVersion
configurations {
main {
generationTool {
logging = org.jooq.meta.jaxb.Logging.WARN
jdbc {
driver = 'org.testcontainers.jdbc.ContainerDatabaseDriver'
}
generator {
name = 'org.jooq.codegen.DefaultGenerator'
database {
name = 'org.jooq.meta.mysql.MySQLDatabase'
inputSchema = 'lmsdb'
}
generate {
records = true
immutablePojos = true
fluentSetters = true
javaTimeTypes = false
}
target {
packageName = "com.chegg.${mainPackageName}.db"
}
strategy.name = 'org.jooq.codegen.DefaultGeneratorStrategy'
}
}
}
}
}
// Add database-specific JDBC driver dependencies for JOOQ code generation and plugin configuration
String databaseType = findProperty("databaseType") as String
if (databaseType == "aurora-mysql") {
ext.jooqSecrets = project.getSecretsById(project.getPropertyValue("app.db.app-secret-id"))
jooq.configurations.main {
generationTool {
jdbc {
//url = "jdbc:mysql://" + (project.getPropertyValue("spring.datasource.url") as String).split("://", 2)[1]
//user = jooqSecrets.get("username")
//password = jooqSecrets.get("password")
url = project.ext.has('jdbcUrl') ? project.ext.jdbcUrl : 'jdbc:tc:mysql:8.0.36:///lmsdb?TC_TMPFS=/testtmpfs:rw'
}
}
}
} else if (databaseType == "mysql") {
jooq.configurations.main {
generationTool {
jdbc {
url = project.getPropertyValue("spring.datasource.url")
user = project.getPropertyValue("spring.datasource.username")
password = project.getPropertyValue("spring.datasource.password")
}
}
}
}
// Configure the JVM used for the JOOQ code generation process
tasks.withType(JooqGenerate).configureEach {
javaExecSpec = { JavaExecSpec s ->
s.systemProperties System.properties
}
}
tasks.named('generateJooq') {
dependsOn ':startMySQLContainer', ':update'
}```
I am stuck with an error.
Lukas Eder
Jun 11, 2024, 3:04:45 AM6/11/24
to jooq...@googlegroups.com
Thanks for your message. We'll have gradle examples eventually in our MCVE template:
They'll be using testcontainers too.
Unfortunately, until then, I can't really comment about the "best way" to do it. (It will be very hard with gradle anyway, because there are so many opinions). We'll be recommending the official plugin, not a third party one...
--
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/61012e09-94c7-4287-b1fd-7254fee3178en%40googlegroups.com.
Debapriya Patra
Jun 12, 2024, 3:14:03 AM6/12/24
to jOOQ User Group
Hi Lukas,
Thank you for the reply.
After doing some modifications to my .gradle files, now I am able to start the MySql testcontainer, apply the DB migrations using Liquibase but when its executing the generateJooq task, its breaking with the below error.
Here is the fill log when I run ./gradlew clean build command in my local. Any idea whats going wrong here.
> Configure project :
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/application.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/chegg-repository.gradle
Using AWS CLI to get CodeArtifact repo URL
Executing: aws codeartifact get-repository-endpoint --profile chegg-app-edu1-nonprod --domain chegg --domain-owner 084139392869 --region us-west-2 --repository java-chegg --format maven --query repositoryEndpoint --output text
Result: "https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/"
Using repo url https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/
Using AWS CLI to get CodeArtifact token
Executing: aws codeartifact get-authorization-token --profile chegg-app-edu1-nonprod --domain chegg --domain-owner 084139392869 --region us-west-2 --query authorizationToken --output text
Result: "( 1438 hidden characters )"
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/common.gradle
Standard configured repositories:
- CodeArtifact (url: https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/, username: aws)
- confluent (url: https://packages.confluent.io/maven/)
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/build-props.gradle
buildCheggEnv = dev
Loading properties from src/main/resources/application.properties...
Loading properties from src/main/resources/application-dev.properties...
Found spring.application.name in application properties
Loading secrets from dev/lms-registration-service...
Loading parameters from /dev/lms-registration-service/...
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/tests.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/jacoco.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/newrelic.gradle
Configuring JOOQ dependencies and code generation plugin...
Configuring Netflix DGS code generation plugin...
----Stating MySql DB TC----
> Task :startMySQLContainer
----MySql Test container started successfully with URL : jdbc:mysql://localhost:50255/lmsdb
> Task :update
liquibase-plugin: Running the 'main' activity...
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 23:46:32 (version 4.24.0 #14062 built at 2023-09-28 12:18+0000)
[2024-06-11 23:46:32] INFO [liquibase.ui] ####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 23:46:32 (version 4.24.0 #14062 built at 2023-09-28 12:18+0000)
Liquibase Version: 4.24.0
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase Version: 4.24.0
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
[2024-06-11 23:46:32] INFO [liquibase.ui] WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
[2024-06-11 23:46:32] INFO [liquibase.integration] Starting command execution.
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading resource: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql
[2024-06-11 23:46:32] INFO [liquibase.changelog] Creating database history table with name: lmsdb.DATABASECHANGELOG
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading from lmsdb.DATABASECHANGELOG
[2024-06-11 23:46:32] WARNING [liquibase.executor] Integer display width is deprecated and will be removed in a future release.
[2024-06-11 23:46:32] INFO [liquibase.lockservice] Successfully acquired change log lock
[2024-06-11 23:46:32] INFO [liquibase.command] Using deploymentId: 8174792776
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading from lmsdb.DATABASECHANGELOG
Running Changeset: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll
[2024-06-11 23:46:32] INFO [liquibase.ui] Running Changeset: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll
[2024-06-11 23:46:32] INFO [liquibase.changelog] Custom SQL executed
[2024-06-11 23:46:32] INFO [liquibase.changelog] ChangeSet liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll ran successfully in 31ms
UPDATE SUMMARY
Run: 1
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 1
[2024-06-11 23:46:32] INFO [liquibase.util] UPDATE SUMMARY
[2024-06-11 23:46:32] INFO [liquibase.util] Run: 1
[2024-06-11 23:46:32] INFO [liquibase.util] Previously run: 0
[2024-06-11 23:46:32] INFO [liquibase.util] Filtered out: 0
[2024-06-11 23:46:32] INFO [liquibase.util] -------------------------------
[2024-06-11 23:46:32] INFO [liquibase.util] Total change sets: 1
[2024-06-11 23:46:32] INFO [liquibase.util] Update summary generated
[2024-06-11 23:46:32] INFO [liquibase.command] Update command completed successfully.
Liquibase: Update has been successful. Rows affected: 1
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase: Update has been successful. Rows affected: 1
[2024-06-11 23:46:32] INFO [liquibase.lockservice] Successfully released change log lock
[2024-06-11 23:46:32] INFO [liquibase.command] Command execution complete
Liquibase command 'update' was executed successfully.
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase command 'update' was executed successfully.
> Task :generateJooq FAILED
Running jOOQ code generation with URL: jdbc:mysql://localhost:50255/lmsdb
Username: test
Password: test
Driver: com.mysql.cj.jdbc.Driver
[main] WARN org.jooq.meta.AbstractDatabase - SQL exception : Exception while executing meta query: Cannot execute query. No JDBC Connection configured
If you think this is a bug in jOOQ, please report it here: https://jooq.org/bug
Note you can mute some exceptions using the configuration/onError flag
```sql
select information_schema.SCHEMATA.SCHEMA_NAME
from information_schema.SCHEMATA```
[main] ERROR org.jooq.meta.AbstractDatabase - Code generation error : An error was encountered during code generation. This can have various reasons:
- There's a bug in jOOQ. Please report it here: https://jooq.org/bug
- Your database user doesn't have the necessary privileges to access a metadata table
- The database connection suffered a failure
There are other reasons. If the error can be ignored, you can either:
- Turn off the relevant feature in the code generator to avoid running into the error
- Avoid fetching the relevant meta data by excluding the object from code generation
- Use the <onError/> code generation configuration to specify the severity of such errors (for all errors!)
See https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-onerror/
[main] ERROR org.jooq.codegen.GenerationTool - Error in file: /Users/dpatra/Downloads/HSLab/BEServices/PartnerServices/lms-registration-service/build/tmp/generateJooq/config.xml. Error : Error generating code for catalog
org.jooq.codegen.GeneratorException: Error generating code for catalog
at org.jooq.codegen.JavaGenerator.generate0(JavaGenerator.java:542)
at org.jooq.codegen.AbstractGenerator.generate(AbstractGenerator.java:191)
at org.jooq.codegen.JavaGenerator.generate(JavaGenerator.java:225)
at org.jooq.codegen.GenerationTool.run0(GenerationTool.java:944)
at org.jooq.codegen.GenerationTool.run(GenerationTool.java:244)
at org.jooq.codegen.GenerationTool.generate(GenerationTool.java:239)
at org.jooq.codegen.GenerationTool.main(GenerationTool.java:211)
Caused by: java.lang.RuntimeException: org.jooq.exception.DetachedException: Cannot execute query. No JDBC Connection configured
at org.jooq.meta.AbstractDatabase.onError(AbstractDatabase.java:3886)
at org.jooq.meta.AbstractDatabase.getSchemata(AbstractDatabase.java:759)
at org.jooq.meta.AbstractDatabase.getSchemata(AbstractDatabase.java:779)
at org.jooq.meta.CatalogDefinition.getSchemata(CatalogDefinition.java:65)
at org.jooq.codegen.JavaGenerator.generateCatalogIfEmpty(JavaGenerator.java:574)
at org.jooq.codegen.JavaGenerator.generate0(JavaGenerator.java:536)
... 6 more
Caused by: org.jooq.exception.DetachedException: Cannot execute query. No JDBC Connection configured
at org.jooq_3.18.15.MYSQL.debug(Unknown Source)
at org.jooq.impl.AbstractQuery.connection(AbstractQuery.java:393)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:306)
at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:301)
at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:322)
at org.jooq.impl.SelectImpl.fetchLazyNonAutoClosing(SelectImpl.java:2862)
at org.jooq.impl.ResultQueryTrait.collect(ResultQueryTrait.java:360)
at org.jooq.meta.mysql.MySQLDatabase.getSchemata0(MySQLDatabase.java:426)
at org.jooq.meta.AbstractDatabase.lambda$getSchemata$2(AbstractDatabase.java:759)
at org.jooq.meta.AbstractDatabase.onError(AbstractDatabase.java:3860)
... 11 more
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':generateJooq'.
> Process 'command '/Library/Java/JavaVirtualMachines/amazon-corretto-17.jdk/Contents/Home/bin/java'' finished with non-zero exit value 255
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.
> Get more help at https://help.gradle.org.
Deprecated Gradle features were used in this build, making it incompatible with Gradle 9.0.
You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.
For more on this, please refer to https://docs.gradle.org/8.7/userguide/command_line_interface.html#sec:command_line_warnings in the Gradle documentation.
BUILD FAILED in 18s
6 actionable tasks: 6 executed
Here is my three files.
}
}
tasks.register('stopMySqlContainer') {
doLast {
if (mysqlContainer) {
mysqlContainer.stop()
}
}
}
Thank you for the reply.
After doing some modifications to my .gradle files, now I am able to start the MySql testcontainer, apply the DB migrations using Liquibase but when its executing the generateJooq task, its breaking with the below error.
Here is the fill log when I run ./gradlew clean build command in my local. Any idea whats going wrong here.
> Configure project :
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/application.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/chegg-repository.gradle
Using AWS CLI to get CodeArtifact repo URL
Executing: aws codeartifact get-repository-endpoint --profile chegg-app-edu1-nonprod --domain chegg --domain-owner 084139392869 --region us-west-2 --repository java-chegg --format maven --query repositoryEndpoint --output text
Result: "https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/"
Using repo url https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/
Using AWS CLI to get CodeArtifact token
Executing: aws codeartifact get-authorization-token --profile chegg-app-edu1-nonprod --domain chegg --domain-owner 084139392869 --region us-west-2 --query authorizationToken --output text
Result: "( 1438 hidden characters )"
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/common.gradle
Standard configured repositories:
- CodeArtifact (url: https://chegg-084139392869.d.codeartifact.us-west-2.amazonaws.com/maven/java-chegg/, username: aws)
- confluent (url: https://packages.confluent.io/maven/)
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/build-props.gradle
buildCheggEnv = dev
Loading properties from src/main/resources/application.properties...
Loading properties from src/main/resources/application-dev.properties...
Found spring.application.name in application properties
Loading secrets from dev/lms-registration-service...
Loading parameters from /dev/lms-registration-service/...
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/tests.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/jacoco.gradle
Executing build script: https://chegg-gradle.test.devx.chegg.services/chegg-gradle/scripts/boots-build.5/internal/newrelic.gradle
Configuring JOOQ dependencies and code generation plugin...
----Stating MySql DB TC----
> Task :startMySQLContainer
----MySql Test container started successfully with URL : jdbc:mysql://localhost:50255/lmsdb
> Task :update
liquibase-plugin: Running the 'main' activity...
####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 23:46:32 (version 4.24.0 #14062 built at 2023-09-28 12:18+0000)
[2024-06-11 23:46:32] INFO [liquibase.ui] ####################################################
## _ _ _ _ ##
## | | (_) (_) | ##
## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##
## | | | |/ _` | | | | | '_ \ / _` / __|/ _ \ ##
## | |___| | (_| | |_| | | |_) | (_| \__ \ __/ ##
## \_____/_|\__, |\__,_|_|_.__/ \__,_|___/\___| ##
## | | ##
## |_| ##
## ##
## Get documentation at docs.liquibase.com ##
## Get certified courses at learn.liquibase.com ##
## ##
####################################################
Starting Liquibase at 23:46:32 (version 4.24.0 #14062 built at 2023-09-28 12:18+0000)
Liquibase Version: 4.24.0
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase Version: 4.24.0
WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
[2024-06-11 23:46:32] INFO [liquibase.ui] WARNING: License service not loaded, cannot determine Liquibase Pro license status. Please consider re-installing Liquibase to include all dependencies. Continuing operation without Pro license.
[2024-06-11 23:46:32] INFO [liquibase.integration] Starting command execution.
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading resource: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql
[2024-06-11 23:46:32] INFO [liquibase.changelog] Creating database history table with name: lmsdb.DATABASECHANGELOG
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading from lmsdb.DATABASECHANGELOG
[2024-06-11 23:46:32] WARNING [liquibase.executor] Integer display width is deprecated and will be removed in a future release.
[2024-06-11 23:46:32] INFO [liquibase.lockservice] Successfully acquired change log lock
[2024-06-11 23:46:32] INFO [liquibase.command] Using deploymentId: 8174792776
[2024-06-11 23:46:32] INFO [liquibase.changelog] Reading from lmsdb.DATABASECHANGELOG
Running Changeset: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll
[2024-06-11 23:46:32] INFO [liquibase.ui] Running Changeset: liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll
[2024-06-11 23:46:32] INFO [liquibase.changelog] Custom SQL executed
[2024-06-11 23:46:32] INFO [liquibase.changelog] ChangeSet liquibase/db1/sqlfiles/V0__create_lms_integration_tables.sql::raw::includeAll ran successfully in 31ms
UPDATE SUMMARY
Run: 1
Previously run: 0
Filtered out: 0
-------------------------------
Total change sets: 1
[2024-06-11 23:46:32] INFO [liquibase.util] UPDATE SUMMARY
[2024-06-11 23:46:32] INFO [liquibase.util] Run: 1
[2024-06-11 23:46:32] INFO [liquibase.util] Previously run: 0
[2024-06-11 23:46:32] INFO [liquibase.util] Filtered out: 0
[2024-06-11 23:46:32] INFO [liquibase.util] -------------------------------
[2024-06-11 23:46:32] INFO [liquibase.util] Total change sets: 1
[2024-06-11 23:46:32] INFO [liquibase.util] Update summary generated
[2024-06-11 23:46:32] INFO [liquibase.command] Update command completed successfully.
Liquibase: Update has been successful. Rows affected: 1
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase: Update has been successful. Rows affected: 1
[2024-06-11 23:46:32] INFO [liquibase.lockservice] Successfully released change log lock
[2024-06-11 23:46:32] INFO [liquibase.command] Command execution complete
Liquibase command 'update' was executed successfully.
[2024-06-11 23:46:32] INFO [liquibase.ui] Liquibase command 'update' was executed successfully.
> Task :generateJooq FAILED
Running jOOQ code generation with URL: jdbc:mysql://localhost:50255/lmsdb
Username: test
Password: test
Driver: com.mysql.cj.jdbc.Driver
[main] WARN org.jooq.meta.AbstractDatabase - SQL exception : Exception while executing meta query: Cannot execute query. No JDBC Connection configured
If you think this is a bug in jOOQ, please report it here: https://jooq.org/bug
Note you can mute some exceptions using the configuration/onError flag
```sql
select information_schema.SCHEMATA.SCHEMA_NAME
from information_schema.SCHEMATA```
[main] ERROR org.jooq.meta.AbstractDatabase - Code generation error : An error was encountered during code generation. This can have various reasons:
- There's a bug in jOOQ. Please report it here: https://jooq.org/bug
- Your database user doesn't have the necessary privileges to access a metadata table
- The database connection suffered a failure
There are other reasons. If the error can be ignored, you can either:
- Turn off the relevant feature in the code generator to avoid running into the error
- Avoid fetching the relevant meta data by excluding the object from code generation
- Use the <onError/> code generation configuration to specify the severity of such errors (for all errors!)
See https://www.jooq.org/doc/latest/manual/code-generation/codegen-advanced/codegen-config-onerror/
[main] ERROR org.jooq.codegen.GenerationTool - Error in file: /Users/dpatra/Downloads/HSLab/BEServices/PartnerServices/lms-registration-service/build/tmp/generateJooq/config.xml. Error : Error generating code for catalog
org.jooq.codegen.GeneratorException: Error generating code for catalog
at org.jooq.codegen.JavaGenerator.generate0(JavaGenerator.java:542)
at org.jooq.codegen.AbstractGenerator.generate(AbstractGenerator.java:191)
at org.jooq.codegen.JavaGenerator.generate(JavaGenerator.java:225)
at org.jooq.codegen.GenerationTool.run0(GenerationTool.java:944)
at org.jooq.codegen.GenerationTool.run(GenerationTool.java:244)
at org.jooq.codegen.GenerationTool.generate(GenerationTool.java:239)
at org.jooq.codegen.GenerationTool.main(GenerationTool.java:211)
Caused by: java.lang.RuntimeException: org.jooq.exception.DetachedException: Cannot execute query. No JDBC Connection configured
at org.jooq.meta.AbstractDatabase.onError(AbstractDatabase.java:3886)
at org.jooq.meta.AbstractDatabase.getSchemata(AbstractDatabase.java:759)
at org.jooq.meta.AbstractDatabase.getSchemata(AbstractDatabase.java:779)
at org.jooq.meta.CatalogDefinition.getSchemata(CatalogDefinition.java:65)
at org.jooq.codegen.JavaGenerator.generateCatalogIfEmpty(JavaGenerator.java:574)
at org.jooq.codegen.JavaGenerator.generate0(JavaGenerator.java:536)
... 6 more
Caused by: org.jooq.exception.DetachedException: Cannot execute query. No JDBC Connection configured
at org.jooq_3.18.15.MYSQL.debug(Unknown Source)
at org.jooq.impl.AbstractQuery.connection(AbstractQuery.java:393)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:306)
at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:301)
at org.jooq.impl.AbstractResultQuery.fetchLazyNonAutoClosing(AbstractResultQuery.java:322)
at org.jooq.impl.SelectImpl.fetchLazyNonAutoClosing(SelectImpl.java:2862)
at org.jooq.impl.ResultQueryTrait.collect(ResultQueryTrait.java:360)
at org.jooq.meta.mysql.MySQLDatabase.getSchemata0(MySQLDatabase.java:426)
at org.jooq.meta.AbstractDatabase.lambda$getSchemata$2(AbstractDatabase.java:759)
at org.jooq.meta.AbstractDatabase.onError(AbstractDatabase.java:3860)
... 11 more
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':generateJooq'.
> Process 'command '/Library/Java/JavaVirtualMachines/amazon-corretto-17.jdk/Contents/Home/bin/java'' finished with non-zero exit value 255
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.
> Get more help at https://help.gradle.org.
Deprecated Gradle features were used in this build, making it incompatible with Gradle 9.0.
You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.
For more on this, please refer to https://docs.gradle.org/8.7/userguide/command_line_interface.html#sec:command_line_warnings in the Gradle documentation.
BUILD FAILED in 18s
6 actionable tasks: 6 executed
Here is my three files.
// mysql-tc.gradle
import org.testcontainers.containers.MySQLContainer
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath "org.testcontainers:testcontainers:${testcontainersVersion}"
classpath "org.testcontainers:mysql:${testcontainersVersion}"
classpath "com.mysql:mysql-connector-j:8.4.0"
}
}
tasks.register('startMySQLContainer') {
println("----Stating MySql DB TC----")
doLast {
def mysqlContainer = new MySQLContainer("mysql:latest")
.withDatabaseName("lmsdb")
import org.testcontainers.containers.MySQLContainer
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath "org.testcontainers:testcontainers:${testcontainersVersion}"
classpath "org.testcontainers:mysql:${testcontainersVersion}"
classpath "com.mysql:mysql-connector-j:8.4.0"
}
}
tasks.register('startMySQLContainer') {
println("----Stating MySql DB TC----")
doLast {
def mysqlContainer = new MySQLContainer("mysql:latest")
.withDatabaseName("lmsdb")
mysqlContainer.start()
project.ext.dbUrl = mysqlContainer.getJdbcUrl()
project.ext.dbUsername = mysqlContainer.getUsername()
project.ext.dbPassword = mysqlContainer.getPassword()
project.ext.dbDriver = mysqlContainer.getDriverClassName()
project.ext.dbUrl = mysqlContainer.getJdbcUrl()
project.ext.dbUsername = mysqlContainer.getUsername()
project.ext.dbPassword = mysqlContainer.getPassword()
project.ext.dbDriver = mysqlContainer.getDriverClassName()
println("----MySql Test container started successfully with URL : ${project.ext.dbUrl}")
}
}
tasks.register('stopMySqlContainer') {
doLast {
if (mysqlContainer) {
mysqlContainer.stop()
}
}
}
// liquibase.gradle
configurations {
liquibaseRuntime.extendsFrom runtimeClasspath
}
dependencies {
liquibaseRuntime sourceSets.main.output
implementation 'org.liquibase:liquibase-core:4.24.0'
implementation 'info.picocli:picocli:4.7.6'
}
tasks.named('startMySQLContainer').configure {
doLast {
liquibase {
activities {
main {
changelogFile 'liquibase/db1/tc_changelog.yml'
url project.ext.has('dbUrl') ? project.ext.dbUrl : ''
username project.ext.has('dbUsername') ? project.ext.dbUsername : ''
password project.ext.has('dbPassword') ? project.ext.dbPassword : ''
liquibaseRuntime.extendsFrom runtimeClasspath
}
dependencies {
liquibaseRuntime sourceSets.main.output
implementation 'org.liquibase:liquibase-core:4.24.0'
implementation 'info.picocli:picocli:4.7.6'
}
tasks.named('startMySQLContainer').configure {
doLast {
liquibase {
activities {
main {
changelogFile 'liquibase/db1/tc_changelog.yml'
url project.ext.has('dbUrl') ? project.ext.dbUrl : ''
username project.ext.has('dbUsername') ? project.ext.dbUsername : ''
password project.ext.has('dbPassword') ? project.ext.dbPassword : ''
}
}
runList = 'main'
}
}
}
tasks.named('update') {
dependsOn ':startMySQLContainer'
}
}
runList = 'main'
}
}
}
tasks.named('update') {
dependsOn ':startMySQLContainer'
}
// jooq.gradle
jooq.configurations.main {
generationTool {
jdbc {
url = project.ext.has('dbUrl') ? project.ext.dbUrl : ''
user = project.ext.has('dbUsername') ? project.ext.dbUsername : ''
password = project.ext.has('dbPassword') ? project.ext.dbPassword : ''
driver = project.ext.has('dbDriver') ? project.ext.dbDriver : ''
generationTool {
jdbc {
url = project.ext.has('dbUrl') ? project.ext.dbUrl : ''
user = project.ext.has('dbUsername') ? project.ext.dbUsername : ''
password = project.ext.has('dbPassword') ? project.ext.dbPassword : ''
driver = project.ext.has('dbDriver') ? project.ext.dbDriver : ''
}
}
}
// Configure the JVM used for the JOOQ code generation process
tasks.withType(JooqGenerate).configureEach {
javaExecSpec = { JavaExecSpec s ->
s.systemProperties System.properties
}
}
tasks.named('generateJooq') {
dependsOn ':startMySQLContainer', ':update'
}
}
// Configure the JVM used for the JOOQ code generation process
tasks.withType(JooqGenerate).configureEach {
javaExecSpec = { JavaExecSpec s ->
s.systemProperties System.properties
}
}
tasks.named('generateJooq') {
dependsOn ':startMySQLContainer', ':update'
doFirst {
println "Running jOOQ code generation with URL: ${project.ext.dbUrl}"
println "Username: ${project.ext.dbUsername}"
println "Password: ${project.ext.dbPassword}"
println "Driver: ${project.ext.dbDriver}"
}
}
println "Running jOOQ code generation with URL: ${project.ext.dbUrl}"
println "Username: ${project.ext.dbUsername}"
println "Password: ${project.ext.dbPassword}"
println "Driver: ${project.ext.dbDriver}"
}
}
Debapriya Patra
Jun 12, 2024, 3:14:38 AM6/12/24
to jooq...@googlegroups.com
Do you have an example of how I can use the official Jooq plugin ?
Cheers,
Debapriya Patra
650.933.6852
650.933.6852
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4-9Vf%3Dw2Jdm1BxjCWmUyWZ3Fj7FH%3DHjkmx3yHCmPDqYw%40mail.gmail.com.
Lukas Eder
Jun 12, 2024, 3:16:41 AM6/12/24
to jooq...@googlegroups.com
We're working on examples. The plugin is still experimental. Thanks for your patience:
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAM2NkrQO7uW-f6jboXvf-98M%3Du5su%2BOn4pziAx0nJPGXguC0eg%40mail.gmail.com.
Lukas Eder
Jun 12, 2024, 3:25:43 AM6/12/24
to jooq...@googlegroups.com
Thanks for your message.
At a quick glance, I'd say:
1. The error message says: no JDBC connection configured
2. You didn't correctly configure your JDBC connection
I'm afraid I don't know gradle or the third party plugin well enough to assess whether everything is done in the right order when you do this:
jooq {
version = jooqVersion
configurations {
main {
generationTool {
logging = org.jooq.meta.jaxb.Logging.WARN
jdbc {
version = jooqVersion
configurations {
main {
generationTool {
logging = org.jooq.meta.jaxb.Logging.WARN
jdbc {
// No connection configured here
driver = 'org.testcontainers.jdbc.ContainerDatabaseDriver'
}
generator {
name = 'org.jooq.codegen.DefaultGenerator'
database {
name = 'org.jooq.meta.mysql.MySQLDatabase'
inputSchema = 'lmsdb'
}
generate {
records = true
immutablePojos = true
fluentSetters = true
javaTimeTypes = false
}
target {
packageName = "com.chegg.${mainPackageName}.db"
}
strategy.name = 'org.jooq.codegen.DefaultGeneratorStrategy'
}
}
}
}
jooq.configurations.main {
generationTool {
// Maybe, this happens too late?
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/35cfebbd-cf64-43f0-af31-c9e5af5239d1n%40googlegroups.com.
Debapriya Patra
Jun 12, 2024, 3:57:48 AM6/12/24
to jooq...@googlegroups.com
Thank you for your prompt reply.
I think the plugin configuration is fine because it is working for the normal DB connection. I did a few changes related to the dependencies and using mysql testcontainer credentials to connect to DB.
Even after I add the JDBC connection details below, still I am getting the same error.
I think the plugin configuration is fine because it is working for the normal DB connection. I did a few changes related to the dependencies and using mysql testcontainer credentials to connect to DB.
Even after I add the JDBC connection details below, still I am getting the same error.
jooqGenerator 'org.testcontainers:jdbc'
}
// Configure JOOQ
jooq {
version = jooqVersion
configurations {
main {
generationTool {
logging = org.jooq.meta.jaxb.Logging.WARN
jdbc {
//driver = 'com.mysql.cj.jdbc.Driver'
url = project.ext.has('dbUrl') ? project.ext.dbUrl : ''
user = project.ext.has('dbUsername') ? project.ext.dbUsername : ''
password = project.ext.has('dbPassword') ? project.ext.dbPassword : ''
driver = project.ext.has('dbDriver') ? project.ext.dbDriver : ''
}
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4cfBGO-aWfqZ_Gm3DGqJEJ4-7uL6fU%3D8QR6quK3%2BPTeA%40mail.gmail.com.
Bernd Huber
Jun 12, 2024, 8:03:37 AM6/12/24
to jOOQ User Group
Hello,
I have integrated following successfully:
- Liquibase with Mariadb-Testcontainer to apply DB Migrations
- Use Jooq to connect to Mariadb Test Container to generate Java Files
- using gradle
- using quarkus (but is mostly independent from quarkus)
i can share with you my example project, maybe it helps.
If you have any questions, feel free to ask :)
If you have any questions, feel free to ask :)
Example-Project:
Gradle-Build File that contains the Gradle-Task for executing a custom JooqCodegen-Task that starts Liquibase and does everything:
Debapriya Patra
Jun 12, 2024, 11:09:15 AM6/12/24
to jooq...@googlegroups.com
Hi,
Looks like you are using docker-compose but in my case I am not using docker-compose.
Here is what I am doing using gradle task manually:
Looks like you are using docker-compose but in my case I am not using docker-compose.
Here is what I am doing using gradle task manually:
- Start a MySql testcontainer
- Apply DB migrations connecting to the same MySql testcontainer.
- Execute Jooq generate task connecting to the same MySql testcontainer as well.
Cheers,
Debapriya Patra
650.933.6852
650.933.6852
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/0de7d4ed-71e5-451b-ab2c-0ab6b6f258b6n%40googlegroups.com.
Bernd Huber
Jun 12, 2024, 3:06:44 PM6/12/24
to jOOQ User Group
Hello,
im using docker-compose in the project, for other purposes (not for the jooq-codegen)
While you have three different gradle files executing them in order,
i only have one gradle task, that does all the three steps you named within the Java Main-Class that is linked to this task:
the relevant part in the gradle file is following:
-------------
// configure generated/src-directories, necessary for use in intellij-idea.
def mySrcDir = "src/main/java"
def generatedDir = "src/main/generated"
sourceSets {
main {
java {
srcDir generatedDir
srcDir mySrcDir
}
}
}
idea {
module {
generatedSourceDirs.addAll(file(generatedDir))
sourceDirs.addAll(file(generatedDir))
sourceDirs.addAll(file(mySrcDir))
}
}
// jooqCodeGenerator task
task generateDatabase1JooqCode(type: JavaExec) {
group = 'application'
description = 'Runs JooqCodeGenerator Java Application'
mainClass = 'org.fk.database1.Database1CodeGenerator'
classpath = sourceSets.main.runtimeClasspath
}
-------------
// configure generated/src-directories, necessary for use in intellij-idea.
def mySrcDir = "src/main/java"
def generatedDir = "src/main/generated"
sourceSets {
main {
java {
srcDir generatedDir
srcDir mySrcDir
}
}
}
idea {
module {
generatedSourceDirs.addAll(file(generatedDir))
sourceDirs.addAll(file(generatedDir))
sourceDirs.addAll(file(mySrcDir))
}
}
// jooqCodeGenerator task
task generateDatabase1JooqCode(type: JavaExec) {
group = 'application'
description = 'Runs JooqCodeGenerator Java Application'
mainClass = 'org.fk.database1.Database1CodeGenerator'
classpath = sourceSets.main.runtimeClasspath
}
--------------
When you take a look at the task, you see it calls a java main file: "org.fk.database1.Database1CodeGenerator'"
This main file does the following:
// 1. start the testcontainer and execute the liquibase-migrations on it
try (final Database1Testcontainer databaseTestcontainer = new Database1Testcontainer()) {
final FkMariaDb fkMariaDb = databaseTestcontainer.getFkMariadb();
// 2. execute the jooq-codegen on this testcontainer/database:
GenerationTool.generate(new Configuration()
.withJdbc(new Jdbc()
.withDriver(Driver.class.getName())
.withUrl(fkMariaDb.getJdbcUrl())
.withUser(fkMariaDb.getUsername())
.withPassword(fkMariaDb.getPassword()))
...
}
This main file does the following:
// 1. start the testcontainer and execute the liquibase-migrations on it
try (final Database1Testcontainer databaseTestcontainer = new Database1Testcontainer()) {
final FkMariaDb fkMariaDb = databaseTestcontainer.getFkMariadb();
// 2. execute the jooq-codegen on this testcontainer/database:
GenerationTool.generate(new Configuration()
.withJdbc(new Jdbc()
.withDriver(Driver.class.getName())
.withUrl(fkMariaDb.getJdbcUrl())
.withUser(fkMariaDb.getUsername())
.withPassword(fkMariaDb.getPassword()))
...
}
I find it more convenient to do all this in Java, instead of Gradle, because it makes the parts of it (Testcontainers, Liquibase, ..) also reusable
for other parts of the application (like spinning up Testcontainer / Liquibase-Migrations for Unit-Tests)
Debapriya Patra
Jun 13, 2024, 1:12:38 AM6/13/24
to jOOQ User Group
I see but we wanted to keep the control as part of gradle task and its just that I am having an issue while connecting to MySql testcontainer when executing Jooq task. Need to look into that like why its an issue.
Debapriya Patra
Jun 13, 2024, 3:40:29 AM6/13/24
to jooq...@googlegroups.com
BTW, I was able to resolve the issue and now it’s generating the pojos. It was due to a missing driver issue
Cheers,
Debapriya Patra
650.933.6852
650.933.6852
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/a8bf3440-9b27-4493-bf5e-8b7ed6fb61d7n%40googlegroups.com.
Lukas Eder
Jun 13, 2024, 11:08:11 AM6/13/24
to jooq...@googlegroups.com
For the record, here's how I would do testcontainers tasks related to jOOQ code generation:
I'll refine this further in the near future, including making it incremental build capable, once jOOQ 3.19.10 ships:
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAM2NkrS%2BsKq%2Bq92AyobzvDDVp8ncqV7BdV0nQPNgVaH2Eqyi9Q%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages