Spring Boot集成Flyway迁移报错：无法识别Oracle数据库URL

在Spring Boot项目中使用FlywayDB执行数据库迁移时，收到错误提示no database found to handle my url。数据库为本地Docker容器运行的最新版Oracle Express，build.gradle配置文件如下：

import org.jetbrains.kotlin.gradle.tasks.KotlinCompile

plugins {
    id 'org.springframework.boot' version '3.2.1'
    id 'io.spring.dependency-management' version '1.1.4'
    id 'org.jetbrains.kotlin.jvm' version '1.9.21'
    id 'org.jetbrains.kotlin.plugin.spring' version '1.9.21'
    id 'org.jetbrains.kotlin.plugin.jpa' version '1.9.21'
    id 'org.flywaydb.flyway' version '10.4.1'
}

flyway {
    url = 'jdbc:oracle:thin:@//localhost:3000/XEPDB1'
    user = 'pdbadmin'
    password = 'my_password'`your text`
    driver = 'oracle.jdbc.OracleDriver'
    cleanDisabled = false
}

group = 'com.pdrake'
version = '0.0.1-SNAPSHOT'

java {
    sourceCompatibility = '17'
}

repositories {
    mavenCentral()
}

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
    implementation 'org.springframework.boot:spring-boot-starter-security'
    implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'
    implementation 'org.springframework.boot:spring-boot-starter-validation'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'com.fasterxml.jackson.module:jackson-module-kotlin'
    implementation 'org.flywaydb:flyway-core'
    implementation 'org.flywaydb:flyway-database-oracle'
    implementation 'org.jetbrains.kotlin:kotlin-reflect'
    implementation 'org.springframework.session:spring-session-core'
    implementation 'org.thymeleaf.extras:thymeleaf-extras-springsecurity6'
    implementation 'org.springframework.session:spring-session-core'
    implementation 'org.springframework.session:spring-session-core'
    implementation 'org.springframework.session:spring-session-core'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
    testImplementation 'org.springframework.security:spring-security-test'
    runtimeOnly 'com.oracle.database.jdbc:ojdbc11'
}
tasks.withType(KotlinCompile) {
    kotlinOptions {
        freeCompilerArgs += '-Xjsr305=strict'
        jvmTarget = '17'
    }
}

tasks.named('test') {
    useJUnitPlatform()
}

尝试过多种URL组合仍无法识别数据库，可按以下步骤排查修复：

1. 修复配置文件语法错误 #

flyway配置块中，password = 'my_password'后面多了无关的your text内容，这会导致Groovy语法解析失败，先删除这段内容，修正后的flyway块：

flyway {
    url = 'jdbc:oracle:thin:@//localhost:3000/XEPDB1'
    user = 'pdbadmin'
    password = 'my_password'
    driver = 'oracle.jdbc.OracleDriver'
    cleanDisabled = false
}

2. 明确指定Flyway数据库类 #

Flyway 10+版本中，部分数据库驱动需要明确指定数据库实现类，避免自动识别失败。在flyway配置中添加databaseClass：

flyway {
    // ... 其他配置
    databaseClass = 'org.flywaydb.database.oracle.OracleDatabase'
}

3. 验证JDBC URL与容器端口映射 #

• 确认Docker容器的端口映射是否正确：本地3000端口是否映射到了Oracle容器的默认1521端口（启动容器时需加参数-p 3000:1521）。
• Oracle可插拔数据库XEPDB1的JDBC URL格式是正确的，两种写法都支持：jdbc:oracle:thin:@//localhost:3000/XEPDB1 或 jdbc:oracle:thin:@localhost:3000/XEPDB1。

4. 确认依赖版本兼容性 #

• 确保flyway插件版本（10.4.1）与flyway-core、flyway-database-oracle依赖版本一致，当前配置中三者版本匹配，无需调整。
• ojdbc11依赖为runtimeOnly是正确的，确保其版本与Oracle容器版本兼容（最新版Oracle XE适配ojdbc11）。

内容的提问来源于stack exchange，提问作者Paul D