데이터베이스를 사랑하는 사람들의 모임 데이터베이스 사랑넷

Database

DBMS

ㆍMySQL

PostgreSQL

Community

Admin

MySQL Q&A 31197 게시물 읽기

No. 31197

쿼리문 인터셉터 질문드립니다 ㅠ
작성자	김영욱(ywkim06)	작성일	2018-11-13 11:23	조회수	2,460

업데이트나 인설트 델리트 쿼리가 실행될때마다 쿼리문을 인터셉터하여 디비에 저장하려고 하는데 ㅠ

실행하면 아래와 같은 오류가 뜹니다 ㅠ 값은 제대로 들어가는거 같은데 모가 문제 일까요 ㅠㅠ

package com.twayair.lime.comm.interceptor;

import java.util.Properties;

import javax.annotation.Resource;

import org.apache.ibatis.cache.CacheKey;

import org.apache.ibatis.executor.Executor;

import org.apache.ibatis.mapping.BoundSql;

import org.apache.ibatis.mapping.MappedStatement;

import org.apache.ibatis.plugin.Interceptor;

import org.apache.ibatis.plugin.Intercepts;

import org.apache.ibatis.plugin.Invocation;

import org.apache.ibatis.plugin.Plugin;

import org.apache.ibatis.plugin.Signature;

import org.apache.ibatis.session.ResultHandler;

import org.apache.ibatis.session.RowBounds;

import org.apache.log4j.LogManager;

import org.apache.log4j.Logger;

import org.springframework.stereotype.Controller;

import com.twayair.lime.comm.user.domain.SqlInterBean;

import com.twayair.lime.comm.user.repository.LIME02000Mapper;

@Intercepts({ @Signature(type = Executor.class, method = "update", args = { MappedStatement.class, Object.class }),

@Signature(type = Executor.class, method = "query", args = { MappedStatement.class, Object.class,

RowBounds.class, ResultHandler.class, CacheKey.class, BoundSql.class }),

@Signature(type = Executor.class, method = "query", args = { MappedStatement.class, Object.class,

RowBounds.class, ResultHandler.class }) })

@Controller

public class QueryInterceptor implements Interceptor {

@Resource(name="com.twayair.lime.comm.user.repository.LIME02000Mapper")

private LIME02000Mapper limemapper;

private Logger log = LogManager.getLogger(getClass());

SqlInterBean sqlVo = new SqlInterBean();

@Override

public Object intercept(Invocation invocation) throws Throwable {

Object[] args = invocation.getArgs();

MappedStatement ms = (MappedStatement) args[0];

Object param = (Object) args[1];

BoundSql boundSql = ms.getBoundSql(param);

// System.out.println("====================================");

// System.out.println(invocation.getMethod().getName());

// System.out.println("====================================1");

// System.out.println(ms.getId());

// System.out.println("====================================2");

// System.out.println(boundSql.getSql());

String sql_save = boundSql.getSql();

if (sql_save.indexOf("INSERT") != -1) {

sqlVo.setConnection_ip("test1");

sqlVo.setUser_id("admin");

sqlVo.setExecute_sql(sql_save);

limemapper.sqlinsert(sqlVo);

}else if(sql_save.indexOf("UPDATE") != -1) {

sqlVo.setConnection_ip("test1");

sqlVo.setUser_id("admin");

sqlVo.setExecute_sql(sql_save);

limemapper.sqlinsert(sqlVo);

}else if(sql_save.indexOf("DELETE") != -1) {

sqlVo.setConnection_ip("test1");

sqlVo.setUser_id("admin");

sqlVo.setExecute_sql(sql_save);

limemapper.sqlinsert(sqlVo);

}else {

System.out.println("SELECT");

}

// System.out.println("====================================3");

// System.out.println(param);

// System.out.println("====================================4");

log.debug(ms.getId());

return invocation.proceed();

}

@Override

public Object plugin(Object target) {

return Plugin.wrap(target, this);

}

@Override

public void setProperties(Properties properties) {

}

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

### Error updating database. Cause: java.lang.NullPointerException

### Cause: java.lang.NullPointerException

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy20.update(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:59)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)

at com.sun.proxy.$Proxy25.upAppmInfoData(Unknown Source)

at com.twayair.lime.comm.user.service.LimeServiceImpl.upAppmInfoData(LimeServiceImpl.java:131)

at com.twayair.lime.comm.user.service.LimeServiceImpl$$FastClassByCGLIB$$acf0a19.invoke(<generated>)

at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)

at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)

at com.twayair.lime.comm.user.service.LimeServiceImpl$$EnhancerByCGLIB$$49a683a4.upAppmInfoData(<generated>)

at com.twayair.lime.comm.user.controller.LimcommController.AppMSaveUp(LimcommController.java:511)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.zkoss.bind.impl.ParamCall.call(ParamCall.java:149)

at org.zkoss.bind.impl.BinderImpl.handleNotifyChange(BinderImpl.java:1851)

at org.zkoss.bind.impl.BinderImpl.doExecute(BinderImpl.java:2020)

at org.zkoss.bind.impl.BinderImpl.doCommand(BinderImpl.java:1747)

at org.zkoss.bind.impl.BinderImpl.access$1300(BinderImpl.java:130)

at org.zkoss.bind.impl.BinderImpl$CommandEventListener.onEvent0(BinderImpl.java:1594)

at org.zkoss.bind.impl.BinderImpl$CommandEventListener.onEvent(BinderImpl.java:1547)

at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:3162)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3132)

at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3074)

at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138)

at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1846)

at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1618)

at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1321)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:606)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482)

at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:490)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:125)

at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:65)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:491)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:764)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1388)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: java.lang.NullPointerException

### Cause: java.lang.NullPointerException

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)

... 67 common frames omitted

Caused by: java.lang.NullPointerException

at com.twayair.lime.comm.interceptor.QueryInterceptor.intercept(QueryInterceptor.java:63)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

at com.sun.proxy.$Proxy38.update(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)

... 72 common frames omitted

11:18:04.201 [http-nio-8080-exec-6] ERROR org.zkoss.bind.impl.BinderImpl - nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: java.lang.NullPointerException

### Cause: java.lang.NullPointerException

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: