db.setting 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. # suppress inspection "Annotator" for whole file
  2. #===================================================================
  3. # 数据库配置文件样例
  4. # DsFactory默认读取的配置文件是config/db.setting
  5. # db.setting的配置包括两部分:基本连接信息和连接池配置信息。
  6. # 基本连接信息所有连接池都支持,连接池配置信息根据不同的连接池,连接池配置是根据连接池相应的配置项移植而来
  7. #===================================================================
  8. ## 打印SQL的配置
  9. # 是否在日志中显示执行的SQL,默认false
  10. showSql = true
  11. # 是否格式化显示的SQL,默认false
  12. formatSql = true
  13. # 是否显示SQL参数,默认false
  14. showParams = true
  15. # 打印SQL的日志等级,默认debug
  16. sqlLevel = debug
  17. # 默认数据源
  18. url = jdbc:sqlite:test.db
  19. # 测试数据源
  20. [test]
  21. url = jdbc:sqlite:test.db
  22. # 测试用HSQLDB数据库
  23. [hsqldb]
  24. url = jdbc:hsqldb:mem:mem_hutool
  25. user = SA
  26. pass =
  27. # 测试用HSQLDB数据库
  28. [h2]
  29. url = jdbc:h2:mem:h2_hutool
  30. user = sa
  31. pass =
  32. # 测试用HSQLDB数据库
  33. [derby]
  34. url = jdbc:derby:.derby/test_db;create=true
  35. # 测试用Oracle数据库
  36. [orcl]
  37. url = jdbc:oracle:thin:@//looly.centos:1521/XE
  38. user = looly
  39. pass = 123456
  40. [mysql]
  41. url = jdbc:mysql://looly.centos8:3306/hutool_test?useSSL=false
  42. user = root
  43. pass = 123456
  44. [postgre]
  45. url = jdbc:postgresql://looly.centos:5432/test_hutool
  46. user = postgres
  47. pass = 123456
  48. [sqlserver]
  49. url = jdbc:sqlserver://looly.database.chinacloudapi.cn:1433;database=test;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.chinacloudapi.cn;loginTimeout=30;
  50. user = looly@looly
  51. pass = 123