springboot连接oracle数据库

最新推荐文章于 2023-10-27 17:58:42 发布

长而不宰

最新推荐文章于 2023-10-27 17:58:42 发布

阅读量3.3k

点赞数 1

文章标签： spring boot 数据库 oracle

本文链接：https://blog.csdn.net/weixin_44892327/article/details/127826488

版权

springboot+mybatis+druid 连接oracle数据库
依赖

<!-- oracle jdbc 插件 -->
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>11.2.0.3</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

application.properties配置类

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
spring.datasource.username=root
spring.datasource.password=123456
# 最初大小
spring.datasource.druid.initial-size=4
# 最小连接数
spring.datasource.druid.min-idle=2
# 最大连接数
spring.datasource.druid.max-active=20
# 最长等待时间
spring.datasource.druid.max-wait=30000
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
spring.datasource.druid.minEvictableIdleTimeMillis=30000

mybatis.mapper-locations=classpath:mapper/*Mapper.xml
mybatis.configuration.call-setters-on-nulls=true
mybatis.configuration.map-underscore-to-camel-case=true