inleft
2022-03-02 42b7d05dfdf60ee67c876084a3240ff48a3bf3a5
commit | author | age
9bcb19 1 # Mysql数据库
I 2 spring:
3   datasource:
4     driver-class-name: com.mysql.cj.jdbc.Driver
5     url: jdbc:mysql://localhost:3306/snowy-pub?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT&nullCatalogMeansCurrent=true
6     username: root
7     password: 123456
8   redis:
9     host: localhost
10     port: 6379
11     password:
12
13 # Oracle数据库
14 #spring:
15 #  datasource:
16 #    driver-class-name: oracle.jdbc.OracleDriver
17 #    url: jdbc:oracle:thin:@localhost:1521:xe
18 #    username: SNOWY-PUB-ORACLE
19 #    password: 123456
20
21 # SQLServer配置
22 #spring:
23 #  datasource:
24 #    driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
25 #    url: jdbc:sqlserver://localhost:1433;DatabaseName=snowy-pub-mssql
26 #    username: sa
27 #    password: 123456
28
29 # PostgreSQL配置
30 #spring:
31 #  datasource:
32 #    driverClassName: org.postgresql.Driver
33 #    url: jdbc:postgresql://127.0.0.1:5432/snowy-pub-postgresql
34 #    username: postgres
35 #    password: 123456
36
37 # 达梦数据库
38 #spring:
39 #  datasource:
40 #    driver-class-name: dm.jdbc.driver.DmDriver
41 #    url: jdbc:dm://localhost:5236/snowy-pub-dm
42 #    username: SNOWY
43 #    password: 123456789
44 # #达梦数据库兼容问题,不需要在sql语句前加模式名的解决方法:
45 # #https://blog.csdn.net/myth8860/article/details/100557705
46
47 # 人大金仓数据库
48 #spring:
49 #  datasource:
50 #    driver-class-name: com.kingbase8.Driver
51 #    url: jdbc:kingbase8://localhost:54321/snowy-pub-kingbase
52 #    username: SYSTEM
53 #    password: 123456
54 # #人大金仓数据库兼容问题,不需要加在sql语句中加public的解决方法:
55 # #在根目录data下的kingbase.conf文档里面找到search_path = '"$user",PUBLIC,sys_catalog'进行替换放开
56 # #重启数据库即可完全兼容,注意 sql中不能出现mysql中的关键字的单引号