我为我的角项目开发了一个Spring Boot RestController并遇到了问题 . 在我的休息服务逻辑中,我使用了两个不同的数据库来获取数据 .
在这里您可以看到数据源配置:
[application.properties]
#datasource1
spring.datasource.url=[url]
spring.datasource.username=[username]
spring.datasource.password=[password]
spring.datasource.driverClassName=org.h2.Driver
#datasource2
spring.secondDatasource.url=[url]
spring.secondDatasource.username=[username]
spring.secondDatasource.password=[password]
spring.secondDatasource.driverClassName=oracle.jdbc.OracleDriver
[DatasourceConfig.java]
@Bean
@Primary
@ConfigurationProperties(prefix="spring.datasource")
public DataSource h2DataSource() {
return DataSourceBuilder.create().build();
}
@Bean
@ConfigurationProperties(prefix="spring.secondDatasource")
public DataSource oracleDataSource() {
return DataSourceBuilder.create().build();
}
记录输出:(此问题不会引发异常)
...
2016-11-22 13:20:25.853 [INFO ] 1 [main] d.b.s.Application : Started Application in 7.757 seconds (JVM running for 12.515)
2016-11-22 13:20:31.731 [INFO ] 62 [http-nio-8080-exec-1] o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization started
2016-11-22 13:20:31.757 [INFO ] 62 [http-nio-8080-exec-1] o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization completed in 26 ms
2016-11-22 13:20:34.984 [INFO ] 65 [http-nio-8080-exec-5] d.b.s.r.RESTclient : /rest/getMyData
2016-11-22 13:20:34.992 [INFO ] 63 [http-nio-8080-exec-2] d.b.s.r.RESTclient : /rest/getMyData2
2016-11-22 13:20:34.993 [INFO ] 69 [http-nio-8080-exec-8] d.b.s.r.RESTclient : /rest/getMyData3
2016-11-22 13:20:35.004 [DEBUG] 65 [http-nio-8080-exec-5] d.b.s.DataSourceService : getH2Connection()
2016-11-22 13:20:35.022 [DEBUG] 63 [http-nio-8080-exec-2] d.b.s.DataSourceService : getOracleConnection()
2016-11-22 13:20:35.022 [DEBUG] 69 [http-nio-8080-exec-8] d.b.s.DataSourceService : getH2Connection()
问题是,休息服务的每个使用过的工作线程(http-nio-8080-?,...)都在我的DataSourceService中的datasource.getConnection()处挂起 . 它会永远冻结并等待无法获取的连接 .
@Service
public class DataSourceService {
private final DataSource h2DataSource;
private final DataSource oracleDataSource;
@Autowired
public DataSourceService(DataSource h2DataSource, DataSource oracleDataSource) {
this.h2DataSource = h2DataSource;
this.oracleDataSource = oracleDataSource;
}
public Connection getH2Connection() throws SQLException {
LoggerUtil.logDebug(getClass(), "getH2Connection()");
return h2Connection.getConnection();
}
public Connection getOracleConnection() throws SQLException {
LoggerUtil.logDebug(getClass(), "getOracleConnection()");
return oracleConnection.getConnection();
}
}
关于它的奇怪之处在于,有时它可以在没有改变代码行(所有时间的5%)和大多数(95%的所有时间)的情况下工作 .
在我的pom.xml中,我有以下数据库驱动程序依赖项:
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.193</version>
<scope>runtime</scope>
</dependency>
如果所有数据源都具有相同的驱动程序,这将永远不会发生,但在组合中我发现了这种奇怪的行为 .
我的想法是,只有在oracle之前初始化h2Database时才会发生这种情况 . 此时,spring类加载器加载h2驱动程序类,它们将被缓存 . 接下来,oracle被初始化,并且一些类将完全相同,因此一些h2类用于oracle . 因此,创建了奇怪的冻结状态 . (也许反之亦然) .
My question now: Why can't I use the H2 and Oracle database at the same time with Spring-boot?
编辑:
经过一些调试后,我发现了更多的信息:
[org.apache.tomcat.jdbc.pool.ClassLoaderUtil]
Row 29: loadClass(...)
...
Row 38: return Class.forName(className, true, cl); //className: "oracle.jdbc.OracleDriver" cl: Launcher$AppClassLoader
在ClassLoaderUtil中是按类名查找Driver-Class . 可以毫无问题地解析className“org.h2.Driver”,但“oracle.jdbc.OracleDriver”不会 .
之后我做了一个线程转储,你可以看到卡点 . 此时有5条卡住的螺纹卡在不同的位置 .
http-nio-8080-exec-2 @ 8307(runnable)(仅使用oracle数据库)
"http-nio-8080-exec-2@8307" daemon prio=5 tid=0x40 nid=NA runnable
java.lang.Thread.State: RUNNABLE
blocks http-nio-8080-exec-6@8311
at java.lang.Class.forName0(Class.java:-1)
at java.lang.Class.forName(Class.java:348)
at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:271)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:650)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
- locked <0x2139> (a org.apache.tomcat.jdbc.pool.DataSource)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at d.b.s.DataSourceService.getConnection(DataSourceService.java:51) //<-- That's my package
...
http-nio-8080-exec-3 @ 8308(runnable)(oracle和h2数据之间的比较)
"http-nio-8080-exec-3@8308" daemon prio=5 tid=0x41 nid=NA runnable
java.lang.Thread.State: RUNNABLE
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:190)
at java.lang.Class.forName0(Class.java:-1)
at java.lang.Class.forName(Class.java:348)
at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:271)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:650)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
- locked <0x213d> (a org.apache.tomcat.jdbc.pool.DataSource)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at d.b.s.DataSourceService.getConnection(DataSourceService.java:51)
...
http-nio-8080-exec-4 @ 8309(runnable)(oracle和h2数据之间的比较)
(与exec-2相同)
http-nio-8080-exec-5 @ 8310(runnable)(仅使用h2数据库)
"http-nio-8080-exec-5@8310" daemon prio=5 tid=0x43 nid=NA runnable
java.lang.Thread.State: RUNNABLE
at sun.reflect.GeneratedConstructorAccessor109.newInstance(Unknown Source:-1)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:-1)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.lang.Class.newInstance(Class.java:442)
at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:380)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404)
at java.util.ServiceLoader$1.next(ServiceLoader.java:480)
at java.sql.DriverManager$2.run(DriverManager.java:603)
at java.sql.DriverManager$2.run(DriverManager.java:583)
at java.security.AccessController.doPrivileged(AccessController.java:-1)
at java.sql.DriverManager.loadInitialDrivers(DriverManager.java:583)
at java.sql.DriverManager.<clinit>(DriverManager.java:101)
at org.h2.Driver.load(Driver.java:155)
at org.h2.Driver.<clinit>(Driver.java:41)
at java.lang.Class.forName0(Class.java:-1)
- locked <0x211b> (a java.lang.Class)
at java.lang.Class.forName(Class.java:348)
at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:271)
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:718)
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:650)
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
- locked <0x20e9> (a org.apache.tomcat.jdbc.pool.DataSource)
at d.b.s.DataSourceService.getConnection(DataSourceService.java:51)
...
http-nio-8080-exec-6 @ 8311(等待监视器输入)(oracle和h2数据之间的比较)
"http-nio-8080-exec-6@8311" daemon prio=5 tid=0x44 nid=NA waiting for monitor entry
java.lang.Thread.State: BLOCKED
waiting for http-nio-8080-exec-2@8307 to release lock on <0x2139> (a org.apache.tomcat.jdbc.pool.DataSource)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:115)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at d.b.s.DataSourceService.getConnection(DataSourceService.java:51)
...
1 回答
我遇到了和你一样的问题,但是在h2和mysql中 . 我不是同时使用h2和oracle,在这个post中,也许你可以找到一些有用的东西 .
这是我的双数据源配置:
maven依赖:
<!-- stater mybatis --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <!-- jdbc --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency>