springmvc 多事务提交和回滚
1 jdbc.properties
# mysql
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql://192.168.1.xxx:3306/kintech_bo
jdbc.user=root
jdbc.password=root
jdbc.initialPoolSize=3
jdbc.miniPoolSize=3
jdbc.maxPoolSize=200
jdbc.maxIdleTime=20
jdbc.idleConnectionTestPeriod=60
jdbc.sqlserver.initialPoolSize=1
jdbc.sqlserver.miniPoolSize=1
jdbc.sqlserver.maxPoolSize=200
jdbc.sqlserver.maxIdleTime=20
jdbc.sqlserver.idleConnectionTestPeriod=60
# sqlserver
sqlserver.gica.driver= com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver.gica.jdbcUrl= jdbc:sqlserver://192.168.1.xxx:1433;DatabaseName=logisoft;useSSL=false
sqlserver.gica.user= sa
sqlserver.gica.password= sasa
#hibernate config
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=false
hibernate.format_sql=true
#hibernate.hbm2ddl.auto =update
hibernate.hbm2ddl.auto=none
hibernate.cache.use_second_level_cache=false
hibernate.cache.use_query_cache=false
hibernate.cache.provider_class=net.sf.ehcache.hibernate.EhCacheProvider
hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.EhCacheRegionFactory
2 spring配置
重点:
${hibernate.hbm2ddl.auto}
${hibernate.dialect}
${hibernate.show_sql}
${hibernate.format_sql}
${hibernate.cache.use_second_level_cache}
${hibernate.cache.use_query_cache}
${hibernate.cache.provider_class}
${hibernate.cache.region.factory_class}
true
thread
none
true
true
org.hibernate.cfg.ImprovedNamingStrategy
after_statement
3
18
10
false
false
org.hibernate.cache.NoCacheProvider
none
after_statement
3 添加@Transactional
相关方法都记得加上@Transactional