springboot连接Oracle数据库配置

.properties文件中指定Oracle数据源

spring.datasource.oracle.jdbc-url=jdbc:oracle:thin:@IP:1521/数据库
spring.datasource.oracle.username=
spring.datasource.oracle.password=
spring.datasource.oracle.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.oracle.maximum-pool-size=5



Hikari配置Oracle连接池
	
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;

import com.zaxxer.hikari.HikariDataSource;

@Configuration
public class OracleDataSourceConfig {
	  @Bean(name = "OracleDataSource")
	  @ConfigurationProperties(prefix = "spring.datasource.oracle")
	  public HikariDataSource dataSource() {
	    return (HikariDataSource) DataSourceBuilder.create().type(HikariDataSource.class).build();
	  }
	  
	  
	  @Bean(name="oracleJdbcTemplate")
	  public JdbcTemplate oracleJdbcTemplate(@Qualifier("OracleDataSource") HikariDataSource OracleDataSource){
			return new JdbcTemplate(OracleDataSource);
		}
}	
	
依赖包：ojdbc7-12.1.0.2.jar（需要自己下载，并安装到maven仓库中，因为不支持远程依赖）