techhero-base-datagovern-local.yml 6.35 KB
Newer Older
1 2
datasource:
  exam:
3
    url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
4
    driver-class-name: oracle.jdbc.OracleDriver
5 6
    username: jcsjv2_dev
    password: jcsjv2_dev
7 8 9 10 11
    #test
    #url: jdbc:oracle:thin:@119.96.85.104:1521:orcl
    #driver-class-name: oracle.jdbc.OracleDriver
    #username: jcsjv2
    #password: jcsjv2
12
    
13
#试卷跟踪    
14 15 16
sjgzdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
17 18
  username: sjgzv1_dev    
  password: sjgzv1_dev
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
      
35
#试卷跟踪主题
36 37 38
sjgzztdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
39 40
  username: sjgz_zt_dev
  password: sjgz_zt_dev
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 9                                  #初始化提供的连接数
  minIdle: 9                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
56 57 58 59
#应急指挥
yjzhdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
60 61
  username: yjzh_dev    
  password: yjzh_dev
62 63 64
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
65 66 67 68 69 70 71 72 73 74 75 76
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
77
#作弊防控
78 79 80
zbfkdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
81 82
  username: zbfk_yw_dev    
  password: zbfk_yw_dev
83 84 85
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
86 87 88 89 90 91 92 93 94 95 96 97
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
98

99
#身份认证
100 101 102
sfrzdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
103 104
  username: sfrzv1_dev
  password: sfrzv1_dev
105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
  driverClassName: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
      
      
      
      
124
    
125 126 127 128 129 130 131 132 133
ftp:
  server:
    info: sftp://172.16.20.133:22/../home/temp/data?username=root&password=root&delay=5s&move=done&readLock=rename
  local:
    windir: C:/ftp/test
    lindir: /data/ftp/test
task:
  switch: true