Mysql/Oracle/postgresql 数据源连接方式

最新推荐文章于 2023-10-06 14:54:30 发布

²º²ºº²º²

最新推荐文章于 2023-10-06 14:54:30 发布

阅读量226

点赞数

分类专栏： JDBC 文章标签： mysql jdbc oracle postgresql

本文链接：https://blog.csdn.net/qq_43310141/article/details/119008614

版权

JDBC 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Mysql/Oracle/postgresql 数据源连接方式

依赖版本仅供参考


# mysql 连接方式
spring:
  application:
    name: XXX-XXX-XXX-XXX
  datasource:
    driverClassName: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource   
    url: jdbc:mysql://10.00.00.111:111/middleground_bpm?autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT%2B8
    username: mysql           #用户名
    password: mysql           #密码
    druid:
       filter:
         config:
            enabled: true
     connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000;config.decrypt=false;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKdsP3Q1E0N/CCTXwdXklHSwe55Bh8hibnnSU+Vd0s7GqGfpFoJjFathbEzTpOJLLjdZfNn8h2SU0tJD30QhyUkCAwEAAQ==
     max-active: 20
     max-wait: 5000
     validation-query: select 1 from dual
     test-on-borrow: true
     test-while-idle: true
     connection-error-retry-attempts: 3
     time-between-eviction-runs-millis: 60000
     min-evictable-idle-time-millis: 600000
     keep-alive: true
     log-abandoned: true
     remove-abandoned: true
     remove-abandoned-timeout: 600

# oracle 连接方式
spring:
  application:
    name: XXX-XXX-XXX-XXX
  datasource:
    driverClassName: oracle.jdbc.driver.OracleDriver
    type: com.alibaba.druid.pool.DruidDataSource   
    url: jdbc:oracle:thin:@10.100.00.111:111/dwzy #数据源连接地址开发库
    username: oracle           #用户名
    password: oracle           #密码
    maxActive: 60
    initialSize: 1
    maxWait: 60000        #最大等待时间，单位为毫秒，默认60000毫秒
    minIdle: 1           #最小等待连接活动数
    testWhileIdle: true
    validationQuery: SELECT 1 from dual
    filters: stat,wall,log4j
    maxPoolPreparedStatementPerConnectionSize: 20
    useGlobalDataSourceStat: true
    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
    

# postgresql 连接方式
spring:
  application:
    name: XXX-XXX-XXX-XXX
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: org.postgresql.Driver
    url: jdbc:postgresql://10.00.00.111:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true    #数据源连接地址开发库
    username: postgres            #用户名
    password: postgres            #密码

    <!-- pom依赖  -->
    <!-- DataBase  mysql  -->
    <dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>8.0.15</version>
		<scope>compile</scope>
	</dependency>
	
    <!-- DataBase  oracle  -->
    <dependency>
		<groupId>com.oracle</groupId>
		<artifactId>ojdbc6</artifactId>
		<version>11.2.0.4</version>
	</dependency>
	
    <!-- DataBase  postgresql  -->
	<dependency>
		<groupId>org.postgresql</groupId>
		<artifactId>postgresql</artifactId>
		<version>42.1.4</version>
    </dependency>