JPA 동적 LIKE 의 List parameter 도움 부탁드립니다...

Question

@Query(value = "SELECT g FROM GoodsVO g " + "WHERE ( :_name is null OR g.name LIKE %:_name% ) " + "AND ( :_categories is null OR g.goodsCategoryCode LIKE :_categories% ) " + "AND ( :_brands is null OR g.brandCode LIKE :_brands% ) " + "AND ( :_innerText is null OR g.name LIKE %:_innerText% ) " + "AND ( :_outterText is null OR g.name NOT LIKE %:_outterText% ) " + "AND ( (:_minPrice is null AND :_maxPrice is null) OR (g.sellPrice BETWEEN :_minPrice AND :_maxPrice ) ) " ) Page findBySearch( @Param("_name") String _name, @Param("_categories") List _categories, @Param("_brands") List _brands, @Param("_innerText") String _innerText, @Param("_outterText") String _outterText, @Param("_minPrice") List _minPrice, @Param("_maxPrice") List _maxPrice, Pageable pageable ); JpaRepository 의 함수입니다. List 파라미터에서 1개씩만 들어가면 검색이 되는데...List 파라미터에 2개 이상의 값이 들어가면 에러가 나네요.. List의 갯수대로 LIKE 문이 추가 실행이 되어야 하는데... 하이버네이트도 처음 써보지만로그도 처음보는 에러라 이거 참...혹여 아시면 도움 부탁드립니다.. 2019-05-30 16:16:58.374 DEBUG 19544 --- [apr-8080-exec-1] o.s.web.servlet.DispatcherServlet : Failed to complete request: org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ] 2019-05-30 16:16:58.375 ERROR 19544 --- [apr-8080-exec-1] o.s.b.w.servlet.support.ErrorPageFilter : Forwarding to error page from request [/api/goods/search] due to exception [org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ]] org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ] at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:373) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135) ~[spring-data-jpa-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61) ~[spring-data-commons-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at com.sun.proxy.$Proxy132.findBySearch(Unknown Source) ~[na:na] at com.humanwares.web.shop.apis.searcher.SearcherService.searchGoods(SearcherService.java:99) ~[classes/:na] at com.humanwares.web.shop.apis.searcher.SearcherService$$FastClassBySpringCGLIB$$c83cb156.invoke() ~[classes/:na] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at com.humanwares.web.shop.apis.searcher.SearcherService$$EnhancerBySpringCGLIB$$48563608.searchGoods() ~[classes/:na] at com.humanwares.web.shop.apis.goods.GoodsRestController.Search(GoodsRestController.java:69) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_201] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_201] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_201] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) ~[servlet-api.jar:na] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.5.RELEASE.jar:5.1.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) ~[servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-websocket.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at com.humanwares.web.config.RestfulFilter.doFilter(RestfulFilter.java:27) ~[classes/:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE] at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE] at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123) [spring-boot-2.1.3.RELEASE.jar:2.1.3.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.30] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.30] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [catalina.jar:8.0.30] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [catalina.jar:8.0.30] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) [catalina.jar:8.0.30] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [catalina.jar:8.0.30] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.30] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) [catalina.jar:8.0.30] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.30] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521) [catalina.jar:8.0.30] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096) [tomcat-coyote.jar:8.0.30] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674) [tomcat-coyote.jar:8.0.30] at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500) [tomcat-coyote.jar:8.0.30] at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489) [tomcat-coyote.jar:8.0.30] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.30] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_201] Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1514) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.query.Query.getResultList(Query.java:135) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.springframework.data.jpa.repository.query.JpaQueryExecution$PagedExecution.doExecute(JpaQueryExecution.java:194) ~[spring-data-jpa-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:91) ~[spring-data-jpa-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:136) ~[spring-data-jpa-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:125) ~[spring-data-jpa-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:605) ~[spring-data-commons-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$invoke$3(RepositoryFactorySupport.java:595) ~[spring-data-commons-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:595) ~[spring-data-commons-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59) ~[spring-data-commons-2.1.5.RELEASE.jar:2.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] ... 84 common frames omitted Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: {vector} [SELECT g FROM com.humanwares.web.shop.goods.GoodsVO g WHERE ( :_name is null OR g.name LIKE :_name ) AND ( :_categories_0, :_categories_1 is null OR g.goodsCategoryCode LIKE (:_categories_0, :_categories_1) ) AND ( :_brands_0, :_brands_1 is null OR g.brandCode LIKE (:_brands_0, :_brands_1) ) AND ( :_innerText is null OR g.name LIKE :_innerText ) AND ( :_outterText is null OR g.name NOT LIKE :_outterText ) AND ( (:_minPrice_0, :_minPrice_1 is null AND (:_maxPrice_0, :_maxPrice_1) is null) OR (g.sellPrice BETWEEN (:_minPrice_0, :_minPrice_1) AND (:_maxPrice_0, :_maxPrice_1) ) ) ] at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:277) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:191) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:143) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:119) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:80) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:595) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1498) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final] ... 99 common frames omitted 2019-05-30 16:16:58.396 DEBUG 19544 --- [apr-8080-exec-1] o.s.web.servlet.DispatcherServlet : "FORWARD" dispatch for GET "/error?searchText=%EC%9D%B8&checkedCateList=020101,0203&checkedBrandList=0101,0102&checkedPriceList=2030,4050&minPrice=0&maxPrice=0&innerType=include&innerText=", parameters={checkedCateList:[020101,0203], searchText:[인], innerText:[], minPrice:[0], innerType:[include], checkedBrandList:[0101,0102], maxPrice:[0], checkedPriceList:[2030,4050]} 2019-05-30 16:16:58.397 DEBUG 19544 --- [apr-8080-exec-1] s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped to public org.springframework.http.ResponseEntity> org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController.error(javax.servlet.http.HttpServletRequest) 2019-05-30 16:16:58.398 DEBUG 19544 --- [apr-8080-exec-1] o.s.w.s.m.m.a.HttpEntityMethodProcessor : Using 'application/json', given [application/json, text/plain, */*] and supported [application/json, application/*+json, application/json, application/*+json] 2019-05-30 16:16:58.398 DEBUG 19544 --- [apr-8080-exec-1] o.s.w.s.m.m.a.HttpEntityMethodProcessor : Writing [{timestamp=Thu May 30 16:16:58 KST 2019, status=500, error=Internal Server Error, message=org.hibern (truncated)...] 2019-05-30 16:16:58.398 DEBUG 19544 --- [apr-8080-exec-1] o.s.web.servlet.DispatcherServlet : Exiting from "FORWARD" dispatch, status 500

ShipJH · Answer

QueryDsl 을 사용하시는건 어떤가요..동적인 where 절은 그렇게 처리하지 않으면 제약사항이 좀 많은 걸로 알고 있습니다.

khane7 · Answer

&#64;ShipJH적용 과정이 길어서 급하게 Query String 을 만들어서nativeQuery &#61; true 로 해서 실행 문제는 해결을 했는데..이렇게 하니 또 캐시가 문제네요..쿼리 로그 찍은걸로 직접 조회하면 데이터가 안나와야 정상인데... 데이터가 계속 나오네요 ㅠㅜ 이게 웬일인지 원...

JPA 동적 LIKE 의 List parameter 도움 부탁드립니다...

2개의 답변

#like 목록