| commit | author | age | ||
| 9bcb19 | 1 | JwtAuthenticationTokenFilter# 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中的关键字的单引号 | |
