Flyway says No database found to handle jdbc:postgresql://localhost:5432/postgres when using java migrator in jar only
#3889
Labels
Comments
|
Thank you for your issue. I cannot initially see what would be causing the issue. However, because you are using Kotlin and I am unsure how Flyways service loader reacts in a Kotlin environment, I will need to do some investigation. |
|
In the meanwhile, would you be able to enable any sort of debug logging in your application to allow Flyway to log more debug information to potentially help locate the issue. |
|
Turned on the debugger for flyway and here is the output for running with gradle vs jar. Although I'm not sure how helpful turning on the debug logs are since flyway is crashing the app before its able to log anything. Is there something else I could do to get more detailed logs? I had updated my logback configuration with the following to get the debug info from flyway: <configuration>
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%d{YYYY-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
</encoder>
</appender>
<root level="trace">
<appender-ref ref="STDOUT"/>
</root>
<logger name="io.netty" level="INFO"/>
<logger name="org.flywaydb" level="DEBUG"/>
</configuration>Successful migration with gradleFailing migration with java jar |
|
This works for me as a solution. val pg = PGSimpleDataSource()
pg.setUrl("jdbc:postgresql://localhost:5432/db?user=user&password=password")
val flyway = Flyway.configure().dataSource(pg).load()
flyway.migrate()Make sure to add |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Which version and edition of Flyway are you using?
10.12.0Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Java API. Gradle wrapper version 8.4
Which database are you using? (Type & version)
Postgres 12.18
driver 42.7.2
Which operating system are you using?
Mac OS sonoma 14.4.1
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)
buildscript { repositories { mavenCentral() } dependencies { classpath("org.postgresql:postgresql:42.7.2") classpath("org.flywaydb:flyway-database-postgresql:10.12.0") } } plugins { id("org.flywaydb.flyway") version "10.12.0" } dependencies { implementation("org.flywaydb:flyway-core:10.12.0") implementation("org.flywaydb:flyway-database-postgresql:10.12.0") } tasks { task("stage") { dependsOn("jar") mustRunAfter("clean") } jar { duplicatesStrategy = DuplicatesStrategy.INCLUDE manifest { attributes["Main-Class"] = "com.plusmobileapps.wolfpack.backend.ApplicationKt" } exclude("META-INF/*.RSA", "META-INF/*.SF", "META-INF/*.DSA") from( configurations.runtimeClasspath.get().map { if (it.isDirectory) it else zipTree(it) } ) } }What did you expect to see?
After running the stage task which builds the jar file, the migrator should run successfully upon app startup:
This works fine when running from the command line with the gradle wrapper, it only seems to have an error when running from the jar file.
What did you see instead?
Related
I have already come across a couple of issues with some suggestions which I had included in this solution, but still can't seem to get this to work with the jar.
No database found to handle jdbc:postgresql://localhost/access_pointwhen deployed as Jar #3722The text was updated successfully, but these errors were encountered: