使用com.zaxxer.hikari.HikariDataSource出错
使用com.zaxxer.hikari.HikariDataSource出错
提问于 2015-06-24 12:26:34
我在将HikariCP与Spring的JdbcTemplate集成时遇到了错误。我正在使用Spring3.2.2、HikariCP 2.3.8和sybase jconn4版本7.0.0
弹簧配置：
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<property name="dataSourceClassName" value="com.sybase.jdbc4.jdbc.SybDataSource" />
<property name="connectionTestQuery" value="SELECT 1" />
<property name="maximumPoolSize" value="100" />
<property name="idleTimeout" value="60000" />
<property name="jdbcUrl"
value="jdbc:sybase:Tds:${hostname}:${port}/${dbname}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</bean>
<bean id="ds" class="com.zaxxer.hikari.HikariDataSource"
destroy-method="close">
<constructor-arg ref="hikariConfig" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource">
<ref bean="ds" />
</property>
</bean>每次加载上下文时，它都会抛出此错误，并且无法创建数据源
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds' defined in class path resource [commons/config/datasourceTest.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1051)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:955)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:490)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:626)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:120)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:100)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:248)
at org.springframework.test.context.CacheAwareContextLoaderDelegate.loadContextInternal(CacheAwareContextLoaderDelegate.java:64)
at org.springframework.test.context.CacheAwareContextLoaderDelegate.loadContext(CacheAwareContextLoaderDelegate.java:91)
... 25 more
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.zaxxer.hikari.HikariDataSource]: Constructor threw exception; nested exception is com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:121)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280)
... 42 more
Caused by: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization
at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:544)
at com.zaxxer.hikari.pool.BaseHikariPool.<init>(BaseHikariPool.java:171)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:60)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:48)
at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:80)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148)
... 44 more
Caused by: java.sql.SQLException: JZ0PN: Specified port number of -1 was out of range. Port numbers must meet the following conditions: 0 <= portNumber <= 65535
at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.a(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(Unknown Source)
at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDriver.createConnection(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDriver.connect(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDriver.connect(Unknown Source)
at com.sybase.jdbc4.jdbc.SybDataSource.getConnection(Unknown Source)
at com.zaxxer.hikari.pool.BaseHikariPool.addConnection(BaseHikariPool.java:438)
at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:542)
... 53 more有趣的是，如果我用简单的代码来做的话，它就能很好地工作。
public class JdbcTemplateFactoryTest {
@Autowired
HikariConfig hikariConfig;
//@Autowired
//HikariDataSource ds;
@Test
public void hikaritest(){
HikariDataSource ds = new HikariDataSource(hikariConfig);
JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
assertNotNull(jdbcTemplate);
}
}奇怪的是，如果我取消注释ds到spring加载)，它就会失败。
花了一整天时间在这上面。任何建议都是感激的
回答 2
Stack Overflow用户
回答已采纳
发布于 2015-06-24 14:46:33
dataSourceClassName和jdbcUrl属性是互斥的(去看医生)。你有两个选择..。
1)使用dataSourceClassName
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<property name="dataSourceClassName" value="com.sybase.jdbc4.jdbc.SybDataSource" />
<property name="connectionTestQuery" value="SELECT 1" />
<property name="maximumPoolSize" value="100" />
<property name="idleTimeout" value="60000" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<property name="dataSourceProperties">
<props>
<property name="serverName" value="${hostname}" />
<property name="port" value="${port}" />
<property name="databaseName" value="${dbname}" />
</props>
</property>
</bean>-或-
2)使用jdbcUrl
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<property name="jdbcUrl"
value="jdbc:sybase:Tds:${hostname}:${port}/${dbname}" />
<property name="connectionTestQuery" value="SELECT 1" />
<property name="maximumPoolSize" value="100" />
<property name="idleTimeout" value="60000" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</bean>如果您的驱动程序没有自动注册，则可能需要将driverClassName属性添加到选项2中。
更新:如果你能读到捷克语，你可以在这里读到同样的错误，http://blog.prodejna.biz/2013/03/glassfish-jms-broker-perzistujici.html。基本上，不要使用SyDataSource，只使用jdbcUrl-based方法(如果需要的话可能使用driverClassName )。
Stack Overflow用户
发布于 2018-08-21 16:06:18
在我的例子中，我向我的配置文件添加了一个配置文件，并且在没有指定它的情况下启动了spring。
@Bean
public DataSource dataSource() throws Exception {
JndiDataSourceLookup dataSourceLookup;
DataSource dataSource;
HikariDataSource hikariDataSource;
HikariConfig hikariConfig;
try {
LOGGER.info("BEGIN");
LOGGER.info("Creating DataSource");
dataSourceLookup = new JndiDataSourceLookup();
dataSourceLookup.setResourceRef(true);
dataSource = dataSourceLookup.getDataSource(CO_PARTICIPACAO_DS);
//hikariConfig = new HikariConfig(additionalProperties());
hikariConfig=new HikariConfig();
hikariConfig.setDataSource(dataSource);
hikariDataSource = new HikariDataSource(hikariConfig);
LOGGER.info("END");
return hikariDataSource;
} catch (Exception e) {
LOGGER.error(e.getMessage(), e);
throw new CoParticipacaoException(e);
}
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/31026545
复制相关文章
相似问题
腾讯云开发者
