由于没用过oracle,配置完数据源之后,报错!之后百度很多,循环报错!!!!!
找了好久,找到正确的配置方法!看图!
1
.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
2
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仓库中,因为不支持远程依赖)
更多推荐
springboot连接Oracle数据库配置
发布评论