springboot applicaton.properties配置多种数据源

[html] view plain copy

print ?

1. #######################  DB Connection Config  #######################  
2.   
3.   
4. ###—————– DB Type —————–  
5. #the database of the application:mysql|sqlserver|oracle  
6. databaseType=mysql  
7. #databaseType=sqlserver  
8. #databaseType=oracle  
9.   
10.   
11. ###—————– MySQL5+ —————–  
12. jdbc.driverClassName=com.mysql.jdbc.Driver  
13. jdbc.url=jdbc:mysql://192.168.1.253:3306/ssh_annotaction?useUnicode=true&characterEncoding=utf-8  
14. jdbc.username=root  
15. jdbc.password=123456  
16. hibernate.dialect=org.hibernate.dialect.MySQLDialect  
17.   
18.   
19. ###—————– SqlServer2005+ —————–  
20. #jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver  
21. #jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=sampledb  
22. #jdbc.username=sa  
23. #jdbc.password=123456  
24. #hibernate.dialect=org.hibernate.dialect.SQLServerDialect  
25.   
26.   
27. ###—————– Oracle10g+ —————–  
28. #jdbc.driverClassName=oracle.jdbc.driver.OracleDriver  
29. #jdbc.url=jdbc:oracle:thin:@localhost:1521:orac10g  
30. #jdbc.username=scott  
31. #jdbc.password=scott123  
32. #hibernate.dialect=org.hibernate.dialect.OracleDialect  
33.   
34.   
35. ###—————– JNDI —————–  
36. #jndi.name=myjndi123  
37.   
38.   
39. ###—————– Hibernate —————–  
40. hibernate.show_sql=true  
41. hibernate.format_sql=true  
42. hibernate.hbm2ddl.auto=update  
43. hibernate.jdbc.fetch_size=100  
44. hibernate.jdbc.batch_size=20  
45.   
46. hibernate.cache.use_second_level_cache=true  
47. hibernate.cache.use_query_cache=true  
48. hibernate.memcached.cacheTimeSeconds=10800  
49. #Hibernate4  
50. hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheRegionFactory  
51. #Hibernate3  
52. #hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheProvider  
53.   
54.   
55. ###—————– C3P0 —————–  
56. c3p0.maxPoolSize=50  
57. c3p0.minPoolSize=1  
58. c3p0.initialPoolSize=1  
59. c3p0.maxIdleTime=20  
60.   
61.   
62. ###—————– DBCP —————–  
63. dbcp.maxActive=50  
64. dbcp.maxIdle=50  
65. dbcp.minIdle=1  
66. dbcp.maxWait=10000  
67. dbcp.initialSize=1  

#######################  DB Connection Config  #######################

----------------- DB Type -----------------

the database of the application:mysql|sqlserver|oracle

databaseType=mysql

databaseType=sqlserver

databaseType=oracle

----------------- MySQL5+ -----------------

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://192.168.1.253:3306/ssh_annotaction?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
hibernate.dialect=org.hibernate.dialect.MySQLDialect

----------------- SqlServer2005+ -----------------

jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=sampledb

jdbc.username=sa

jdbc.password=123456

hibernate.dialect=org.hibernate.dialect.SQLServerDialect

----------------- Oracle10g+ -----------------

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

jdbc.url=jdbc:oracle:thin:@localhost:1521:orac10g

jdbc.username=scott

jdbc.password=scott123

hibernate.dialect=org.hibernate.dialect.OracleDialect

----------------- JNDI -----------------

jndi.name=myjndi123

----------------- Hibernate -----------------

hibernate.show_sql=true
hibernate.format_sql=true
hibernate.hbm2ddl.auto=update
hibernate.jdbc.fetch_size=100
hibernate.jdbc.batch_size=20

hibernate.cache.use_second_level_cache=true
hibernate.cache.use_query_cache=true
hibernate.memcached.cacheTimeSeconds=10800

Hibernate4

hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheRegionFactory

Hibernate3

hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheProvider

----------------- C3P0 -----------------

c3p0.maxPoolSize=50
c3p0.minPoolSize=1
c3p0.initialPoolSize=1
c3p0.maxIdleTime=20

----------------- DBCP -----------------

dbcp.maxActive=50
dbcp.maxIdle=50
dbcp.minIdle=1
dbcp.maxWait=10000
dbcp.initialSize=1