FlywayDB无法找到Postgresql驱动程序
FlywayDB无法找到Postgresql驱动程序
提问于 2020-05-14 22:49:48
我正在尝试得到一个Spigot/Bukkit MC插件内的Flyway设置。目前，每当我执行我们的SQL代码时，我都会得到错误`
[10:37:14 WARN]: org.flywaydb.core.api.FlywayException: Unable to instantiate JDBC driver: org.postgresql.Driver => Check whether the jar file is present
[10:37:14 WARN]: at org.flywaydb.core.internal.jdbc.DriverDataSource.<init>(DriverDataSource.java:180)
[10:37:14 WARN]: at org.flywaydb.core.internal.jdbc.DriverDataSource.<init>(DriverDataSource.java:144)
[10:37:14 WARN]: at org.flywaydb.core.api.configuration.ClassicConfiguration.setDataSource(ClassicConfiguration.java:1341)
[10:37:14 WARN]: at org.flywaydb.core.api.configuration.FluentConfiguration.dataSource(FluentConfiguration.java:803)
[10:37:14 WARN]: at com.mclockup.core.database.SqlWrapper.<init>(SqlWrapper.java:42)
[10:37:14 WARN]: at com.mclockup.core.database.SqlWrapper.initialize(SqlWrapper.java:78)
[10:37:14 WARN]: at com.mclockup.core.LockupCore.onEnable(LockupCore.java:22)
[10:37:14 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:263)
[10:37:14 WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
[10:37:14 WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:435)
[10:37:14 WARN]: at org.bukkit.craftbukkit.v1_15_R1.CraftServer.enablePlugin(CraftServer.java:470)
[10:37:14 WARN]: at org.bukkit.craftbukkit.v1_15_R1.CraftServer.enablePlugins(CraftServer.java:384)
[10:37:14 WARN]: at org.bukkit.craftbukkit.v1_15_R1.CraftServer.reload(CraftServer.java:884)
[10:37:14 WARN]: at org.bukkit.Bukkit.reload(Bukkit.java:654)
[10:37:14 WARN]: at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:54)
[10:37:14 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:159)
[10:37:14 WARN]: at org.bukkit.craftbukkit.v1_15_R1.CraftServer.dispatchCommand(CraftServer.java:752)
[10:37:14 WARN]: at org.bukkit.craftbukkit.v1_15_R1.CraftServer.dispatchServerCommand(CraftServer.java:714)
[10:37:14 WARN]: at net.minecraft.server.v1_15_R1.DedicatedServer.handleCommandQueue(DedicatedServer.java:469)
[10:37:14 WARN]: at net.minecraft.server.v1_15_R1.DedicatedServer.b(DedicatedServer.java:431)
[10:37:14 WARN]: at net.minecraft.server.v1_15_R1.MinecraftServer.a(MinecraftServer.java:1112)
[10:37:14 WARN]: at net.minecraft.server.v1_15_R1.MinecraftServer.run(MinecraftServer.java:934)
[10:37:14 WARN]: at java.lang.Thread.run(Thread.java:748)
[10:37:14 WARN]: Caused by: org.flywaydb.core.api.FlywayException: Unable to instantiate class org.postgresql.Driver : org.postgresql.Driver
[10:37:14 WARN]: at org.flywaydb.core.internal.util.ClassUtils.instantiate(ClassUtils.java:59)
[10:37:14 WARN]: at org.flywaydb.core.internal.jdbc.DriverDataSource.<init>(DriverDataSource.java:176)
[10:37:14 WARN]: ... 22 more
[10:37:14 WARN]: Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
[10:37:14 WARN]: at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
[10:37:14 WARN]: at java.lang.ClassLoader.loadClass(ClassLoader.java:419)
[10:37:14 WARN]: at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352)
[10:37:14 WARN]: at java.lang.ClassLoader.loadClass(ClassLoader.java:352)
[10:37:14 WARN]: at java.lang.Class.forName0(Native Method)
[10:37:14 WARN]: at java.lang.Class.forName(Class.java:348)
[10:37:14 WARN]: at org.flywaydb.core.internal.util.ClassUtils.instantiate(ClassUtils.java:57)
[10:37:14 WARN]: ... 23 more我不认为这是一个依赖问题，因为我已经在我的build.gradle中包含了Flyway和postgresql
plugins {
id 'java'
id 'maven-publish'
id 'signing'
}
group = 'com.mclockup'
version = '1.0.0-SNAPSHOT'
description = 'Core functionality used everywhere in Lockup'
archivesBaseName = 'core'
sourceCompatibility = '1.8'
repositories {
mavenLocal()
mavenCentral()
}
dependencies {
// Spigot
implementation group: 'org.spigotmc', name: 'spigot-api', version: '1.15.2-R0.1-SNAPSHOT'
// Postgres
compile group: 'org.postgresql', name: 'postgresql', version: '42.2.12'
// Flyway
compile group: 'org.flywaydb', name: 'flyway-core', version: '6.4.1'
// MyBatis
compile group: 'org.mybatis', name: 'mybatis', version: '3.5.4'
// Log4J
compile group: 'org.apache.logging.log4j', name: 'log4j-api', version: '2.13.2'
compile group: 'org.apache.logging.log4j', name: 'log4j-core', version: '2.13.2'
}
jar {
from {
configurations.compile.collect { it.isDirectory() ? it : zipTree(it) }
}
}
javadoc {
options.links += "https://hub.spigotmc.org/javadocs/spigot/"
}
task sourcesJar(type: Jar) {
from sourceSets.main.allJava
archiveClassifier.set("sources")
}
task javadocJar(type: Jar, dependsOn: javadoc) {
classifier 'javadoc'
from javadoc.destinationDir
}它在我们的第二行出错了
Flyway flyway = Flyway.configure()
.dataSource(getJdbcString(), DATABASE_USERNAME, DATABASE_PASSWORD)
.load();
flyway.migrate();我可以确认jdbcstring和用户名/密码是正确的，因为我能够通过DriverManager建立连接，但Flyway似乎找不到驱动程序。另外，我可以在我的输出jar中看到驱动程序，它位于blah.jar\org\postgresql\Driver.class中
非常感谢大家的帮助！！谢谢
回答 1
Stack Overflow用户
回答已采纳
发布于 2020-05-17 14:41:31
想明白了！事实证明，我们使用的spigot服务器软件使用的类加载器与主java线程不同，因此在加载jdbc驱动程序时会导致问题。我们通过传入正确的类加载器修复了这个问题。
Flyway flyway = Flyway.configure(LockupCore.getInstance().getPublicClassLoader())页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/61800388
复制相关文章
相似问题
腾讯云开发者
