Codegen case sensivity

[Jouda-Hidri]

Codegen case sensivity

[lukaseder]

Thanks for your message. I'm assuming this question is also yours?

• https://stackoverflow.com/q/78354054/521799

Can you please show your complete code generation configuration?

[Jouda-Hidri]

project.flyway {
            user = project.rootProject.name
            url = "jdbc:h2:file:${buildDir}/generated/h2/${project.rootProject.name};mode=MySQL;DATABASE_TO_LOWER=TRUE"
            driver = 'org.h2.Driver'
        }
        project.dependencies {
            jooqGenerator 'com.h2database:h2:2.2.224'
        }

        project.jooq {
            version = '3.19.3'
            configurations {
                main {
                    generationTool {
                        jdbc {
                            driver = 'org.h2.Driver'
                            url = project.flyway.url
                            user = project.flyway.user
                        }
                        generator {
                            database {
                                inputSchema = 'public'
                            }
                            target {
                                packageName = project.rootProject.group + '.' + project.name.replaceAll('[-_]', '') + '.jooq'
                                directory = "${buildDir}/generated/source/jooq/main"
                            }
                            generate {
                                javaTimeTypes = false
                            }
                        }
                        logging = 'DEBUG'
                    }
                }
            }
        }

[lukaseder]

I wonder, is this really a problem caused by jOOQ instead of by your H2 upgrade? I don't see why jOOQ would produce such a change on its own. Does your H2 database produce lower case identifiers when you connect to it (e.g. using Dbeaver) and query the INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS views?

Please note that rather than using H2 to generate code, why not work with testcontainers and an actual MySQL instance. That would also allow you to use vendor specific features not supported by H2's mode=MySQL mode:
https://blog.jooq.org/using-testcontainers-to-generate-jooq-code/

[Jouda-Hidri]

Per default H2 tables, columns and schema are UPPER_CASE. I had to change the config for H2 to lower_case and then the schema from 'PUBLIC' to 'public' for JOOQ code-gen.