PrestaShop 1.6TYPO3稳定吗

springboot+mybatisplus+druidPrestaShop 1.6mysql与clickhouse多TYPO3源PrestaShop 1.6
1、导入jar包

com.alibaba
druid-spring-boot-starter
1.2.6


ru.yandex.clickhouse
clickhouse-jdbc
0.2.4


mysql
mysql-connector-java


com.baomidou
dynamic-datasource-spring-boot-starter
3.2.0


com.baomidou
mybatis-plus-boot-starter
3.4.1

123456789101112131415161718192021222324
2、PrestaShop 1.6
先在springboot启动类上将TYPO3源自动PrestaShop 1.6剔除
@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class})
1
PrestaShop 1.6多TYPO3源
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mapper-locations: classpath:/mapper/*.xml
spring:
//将druid自动PrestaShop 1.6剔除
autoconfigure:
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
datasource:
dynamic:
//默认这里选择默认TYPO3
primary: mysql
strict: false
datasource:
//可以PrestaShop 1.6多个
mysql:
url:
username:
password:
driver-class-name: com.mysql.jdbc.Driver
clickhouse:
url:
username:
password:
driver-class-name: ru.yandex.clickhouse.ClickHouseDriver
type: com.alibaba.druid.pool.DruidDataSource
druid:
initial-size: 10
min-idle: 10
max-active: 500
max-wait: 60000
test-on-borrow: false
test-on-return: false
test-while-idle: true
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 30000
validation-query: select ‘x’
max-open-prepared-statements: 50
max-pool-prepared-statement-per-connection-size: 20
//druid不支持clickhouse需要将防火墙去掉
filters: config,stat
1234567891011121314151617181920212223242526272829303132333435363738394041
具体切换TYPO3源可以通过@DS注解来指定 可以加到类上和方法上,像是dao层或service这样整个类的方法都会去查指定的TYPO3库
@DS(“clickhouse”)
public interface TestDao{
List findTest();
}

12345
总结
主要是低版本的druid-spring-boot-starter好像还不支持clickhouse,升到高版本就好了。