Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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);
- }
- }
- private Properties additionalProperties() throws CoParticipacaoException {
- Properties properties;
- try {
- LOGGER.info("BEGIN");
- properties = new Properties();
- LOGGER.info("Using adicional Hibernate properties:");
- // properties.setProperty("hibernate.hbm2ddl.auto", "create-drop");
- properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
- properties.setProperty("spring.jpa.properties.hibernate.jdbc.time_zone", "UTC");
- properties.setProperty("spring.datasource.driver-class-name", "com.mysql.cj.jdbc.Driver");
- properties.setProperty("spring.jpa.datasource.driver-class-name", "com.mysql.cj.jdbc.Driver");
- properties.setProperty("spring.datasource.driver-class", "com.mysql.cj.jdbc.Driver");
- properties.setProperty("hibernate.connection.driver_class", "com.mysql.cj.jdbc.Driver");
- properties.setProperty("spring.datasource.hikari.driverClassName", "com.mysql.cj.jdbc.Driver");
- properties.setProperty("spring.datasource.hikari.dataSourceClassName", "com.mysql.jdbc.jdbc2.optional.MysqlDataSource");
- properties.setProperty("spring.jpa.show-sql", "true");
- properties.setProperty("spring.jpa.hibernate.format_sql", "true");
- // properties.setProperty("spring.jpa.hibernate.ddl-auto",
- // "update");
- properties.setProperty("spring.jpa.properties.hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
- properties.setProperty("spring.jpa.hibernate.naming-strategy", "org.hibernate.cfg.ImprovedNamingStrategy");
- LOGGER.info("END");
- return properties;
- } catch (Exception e) {
- LOGGER.error(e.getMessage(), e);
- throw new CoParticipacaoException(e);
- }
- }
- @Primary
- @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.setDataSource(dataSource);
- hikariConfig.setDriverClassName("com.mysql.cj.jdbc.Driver");
- hikariDataSource = new HikariDataSource(hikariConfig);
- LOGGER.info("END");
- return hikariDataSource;
- } catch (Exception e) {
- LOGGER.error(e.getMessage(), e);
- throw new CoParticipacaoException(e);
- }
- }
Add Comment
Please, Sign In to add comment