1.MyByatis通过多数据源的方式集成ODPS
1.1 新增配置文件
# datasource-saas
spring.datasource.names = odps
spring.datasource.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name = com.mysql.cj.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&serverTimezone=GMT%2B8&allowMultiQueries=true
spring.datasource.username = test
spring.datasource.password = test
spring.datasource.max-total = 100
# datasource-odps
spring.datasource.odps.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.odps.driverClassName = com.aliyun.odps.jdbc.OdpsDriver
spring.datasource.odps.url = jdbc:odps:http://10.0.0.0/api?project=test&characterEncoding=UTF-8
spring.datasource.odps.username = accessId
spring.datasource.odps.password = accessKey
spring.datasource.odps.druid.defaultAutoCommit = true
spring.datasource.odps.druid.initialSize = 5
spring.datasource.odps.druid.minIdle = 5
spring.datasource.odps.druid.maxActive = 20
spring.datasource.odps.druid.maxWait = 60000
spring.datasource.odps.druid.timeBetweenEvictionRunsMillis = 60000
spring.datasource.odps.druid.minEvictableIdleTimeMillis = 300000
spring.datasource.odps.druid.validationQuery = SELECT 1
spring.datasource.odps.druid.testWhileIdle = true
spring.datasource.odps.druid.testOnBorrow = false
spring.datasource.odps.druid.testOnReturn = false
spring.datasource.odps.druid.poolPreparedStatements = true
spring.datasource.odps.druid.maxPoolPreparedStatementPerConnectionSize = 20
spring.datasource.odps.druid.filters = stat,wall,log4j
spring.datasource.odps.druid.connectionProperties = druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
spring.datasource.odps.druid.useGlobalDataSourceStat = true
1.2 增加代码配置
新增4个类和1个接口
package com.rada.framework.datasource;
import org.slf4j.LoggerFactory;
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
import java.sql.SQLFeatureNotSupportedException;
import java.util.logging.Logger;
public class DynamicDataSource extends AbstractRoutingDataSource {
@Override
protected Object determineCurrentLookupKey() {
return DynamicDataSourceContextHolder.getDataSourceType();
}
}
package com.rada.framework.datasource;
import org.apache.logging.log4j.core.config.Order;
import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.annotation.After;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Before;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Component;
@Aspect
@Order(-1)// 保证该AOP在@Tran