java - 在请求范围内使用 AspectJ 拦截所有 JDBC 调用并作为响应返回
问题描述
我在为我的数据服务(Spring Boot 应用程序)实现查询分析器以进行调试时遇到问题。任何帮助,将不胜感激。
问题陈述:
我需要返回为特定端点执行的所有数据库查询以及响应。
我的方法:
我创建了一个请求范围组件并在方面自动装配,在请求范围对象中填充查询并将其与响应一起注入。我已经提供了下面所需的所有文件。
问题:
一些端点在多个线程中执行查询。我遇到了错误,但能够使用simpleThreadScope
. 但是我看不到线程执行的任何查询(我可以看到在线程外执行的查询)。你能帮我在响应中的线程内执行查询吗?
AspectJ 配置:
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<executions>
<execution>
<id>default-compile</id>
<phase>none</phase>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>aspectj-maven-plugin</artifactId>
<version>1.7</version>
<configuration>
<aspectDirectory>aspect</aspectDirectory>
<complianceLevel>1.8</complianceLevel>
</configuration>
<dependencies>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjtools</artifactId>
<version>1.8.10</version>
<scope>compile</scope>
</dependency>
</dependencies>
<executions>
<execution>
<!-- Compile and weave aspects after all classes compiled by javac -->
<goals>
<goal>compile</goal>
</goals>
</execution>
</executions>
</plugin>
方面:
@Aspect
@Component
public class QueryProfilerAspect {
private static final Logger logger = LoggerFactory
.getLogger(QueryProfilerAspect.class);
private static String TIME_FORMAT = "HH:mm:ss.SSS";
private static String QUERY_PROFILER = "QueryProfiler";
@Autowired
QueryProfile queryProfile;
@Pointcut("(call(* org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations.query*(..)) && args(query,params,..))")
public void anyJDBCOperations(String query, Map params) {
}
@Pointcut("execution(* *(..)) && @annotation(org.springframework.web.bind.annotation.PostMapping) || @annotation(org.springframework.web.bind.annotation.PutMapping) || @annotation(org.springframework.web.bind.annotation.DeleteMapping) || @annotation(org.springframework.web.bind.annotation.GetMapping)")
private void anyGetPutPostDeleteMappingMethodPointCut() {
// pointcut
}
@Pointcut("execution(* *(..)) && @annotation(org.springframework.web.bind.annotation.RequestMapping)")
private void anyRequestMappingMethodPointCut() {
// pointcut
}
@Around("anyJDBCOperations(sqlQuery, params)")
public Object log(ProceedingJoinPoint jp, String sqlQuery, Map params)
throws Throwable {
long start = System.currentTimeMillis();
Object output = jp.proceed();
long elapsedTime = System.currentTimeMillis() - start;
DataSource dataSource = ((JdbcTemplate) ((NamedParameterJdbcOperations) jp
.getTarget()).getJdbcOperations()).getDataSource();
if (params instanceof Map && !params.isEmpty()) {
logger.debug("inside instance of MAP!!!! ::param {}", params);
sqlQuery = replaceMap(sqlQuery, (Map<?, ?>) params);
}
queryProfile.getQuery().add(sqlQuery);
logger.info("Intercepted Query is::: {}", sqlQuery);
return output;
}
@AfterReturning(value = "anyRequestMappingMethodPointCut() || anyGetPutPostDeleteMappingMethodPointCut()", returning = "returnVal")
public void anyPublicControllerMethod(JoinPoint jp,
ResponseEntity returnVal)
throws Throwable {
HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder
.currentRequestAttributes()).getRequest();
QueryProfile qp = new QueryProfile(queryProfile);
qp.setRequestURL(request.getRequestURL().toString());
qp.setHostName(getHostName());
Object responseBody = returnVal.getBody();
if (responseBody instanceof ResponseDTO) {
List<QueryProfile> profileList = new ArrayList<>();
if (((ResponseDTO) responseBody).getMeta().get(QUERY_PROFILER)
!= null) {
profileList.add((QueryProfile) ((ResponseDTO) responseBody)
.getMeta().get(QUERY_PROFILER));
}
profileList.add(qp);
((ResponseDTO) responseBody)
.addMeta(QUERY_PROFILER, profileList);
}
}
}
请求范围对象:
@Component
@Scope(value = "simpleThreadScope", proxyMode = ScopedProxyMode.TARGET_CLASS)
public class QueryProfile {
private String hostName;
private String requestURL;
private Long duration;
private String time;
private String dataSource;
private List<String> query = new ArrayList<>();
public QueryProfile() {
//Default constructor
}
public QueryProfile(QueryProfile qp) {
setHostName(qp.getHostName());
setRequestURL(qp.getRequestURL());
setDataSource(qp.getDataSource());
setDuration(qp.getDuration());
setTime(qp.getTime());
setQuery(qp.getQuery());
}
public String getHostName() {
return hostName;
}
public void setHostName(String hostName) {
this.hostName = hostName;
}
public String getRequestURL() {
return requestURL;
}
public void setRequestURL(String requestURL) {
this.requestURL = requestURL;
}
public Long getDuration() {
return duration;
}
public void setDuration(Long duration) {
this.duration = duration;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
public String getDataSource() {
return dataSource;
}
public void setDataSource(String dataSource) {
this.dataSource = dataSource;
}
public List<String> getQuery() {
return query;
}
public void setQuery(List<String> query) {
this.query = query;
}
}
SimpleTheradScope
配置:
@Configuration
public class MainConfig implements BeanFactoryAware {
private static final Logger logger = LoggerFactory.getLogger(MainConfig.class);
@Override
public void setBeanFactory(BeanFactory beanFactory) throws BeansException {
if (beanFactory instanceof ConfigurableBeanFactory) {
logger.info("MainConfig is backed by a ConfigurableBeanFactory");
ConfigurableBeanFactory cbf = (ConfigurableBeanFactory) beanFactory;
/*Notice:
*org.springframework.beans.factory.config.Scope
* !=
*org.springframework.context.annotation.Scope
*/
org.springframework.beans.factory.config.Scope simpleThreadScope = new SimpleThreadScope();
cbf.registerScope("simpleThreadScope", simpleThreadScope);
/*why the following? Because "Spring Social" gets the HTTP request's username from
*SecurityContextHolder.getContext().getAuthentication() ... and this
*by default only has a ThreadLocal strategy...
*also see http://stackoverflow.com/a/3468965/923560
*/
SecurityContextHolder.setStrategyName(SecurityContextHolder.MODE_INHERITABLETHREADLOCAL);
}
else {
logger.info("MainConfig is not backed by a ConfigurableBeanFactory");
}
}
}
我的线程执行器类:在类中,我正在创建一个可运行任务列表(调用 DAO 方法来执行查询)并调用下面的类方法来并行执行它们。
public class ThreadUtils {
protected static final Logger logger = LoggerFactory
.getLogger(ThreadUtils.class);
public static void executeInParallel(List<Runnable> runnableTasks) {
ExecutorService executorService = new DelegatingSecurityContextExecutorService(
Executors.newFixedThreadPool(5),
SecurityContextHolder.getContext());
CompletableFuture<?>[] futures = runnableTasks.stream()
.map(task -> CompletableFuture.runAsync(task, executorService))
.toArray(CompletableFuture[]::new);
CompletableFuture.allOf(futures).join();
executorService.shutdown();
}
我的回应是:
"data":{},
"meta": {
"QueryProfiler": [
{
"hostName": "xxx.xx.com",
"requestURL": "http://localhost:7010/abc/5",
"duration": null,
"time": null,
"dataSource": null,
"query": [
"SELECT * FROM table1",
"SELECT COUNT(1) FROM table2 WHERE abc = 1 AND def = 2"
]
}
]
}
解决方案
我通过放弃请求范围对象并实现InheritableThreadLocal
. 该变量还具有将上下文委托给其子线程的属性。所以在我的方面使用一个InheritableThreadLocal
变量并向变量添加查询,我能够在返回响应的同时注入变量。
除了上面的代码,我还添加了以下代码以使其工作:
private static InheritableThreadLocal<QueryProfile> queryProfile = new InheritableThreadLocal<>();
public static QueryProfile getQueryProfile(){
if(queryProfile.get() == null){
queryProfile.set(new QueryProfile());
logger.info("Profiler is null. Setting with new value");
}
return queryProfile.get();
}
public static void setQueryProfile(QueryProfile qp){
queryProfile.set(qp);
}
推荐阅读
- macos - 为什么当我尝试使用 grep ether 过滤 ifconfig 结果以仅显示媒体显示的 MAC 地址时?
- selenium - Selenium:等到属性值改变
- python - 如何根据用户输入自动添加唯一键,然后在python中更新它
- c# - FromBody 收到的帖子导致可序列化错误
- typescript - 使用映射类型返回函数返回类型的对象
- android - 如何使用用户幻灯片使动画进度
- python - python解析文本并添加到列表
- spring - JPA Hibernate 无法将 java.lang.String 字段设置为 java.lang.String 异常
- swift - 检查数组中的多个值
- javascript - 如何根据php中的搜索条件在动态表中显示