스프링부트 의존성 주입 오류로 lazy사용했는데도 오류가 발생합니다

Question

package com.rmtech.admin; import java.io.IOException; import javax.sql.DataSource; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.ApplicationContext; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Lazy; import org.springframework.jdbc.datasource.DriverManagerDataSource; import com.rmtech.admin.mapper.ApisMapper; import com.rmtech.admin.util.MybatisInterceptor; @Configuration @MapperScan(basePackages = "com.rmtech.admin.mapper") public class MybatisConfig { @Value("${spring.datasource.driver-class-name}") private String driverClassName; @Value("${spring.datasource.url}") private String url; @Value("${spring.datasource.username}") private String username; @Value("${spring.datasource.password}") private String password; @Value("${mybatis.config-location}") private String configLocation; @Value("${mybatis.mapper-locations}") private String mapperLocation; @Autowired ApplicationContext applicationContext; private final ApisMapper apisMapper; @Lazy public MybatisConfig(ApisMapper apisMapper) { this.apisMapper = apisMapper; } @Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName(driverClassName); dataSource.setUrl(url); dataSource.setUsername(username); dataSource.setPassword(password); return dataSource; } @Bean public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) throws IOException { SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean(); factoryBean.setDataSource(dataSource); factoryBean.setPlugins(new MybatisInterceptor(apisMapper)); factoryBean.setConfigLocation(applicationContext.getResource(configLocation)); factoryBean.setMapperLocations(applicationContext.getResources(mapperLocation)); return factoryBean; } @Bean public SqlSessionTemplate sqlSession(SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } package com.rmtech.admin.util; import java.lang.reflect.Field; import java.time.LocalDate; import java.time.LocalDateTime; import java.util.List; import java.util.Map; import java.util.function.BiConsumer; import org.apache.ibatis.executor.Executor; import org.apache.ibatis.mapping.BoundSql; import org.apache.ibatis.mapping.MappedStatement; import org.apache.ibatis.mapping.ParameterMapping; import org.apache.ibatis.plugin.Interceptor; import org.apache.ibatis.plugin.Intercepts; import org.apache.ibatis.plugin.Invocation; import org.apache.ibatis.plugin.Signature; import org.springframework.context.annotation.Lazy; import org.springframework.util.ReflectionUtils; import com.rmtech.admin.mapper.ApisMapper; @Intercepts(@Signature(type=Executor.class, method="update", args= {MappedStatement.class, Object.class})) public class MybatisInterceptor implements Interceptor { private final ApisMapper apisMapper; @Lazy public MybatisInterceptor(ApisMapper apisMapper) { this.apisMapper = apisMapper; } @Override public Object intercept(Invocation invocation) throws Throwable { Object paramObj = invocation.getArgs()[1]; MappedStatement statement = (MappedStatement)invocation.getArgs()[0]; try { BoundSql boundSql = statement.getBoundSql(paramObj); String paramSql = getParamBindSQL(boundSql); apisMapper.insertQueryLog(paramSql); return invocation.proceed(); }catch (NoSuchFieldException nsf){ return invocation.proceed(); } } // 파라미터 sql 바인딩 처리 public String getParamBindSQL(BoundSql boundSql) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException { Object parameterObject = boundSql.getParameterObject(); StringBuilder sqlStringBuilder = new StringBuilder(boundSql.getSql()); // stringBuilder 파라미터 replace 처리 BiConsumer sqlObjectReplace = (sqlSb, value) -> { int questionIdx = sqlSb.indexOf("?"); if(questionIdx == -1) { return; } if(value == null) { sqlSb.replace(questionIdx, questionIdx + 1, "null /**P*/"); } else if(value instanceof String || value instanceof LocalDate || value instanceof LocalDateTime || value instanceof Enum) { sqlSb.replace(questionIdx, questionIdx + 1, "'" + (value != null ? value.toString() : "") + "' /**P*/"); } else { sqlSb.replace(questionIdx, questionIdx + 1, value.toString() + " /**P*/"); } }; if(parameterObject == null) { sqlObjectReplace.accept(sqlStringBuilder, null); } else { if(parameterObject instanceof Integer || parameterObject instanceof Long || parameterObject instanceof Float || parameterObject instanceof Double || parameterObject instanceof String) { sqlObjectReplace.accept(sqlStringBuilder, parameterObject); } else if(parameterObject instanceof Map) { Map paramterObjectMap = (Map)parameterObject; List paramMappings = boundSql.getParameterMappings(); for (ParameterMapping parameterMapping : paramMappings) { String propertyKey = parameterMapping.getProperty(); try { Object paramValue = null; if(boundSql.hasAdditionalParameter(propertyKey)) { // 동적 SQL로 인해 __frch_item_0 같은 파라미터가 생성되어 적재됨, additionalParameter로 획득 paramValue = boundSql.getAdditionalParameter(propertyKey); } else { paramValue = paramterObjectMap.get(propertyKey); } sqlObjectReplace.accept(sqlStringBuilder, paramValue); } catch (Exception e) { sqlObjectReplace.accept(sqlStringBuilder, "[cannot binding : " + propertyKey+ "]"); } } } else { List paramMappings = boundSql.getParameterMappings(); Class< ? extends Object> paramClass = parameterObject.getClass(); for (ParameterMapping parameterMapping : paramMappings) { String propertyKey = parameterMapping.getProperty(); try { Object paramValue = null; if(boundSql.hasAdditionalParameter(propertyKey)) { // 동적 SQL로 인해 __frch_item_0 같은 파라미터가 생성되어 적재됨, additionalParameter로 획득 paramValue = boundSql.getAdditionalParameter(propertyKey); } else { Field field = ReflectionUtils.findField(paramClass, propertyKey); field.setAccessible(true); paramValue = field.get(parameterObject); } sqlObjectReplace.accept(sqlStringBuilder, paramValue); } catch (Exception e) { sqlObjectReplace.accept(sqlStringBuilder, "[cannot binding : " + propertyKey+ "]"); } } } } return sqlStringBuilder.toString().replaceAll("([\r\n\s]){2,}([\r\n])+"," "); } }package com.rmtech.admin.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import com.rmtech.admin.apis.vo.ApisVO; @Mapper public interface ApisMapper { public List selectManual( @Param("mmcategoryml1") String mmcategoryml1, @Param("mmmenuml1") String mmmenuml1); public void insertQueryLog(String queryLog); } insertQueryLog가 여러번 반복되는데 실행이 안되는 오류가 발생합니다. @lazy를 잘못 설정한 문제인건가요?

Clickin · Answer

insertQueryLog는 XML 안에서 #{value} 로 매핑하고계신 게 맞나요?

개발잡부 · Answer

webconfig에서 파라미터를 어떻게 넣고 있나요? 인터셉터 등록하는 부분

개발잡부 · Answer

WebConfig 만들기 싫으시면 Interceptor에 @Component 어노테이션 붙여서 빈등록 해도 별 문제는 없습니다

스프링부트 의존성 주입 오류로 lazy사용했는데도 오류가 발생합니다

3개의 답변

Q&A 목록