Unknown configuration property: flyway.plugins.postgresql.transactional.lock

[ayush-finix]

Which version and edition of Flyway are you using?

10.10.0 Open Source

If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)

Latest version

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Gradle plugin

Which database are you using? (Type & version)

Postgres 15

Which operating system are you using?

Ubuntu docker image

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

Configure postgres transactional lock property as described on https://documentation.red-gate.com/flyway/flyway-cli-and-api/configuration/parameters/flyway/postgresql-transactional-lock
and
#3508 (comment)

What did you expect to see?

Applied flyway migration

What did you see instead?

Error reading configuration property when running flywayMigrate task

buildscript {
    dependencies {
        classpath 'org.flywaydb:flyway-database-postgresql:10.10.0'
        classpath 'org.postgresql:postgresql:42.7.3'
    }
}

plugins {
    id "org.flywaydb.flyway" version "10.10.0"
}

flyway {
    pluginConfiguration = [
            postgresqlTransactionalLock: 'false'
    ]
}

wrapper {
    gradleVersion = '8.6'
    distributionType = Wrapper.DistributionType.ALL
}

* What went wrong:
Execution failed for task ':flywayMigrate'.
> Error occurred while executing flywayMigrate
  Unknown configuration property: flyway.plugins.postgresql.transactional.lock

Looking through the plugin code, I do see the plugin adding the prefix here:

flyway/flyway-gradle-plugin/src/main/java/org/flywaydb/gradle/task/AbstractFlywayTask.java

Line 788 in 5511c69

String camelCaseRegex = "(?<!(^|[A-Z]))(?=[A-Z])|(?<!^)(?=[A-Z][a-z])";

. I'm not sure if that's an issue but it does seem related. I also don't see any way to add an arbitrary property in the gradle config when looking through

flyway/flyway-gradle-plugin/src/main/java/org/flywaydb/gradle/task/AbstractFlywayTask.java

Line 694 in ad0c64c

private Map<String, String> createFlywayConfig(Map<String, String> envVars) {

, so I think you'd have to workaround by using any of the other configuration options.