我正在使用Spring Boot开发Web应用程序,并试图设置一个外部目录,用于存放各种JDBC驱动程序,最终用户可以选择使用。为了做到这一点,我正在添加:
loader.path=/opt/myapp/lib/
将以下内容添加到application.properties文件中,PropertySourcesPropertyResolver会自动获取:
2016-04-28 17:27:38.739 DEBUG 22539 --- [restartedMain] o.s.c.e.PropertySourcesPropertyResolver : Found key 'loader.path' in [applicationConfigurationProperties] with type [String] and value '/opt/myapp/lib/'
我的问题是我似乎无法从任何放入此���录的jar文件中加载任何JDBC驱动程序,我缺少什么?我正在使用默认的嵌入式Tomcat服务器。当我尝试使用Class.forName加载驱动程序时,我会得到以下错误消息,就好像这些jar文件不存在于该目录中。
public Connection buildConnection(DataSource dataSource) throws ClassNotFoundException, SQLException {
if (dataSource == null) {
throw new NullPointerException("Data Source is null!");
}
if (!dataSource.isReady()) {
throw new IllegalArgumentException("Data Source is reporting that it is not ready!");
}
logger.debug("Loading JDBC Driver: {}", dataSource.getDriverClass());
Class.forName(dataSource.getDriverClass());
logger.debug("Loaded Driver: {}", dataSource.getDriverClass());
logger.debug("Attempting to build connection using: {}", dataSource.getConnectionString());
DriverManager.setLoginTimeout(10);
Connection c = DriverManager.getConnection(dataSource.getConnectionString(), dataSource.getUserName(), dataSource.getPassword());
if (c != null) {
c.setAutoCommit(true);
c.setReadOnly(true);
return c;
}
throw new NullPointerException("Unable to create connection!");
}
这是抛出的异常。
2016-04-28 17:38:53.525 DEBUG 22539 --- [nio-8081-exec-5] c.c.reportout.processor.JobProcessor : Loading JDBC Driver: com.mysql.jdbc.Driver
2016-04-28 17:38:53.526 WARN 22539 --- [nio-8081-exec-5] c.c.reportout.processor.JobProcessor : Unable to successfully test connection: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[na:1.8.0_91]
at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[na:1.8.0_91]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) ~[na:1.8.0_91]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_91]
at org.springframework.boot.devtools.restart.classloader.RestartClassLoader.loadClass(RestartClassLoader.java:151) ~[spring-boot-devtools-1.3.3.RELEASE.jar:1.3.3.RELEASE]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[na:1.8.0_91]
at java.lang.Class.forName0(Native Method) ~[na:1.8.0_91]
at java.lang.Class.forName(Class.java:264) ~[na:1.8.0_91]
有什么提示可以帮助我调试或者说明我做错了什么吗?谢谢。