datasource: system-master: # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562 # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能 url: jdbc:kingbase8://39.98.79.140:54321/ykt_cloud?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true username: root password: 852!@#258 drivername: com.kingbase8.Driver gen: url: jdbc:kingbase8://39.98.79.140:54321/ykt_cloud?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true username: root password: 852!@#258 drivername: com.kingbase8.Driver job: url: jdbc:kingbase8://39.98.79.140:54321/ykt_job?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true username: root password: 852!@#258 drivername: com.kingbase8.Driver workflow: url: jdbc:kingbase8://39.98.79.140:54321/ykt_workflow?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true username: root password: 852!@#258 drivername: com.kingbase8.Driver storage: url: jdbc:kingbase8://39.98.79.140:54321/ykt_storage?currentSchema=dbo&allowEncodingChanges=true&clientEncoding=UTF8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true username: root password: 852!@#258 drivername: com.kingbase8.Driver # system-oracle: # url: jdbc:oracle:thin:@//localhost:1521/XE # username: ROOT # password: password # system-postgres: # url: jdbc:postgresql://localhost:5432/postgres?useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true # username: root # password: password spring: datasource: type: com.zaxxer.hikari.HikariDataSource # 动态数据源文档 https://www.kancloud.cn/tracy5546/dynamic-datasource/content dynamic: # 性能分析插件(有性能损耗 不建议生产环境使用) p6spy: true # 开启seata代理,开启后默认每个数据源都代理,如果某个不需要代理可单独关闭 seata: ${seata.enabled} # 严格模式 匹配不到数据源则报错 strict: true hikari: # 最大连接池数量 maxPoolSize: 20 # 最小空闲线程数量 minIdle: 10 # 配置获取连接等待超时的时间 connectionTimeout: 30000 # 校验超时时间 validationTimeout: 5000 # 空闲连接存活最大时间,默认10分钟 idleTimeout: 600000 # 此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认30分钟 maxLifetime: 1800000 # 多久检查一次连接的活性 keepaliveTime: 30000