| | |
|---|
| | | password: |
|---|
| | | # oracle: |
|---|
| | | # driverClassName: oracle.jdbc.OracleDriver |
|---|
| | | # # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562 |
|---|
| | | # # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能(对数据库有性能损耗 使用批量操作应考虑性能问题) |
|---|
| | | # url: jdbc:oracle:thin:@//localhost:1521/XE?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true |
|---|
| | | # url: jdbc:oracle:thin:@//localhost:1521/XE |
|---|
| | | # username: ROOT |
|---|
| | | # password: root |
|---|
| | | # druid: |
|---|
| | | # validationQuery: SELECT 1 FROM DUAL |
|---|
| | | # postgres: |
|---|
| | | # driverClassName: org.postgresql.Driver |
|---|
| | | # url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true |
|---|
| | | # username: root |
|---|
| | | # password: root |
|---|
| | | # sqlserver: |
|---|
| | | # driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver |
|---|
| | | # url: jdbc:sqlserver://localhost:1433;DatabaseName=tempdb;SelectMethod=cursor;rewriteBatchedStatements=true |
|---|
| | | # username: SA |
|---|
| | | # password: root |
|---|
| | | druid: |
|---|
| | | # 初始连接数 |
|---|
| | |
|---|
| | | # 配置一个连接在池中最大生存的时间，单位是毫秒 |
|---|
| | | maxEvictableIdleTimeMillis: 900000 |
|---|
| | | # 配置检测连接是否有效 |
|---|
| | | validationQuery: SELECT 1 FROM DUAL |
|---|
| | | validationQuery: SELECT 1 |
|---|
| | | testWhileIdle: true |
|---|
| | | testOnBorrow: false |
|---|
| | | testOnReturn: false |
|---|
