db.setting 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  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. remarks = true
  20. # 测试数据源
  21. [test]
  22. url = jdbc:sqlite:test.db
  23. remarks = true
  24. # 测试用HSQLDB数据库
  25. [hsqldb]
  26. url = jdbc:hsqldb:mem:mem_hutool
  27. user = SA
  28. pass =
  29. remarks = true
  30. # 测试用HSQLDB数据库
  31. [h2]
  32. url = jdbc:h2:mem:h2_hutool
  33. user = sa
  34. pass =
  35. remarks = true
  36. # 测试用HSQLDB数据库
  37. [derby]
  38. url = jdbc:derby:.derby/test_db;create=true
  39. remarks = true
  40. # 测试用Oracle数据库
  41. [orcl]
  42. url = jdbc:oracle:thin:@//looly.centos:1521/XE
  43. user = looly
  44. pass = 123456
  45. remarks = true
  46. [mysql]
  47. url = jdbc:mysql://looly.centos8:3306/hutool_test?useSSL=false
  48. user = root
  49. pass = 123456
  50. remarks = true
  51. [postgre]
  52. url = jdbc:postgresql://looly.centos:5432/test_hutool
  53. user = postgres
  54. pass = 123456
  55. remarks = true
  56. [sqlserver]
  57. url = jdbc:sqlserver://looly.database.chinacloudapi.cn:1433;database=test;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.chinacloudapi.cn;loginTimeout=30;
  58. user = looly@looly
  59. pass = 123
  60. remarks = true